Forum Discussion
SQL Server Config Manager Error "MMC could not create the snap-in"
Hi, I have seen this error elsewhere online. I have gone to mmc to enable the snap in and I still have had no fix. My computer is running Windows Server 2022, SQL Server Express 2022, and SSMS. I have reinstalled, repaired, and all of the other tricks. Help!
nicolasjpsanchez Unless you intend to have several snap-ins in MMC, have you attempted the following:
1) Opening the SQL Server 2022 configuration manager from the start menu?2) Use Computer management to access SQL Server Configuration management? (Right-click start menu -> Computer Management)
4 Replies
Re-register the Configuration Manager Snap-In Manually
-->Open Command Prompt as Administrator
-->Run the following command:(For SQL Server 2022, the version folder is 160. Adjust the path if yours is different.)
-->cmdmofcomp "C:\Program Files (x86)\Microsoft SQL Server\160\Shared\sqlmgmproviderxpsp2up.mof"-->Restart your machine
nicolasjpsanchez Unless you intend to have several snap-ins in MMC, have you attempted the following:
1) Opening the SQL Server 2022 configuration manager from the start menu?2) Use Computer management to access SQL Server Configuration management? (Right-click start menu -> Computer Management)
- I was able to do a fresh install, and reinstalled SQL server and am having no issues since then. Thanks for the response!
- Someone on the SQL server Discord recommended SQL Developer, but I have no idea why express would be causing this issue.
