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.

I have a server named: virtualA\virtualSQLA. This server was working fine a few days ago but after a server reboot, it was giving the above error message. I was able to connect via its virtual name (virtualA) and virtualA\virtualSQLA,1433 but not virtualA\virtualSQLA. After 20 minutes of looking around ….

Check that SQLBrowser service is running!!!!!!

Recent Entries

• C# - initialize a variable
• Return a status or value from sp_start_job
• iPhone 3G
• Creating Windows Clustered Resources
• changing sql services password
• sql 2005 connection error
• finding a bunch of server’s ip address
• finding physical servername
• order by asc for two (2) columns
• Finding filesizes

This entry was posted on Friday, April 10th, 2009 at 7:56 pm and is filed under sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.