Sql server management studio not connecting.

Hello,

I've upgraded to windows 10 and when I'm trying to connect the management studio I couldn't able to connect it. My sql server configuration manager is missing. Could you please help me how to connect to the management studio.

Thank you.

July 29th, 2015 2:13pm

Are you sure that the SQL Server is running? Can you check the local services first?

Also, make sure to re-start the system twice after upgrade.

Free Windows Admin Tool Kit Click here and download it now
July 29th, 2015 2:16pm

Hi rakesh190,

Could you please post the full error message that you get when connecting to SQL Server via SQL Server Management Studio (SSMS)?  And you can follow the general steps in below blog to troubleshoot connecting to SQL Server.

How to Troubleshoot Connecting to the SQL Server Database Engine

In addition, regarding to the issue that SQL Server Configuration Manager(SSCM) is missing after Windows upgrade, it could be caused by that the upgrade is unregistering the Configuration Manager MMC snap-in. However, the files required to operate the Configuration Manager are still present.

To fix this issue, find another SQL Server (same version with your SQL on the upgraded system) system and copy the shortcut SQL Server Configuration Manager from it to the folder on your upgraded system. For more details, please review this similar blog. If you dont have another functioning SQL Server system from which to copy the shortcut, then you should be able to make your own shortcut as described in this blog.

However, if the issue still persists, please repair your SQL Server.

Thanks,
Lydia

July 30th, 2015 1:44am

Can you post the error message you're getting while trying to connect using Management studio?
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2015 1:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics