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.

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: