SqlServer2008+IIS7.0+windowsServer2008 connection error

• amns

  SSCrazy

  Points: 2628

  More actions

  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!

• Rome1981

  SSC-Addicted

  Points: 455

  More actions

  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.

• amns

  SSCrazy

  Points: 2628

  More actions

  January 8, 2010 at 7:56 am

  #1100903

  I tryed reboot the server and it works! Thanks!