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

sql sql-server windows mmc snap-in
Hot Cool Stud picture Hot Cool Stud · Sep 10, 2014 · Viewed 16.8k times · Source

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

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

Aleksandar Pavić picture Aleksandar Pavić · Aug 31, 2015

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

Related questions

Can't connect to SQL 2012 remotely by IP and named instance

First off, I already know that Windows Firewall is blocking my connection -- I just don't know what to do about it. When I turn WF all the way off, my remote connection works. I already have a Rule to …

Read More
How do I run a script using a BAT file?

I would like to have a BAT file open a sql server script. Currently I have this code in the sql file: declare @path varchar(255), @mydb varchar(50) SELECT @mydb = 'timeclockplus' select @path = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More