Post reply

SqlServer2008+IIS7.0+windowsServer2008 connection error

  • January 8, 2010 at 6:21 am

    #214338

    Hi,

    I'm configuring a new server with windows server 2008, sql server express 2008 ans IIs7.0.

    I can not connect to database from webservice, it always return the error:

    Connection error:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    I've tried:

    - enable tcp/ip

    - enable named pipes

    - add sql server to firewall exceptions(port 1433, sqlservr.exe, sqlbrowser.exe)

    - disable firewall

    - disable anti virus

    And nothing..it continues returning the connection error.

    Any help on this?

    Thanks a lot!

  • January 8, 2010 at 7:35 am

    #1100876

    Did you bounce the server? I've run into the same thing and a reboot fixed it. I assume if you are running express that it's not a critical box and you can bounce it and report back.

  • January 8, 2010 at 7:56 am

    #1100903

    I tryed reboot the server and it works! Thanks! 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply