MMC could not created the snap-in SQL Server configuration manager

Question

When i tried to connect to sql server configuration manager in sql server 2008. It shows error MMC could not create the snap-in.

It was working perfectly till last night. What can be the reason, how can i solve it. But in background sql server is working perfect.

Answer 1

*Note: Before doing this, make sure that your user has Administrative righs to run MMC, unless it's not Administrator, below procedure won't work.

1. Win button + R, then type mmc and press enter.
2. Choose File->Add/Remove Snap-in.
3. Click Add to Console Root
4. and find the "SQL Server Configuration Manager"

You will be able to use it from there or replace existing console by saving it to bin folder of you SQL server's installation.

Note: This is the only option that really worked for me...