SQL Server – could not open a connection to SQL Server (Error: 40)

August 25, 2012

I had the whole stage set for my SQL Server 2008 R2 installed and ready to use. But this did not get a relief, there was something that kept be pulling my hair for almost 2 full week ends after doing all the installation L

I was in a struggle in getting my SQL server on track to connect to the database engine!!

It was all saying – “error: 40 – could not open a connection to SQL Server”.

 

All I had to do was to look for the SQL server services, Right click on your MyComputer(Computer) -> Manage -> Computer manager. And here we go to the Services and Applications and then to SQL Server Configuration Manager to find the below settings under SQL Server Services,

 

So this is the root cause making us not to get logged into the Database Engine, and a simple solution have this set is to right click and look for the properties

 

Then all you have to do is to start the services and give your database connection a one more try, and in case you find any problem with the login user simply give the User Name as ‘sa’ and a blank password with the SQL Server Authentication. This must resolve things and get you logged in. Finally my wait gets over after almost 2 full weeks 🙂

Thanks for reading, share this and it must help some one out.

 

Advertisements

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

%d bloggers like this: