Unable to connect to the SQL Server 2008 Express with visual Studio 2008 Express

Discussion in 'microsoft.public.sqlserver.newusers' started by Phillip Windell, Mar 30, 2009.

  1. As the subject says, I am running VS2008Exp (the ASP.net component
    particularly) and am unable to connect to the SQL Server 2008 Express that
    is runing directly on the same machine. This is a fresh clean install of
    the whole entire machine,..the OS, SQL2008Express, and VS2008Express.

    The even log on the machine has these two entries. I have google for them
    reason for about two days now and have not found anything solid.

    Event Type: Failure Audit
    Event Source: MSSQL$SQLEXPRESS
    Event Category: Logon
    Event ID: 18456
    Date: 3/30/2009
    Time: 8:22:46 AM
    User: NT AUTHORITY\SYSTEM
    Computer: VSDEV
    Description:
    Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the
    explicitly specified database. [CLIENT: <local machine>]

    For more information, see Help and Support Center at
    http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 18 48 00 00 0e 00 00 00 .H......
    0008: 11 00 00 00 56 00 53 00 ....V.S.
    0010: 44 00 45 00 56 00 5c 00 D.E.V.\.
    0018: 53 00 51 00 4c 00 45 00 S.Q.L.E.
    0020: 58 00 50 00 52 00 45 00 X.P.R.E.
    0028: 53 00 53 00 00 00 07 00 S.S.....
    0030: 00 00 6d 00 61 00 73 00 ..m.a.s.
    0038: 74 00 65 00 72 00 00 00 t.e.r...

    Event Type: Error
    Event Source: Report Server Windows Service (SQLEXPRESS)
    Event Category: Management
    Event ID: 107
    Date: 3/30/2009
    Time: 8:22:46 AM
    User: N/A
    Computer: VSDEV
    Description:
    Report Server Windows Service (SQLEXPRESS) cannot connect to the report
    server database.

    For more information, see Help and Support Center at
    http://go.microsoft.com/fwlink/events.asp.



    --
    Phillip Windell
    www.wandtv.com

    The views expressed, are my own and not those of my employer, or Microsoft,
    or anyone else associated with me, including my cats.
    -----------------------------------------------------
     
    Phillip Windell, Mar 30, 2009
    #1
    1. Advertisements

  2. Well, I'm not sure how, but I seem to have it working now. The only thing I
    think I did that actually changed anything was to enable and then start the
    SQL Server Browser. Could that have been all it was? I don't remember ever
    having to use that in the past.

    I also have to look into a good grammar checker,...my original post was
    horrible :)


    --
    Phillip Windell
    www.wandtv.com

    The views expressed, are my own and not those of my employer, or Microsoft,
    or anyone else associated with me, including my cats.
     
    Phillip Windell, Mar 30, 2009
    #2
    1. Advertisements

  3. The Event Log entries still happen. I would still like to clear those up if
    anyone has any ideas. I did make the SQL Reporting Service "dependent" on
    the main SQL Server Service because I read that it had an issue of trying to
    start up too soon,...but that never helped.


    --
    Phillip Windell
    www.wandtv.com

    The views expressed, are my own and not those of my employer, or Microsoft,
    or anyone else associated with me, including my cats.
    -----------------------------------------------------

     
    Phillip Windell, Mar 30, 2009
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.