Installing SQL Server Dev Config Manager (Snap in)

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Server Sql
Click For Summary
SQL Server 2017 Configuration Manager is not included as a built-in tool but is instead a snap-in. Users may encounter a "Cannot connect to WMI provider" error when attempting to install it via Control Panel, indicating permission issues or server unreachability. A workaround involves using the command line to compile a .mof file, specifically targeting the correct version number, which for SQL Server 2017 is 140. However, confusion arises as there are no version numbers assigned for releases after 2012. Users with both 32-bit and 64-bit instances may face additional complications, although in this case, both instances are confirmed to be 64-bit. Despite following the suggested steps, the issue persisted, leading to the decision to uninstall and reinstall SQL Server. Additionally, there was a query regarding filtering within SQL Profiler, which was resolved by locating the necessary files.
WWGD
Science Advisor
Homework Helper
Messages
7,771
Reaction score
12,990
Hi All,
It seems SQL Server's Dev 2017 config manager does not come " built in" within , and it is now a snap in. When I try to install it through Control Panel, I get the error message: Cannot connect to WMI provider. You do not have permission or the server is unreachable.
upload_2019-3-14_13-44-59.png


https://support.microsoft.com/en-us...en-sql-server-configuration-manager-in-sql-se

Suggests as a work around to go to the command line and enter:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof" (**)

Where number is in the list given. BUT no numbers are assigned for versions after 2012. In my Microsoft SQL Server folder I have subfolders numbered 80,90, 110, 120, 140.

upload_2019-3-14_13-55-16.png


It would seem I should use 140 as a number in (**) above.
Is this correct?

In the page linked above, it says that the problem comes from having a 32-bit instance and another 64-bit instance, but both my instances are 64-bit.
Thanks.

EDIT: While we're at it, if someone knows how to filter within Profiler, I would appreciate any advice on how to do it.
 

Attachments

  • upload_2019-3-14_13-44-59.png
    upload_2019-3-14_13-44-59.png
    44.8 KB · Views: 664
  • upload_2019-3-14_13-55-16.png
    upload_2019-3-14_13-55-16.png
    56.1 KB · Views: 577
Last edited:
Computer science news on Phys.org
Never mind, thanks, I found a folder containing the needed file --it was 140-- and made the change, needed to compile a n .mof. Still, it did not work out, so I will uninstall and reinstall.
 
Thread 'ChatGPT Examples, Good and Bad'
I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...

Similar threads