question

OkinoLeiba-9370 avatar image
0 Votes"
OkinoLeiba-9370 asked Yufeishao-0810 answered

SQL Server Manager File

There is absolutely no sqlservermanager15.msc file on my machine. I downloaded SQL Management Studio and SQL Server.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered OlafHelper-2800 edited

The SQL Server Manager MSC 64 bit should be located in folder C:\Windows\System32, 32 bit C:\Windows\SysWOW64; can you find the MSC there?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-0810 avatar image
0 Votes"
Yufeishao-0810 answered

Hi @OkinoLeiba-9370

In common case, the location is C:\Windows\SysWOW64\SQLServerManager15.msc, Of course, You will need the corresponding SQL Server Configuration Manager version to manage that particular version of SQL Server, please confirm it.
SQL Server Configuration Manager is a Microsoft Management Console (MMC) snap-in

You can check Computer Management if SQL Server Configuration Manager exists:
121121-861.png
If it doesn’t exist, you can try to fix SQL Server, or you can find SQLServerManager15.msc from another server which is running on same build version of from SQL Server Setup and paste it
If anything is normal, you can use the following steps to open SQL Server Configuration Manager:
1、 use MMC
121077-862.png
2、add snap-in:
121103-863.png
3、go to the menu File>>Save
121078-864.png



861.png (20.4 KiB)
862.png (13.1 KiB)
863.png (43.9 KiB)
864.png (226.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.