I tried to connect SQLTEST instance of SQL Server and got below error
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
5. In Properties Dialog box go to Log On tab
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
7. Now try to connect SQL Server for that particular instance. You should successfully able to connect.
