IT Infrastructure blog

June 10, 2012

MS SQL Connectivity Error – A network-related or instance-specific error

I have installed SQL Managemant studio in my windows XP machine. I was trying to connect one of my SQL server. OOPS …the below error pop up







Below three steps i found to resolve this issue.

1) Check the SQL Server Browser service is started in SQL server ( If not start this service. you have to restart the SQL server Service as well)



2) Check TCP/IP is enabled in SQL Server Configuration Manager ( Start –> Programs –> SQL Server 2008 –>Configuration Tools. If it’s disabled make it enable.






3) Give the Servername\instance name while connecting from SQL Management Studio.











Hope you will be able to connect the SQL server now. I was able to connect when i follow above 3 steps.


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Blog at

%d bloggers like this: