Monday, 7 June 2010

Cannot Connect to SQL Server

I recently installed a new SQL Server 2008 instance on a brand new Windows 2008 R2. When I tried to connect to said instance using Management studio on my desktop i received the following error message:

"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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)"

An initial google search on the error returned a whole bunch of information on SQL Server 2005 and enabling remote connections. Well you don't need to 'enable remote connections' as such in SQL Server 2008 but I did check that the TCP/IP protocol had been enabled in configuration manager.

I then found a useful SQL Server 2008 post which can be found here . This suggested that the problem was related to the Firewall blocking remote connection. I got followed the advice and got the firewall reconfigured and I was able to connect.

No comments:

Post a Comment

Featured post

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database? If you work in a hybrid environment with some databases stored on your on ...