How can I configure SQL Server Aliases on a SQL Server Client Machine
1
vote
1
answer
852
views
Even after installing SSMS on a SQL Server Client machine, I found that SQL Server Configuration Manager would not run. Manually loading the mof file via [Microsoft's Instructions](https://support.microsoft.com/en-us/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-se) was sufficient to repair the "Cannot connect to WMI provider" error, but this only caused the 32 bit configuration manager to show up. I also want to configure 64-bit aliases.
Historically, I've avoided this problem by using the SQL Server Install Media to install SSMS, but I was hoping this was no longer necessary now that SSMS was released separately. Absent a documented recommendation from Microsoft, I'd rather avoid the commonly suggested hack of copying
sqlmgmprovider.dll
from other machines.
Asked by Brian
(185 rep)
Apr 18, 2018, 04:42 PM
Last activity: Apr 20, 2018, 05:52 PM
Last activity: Apr 20, 2018, 05:52 PM