I seem to be having trouble connecting to SQL Server 2008 on my new desktop machine. OS is Windows 7. I am trying to set up a development environment so I can learn at home. I receive the following 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) (Microsoft SQL Server, Error: 2)
I have searched regarding this problem, and so far nothing I have read about online has been able to help me. To be explicit, what I am doing is:
1. Opening SQL Server Management Studio
2. Click on the Server name drop down and browse for more
3. Click on the Network Servers tab, expand database engine, and select the SQL Server Instance
4. Attempted to connect using Windows Authentication.
So far I have:
1. Turned off my Firewall and Antivirus, to make sure that wasn't the issue.
2. Successfully pinged the server.
3. Verified the SQL Server is running using the Server Configuration Manager.
Any assistance would be greatly appreciated.
View Complete Post