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.
Technology Tips and News
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.
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.
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