1

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 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.

2

Try using cliconfg.exe instead. This is shipped with Windows.

c:\windows\system32\cliconfg.exe - 64Bit aliases
c:\windows\syswow64\cliconfg.exe - 32Bit aliases

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.