Microsoft Sql Server, Error : 10061

I tried to connect SQLTEST instance of SQL Server and got below error

clip_image001

This is very common error and can be caused due to many reasons. The way I solved it

1. Go to Start

2. Type Run

3. Type Services.msc

4. Then locate for SQL Server instance you are trying to connect. In my case this is SQL TEST. Right click and select Properties

clip_image003

5. In Properties Dialog box go to Log On tab

clip_image004

Now if you have recently changed the login pass word of the system. Make sure for that particular account you have changed password here also. Better option would be make Log on as Local System account

6. Navigate to General tab and change the Startup type to Automatic and Start the service

clip_image005

7. Now try to connect SQL Server for that particular instance. You should successfully able to connect.

Published by

Dhananjay Kumar

Dhananjay Kumar is Developer Evangelist for Infragistics. He is a 8 times Microsoft MVP and well respected Developer Advocate in India.He is the author of 900+ Blog Posts, and can often be found speaking around India at conferences and hosting free workshops for programmers across the country. So far, he has hosted 60 free workshops on various topics like JavaScript, Angular, WCF, ASP.NET MVC, C#, Azure etc. Follow him on twitter @debug_mode for all the updates about his blog posts and workshops. You can send him email at debugmode [at] outlook [dot] com

3 thoughts on “Microsoft Sql Server, Error : 10061”

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 )

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 )

w

Connecting to %s