Reader Level:
ARTICLE

Microsoft Sql Server Error : 10061

Posted by dj Articles | SQL February 21, 2011
Here you will see how to solve the Microsoft Sql Server error: 10061.
  • 0
  • 0
  • 17118


I tried to connect to a SQLTEST instance of SQL Server and got the following error:

SqlError1.gif

This is a very common error and there are many possible causes. The way I solved it is:

  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

    SqlError2.gif
     
  5. In Properties Dialog box go to Log On tab

    SqlError3.gif

    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

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

COMMENT USING

Trending up