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.


%d bloggers like this: