Sql-server – SQL Server Configuration Manager 64-bit Nodes Missing on 64-bit WIndows 10

sql server

This problem appears to have been written about quite a lot, and answers posted here too, but I have tried all the suggestions and some of my own to no avail, so please bear with me.

I have Windows 10 V1607, 64-bit. I've used SSMS for a long time, and keep up-to-date with the latest versions, especially now that it is shipped independently, and free, from SQL Server.

When I switched from Windows 7 to Windows 10 on this machine, I installed SSMS V16, and noticed then that there were no 64-bit nodes in SSCM. I didn't think too much of it at the time, and set about creating my 32-bit aliases.

Recently, I changed an old application to 64-bit, compiled and ran it in Visual Studio (2017), and tried to connect to a database. It failed.

I thought it might be that I have not set up any 64-bit aliases, so returned to SSCM to add them. But no 64-bit nodes.

I have seen various suggestions about copying files from a working copy, so I tried that. No difference.

I spotted the latest SSMS V17.1 had just been released, so installed that. It too is missing the 64-bit nodes.

I have tried repairing, reinstalling, turning it off and on again, but still they fail to appear.

Please, does anyone have an insight into why this happens, but more to the point what to do to fix it?

I have SQL Server installed on another machine. I want my application to connect to a database on that machine, remotely. To make it easier to manage the remote database I have SSMS installed locally; in that way, I don't have to use RDP to connect to the server. When I run my application and it connects to the remote database, I want to use an alias, such as 'MyRemoteDatabase', instead of using the IP address and port number directly. In the past, I have run SSCM to create the alias, but my 64-bit applications don't see my 32-bit aliases, which is why I want the 64-bit nodes.

Best Answer

Right click the Config Mgr shortcut in the Start Menu, open the file location, change the shortcut Target to:

C:\Windows\SysWOW64\mmc.exe /32 C:\WINDOWS\SysWOW64\SQLServerManager13.msc

The *.*14.msc was my issue.