Solved

Cannot Execute SQL Configuration Manager

Posted on 2016-07-22
15
47 Views
Last Modified: 2016-09-18
I have several SQL instances running on my development computer. One for SQL2008R@ (64), two for SQL2012 (64), and one for SQL2014 (64).  I am running Windows 10.  These SQL versions are all for 64 bit OS.  I recently installed the second 2012 version for a project and now I cannot execute SQL Configuration Manager on any version.  I am getting this message: Cannot connect to WMI provider. You do not have peremission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010].  I also got a slightly different message another time with error code [0x80041013].  I do not have any 32 bit SQL servers on this machine and have never installed a 32 bit server on this machine. I have tried all the published methods to try to fix this -- specifically I have already executed these commands:
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof"
Any ideas before I attempt to uninstall and reinstall my development environment?
SQL itself is working fine.  Just the configuration manager will not fire. Thx for your replies. Jean
0
Comment
Question by:Jean Holland
  • 7
  • 6
  • 2
15 Comments
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 250 total points
Comment Utility
SQL Configuration Manager is actually a publication using Microsoft Management Console, so the first thing to do is to see if mmc can run at all. Try running mmc from the Start | Run prompt and see what you get. Hopefully you'll get at least the three  SQL Servers that you had before adding the second 2012.
Either way, check the permissions set for your second instance of 2012 and see if maybe the second instance has got some group policy that forbids you from things ...

Mike
0
 

Assisted Solution

by:Jean Holland
Jean Holland earned 0 total points
Comment Utility
Thank you for the ideas. Yes mmc runs, but you need to open another file like SQLServerManager12.msc and that's where it throws the error.  Thanks again.
Jean
0
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 250 total points
Comment Utility
Jean,

Just a thought: mmc may be trying to load the new msc twice. Try renaming one of them with a different extension and see what happens ... you should be able to see both servers with just one msc installed.

Mike
0
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
Comment Utility
You should have only one SSCM and one SSMS per computer. If you have more than one you should install them by version order (from the oldest to the newest one). Looks like after you install MSSQL 2014 you installed MSSQL 2012 and this installation might override the last one from MSSQL 2014.

I suggest you to run a repair for MSSQL 2014 tools to see if that helps.
0
 

Assisted Solution

by:Jean Holland
Jean Holland earned 0 total points
Comment Utility
Thanks for the ideas.  Will try them today.
0
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 250 total points
Comment Utility
I would consider Vitor's explanation a very plausible one, and would have expected a reply, at least reporting experimentation to that effect. It would be fairly easy to achieve - re-install 2014 but only select the SSMS part - disable all other installation options.

Mike
0
 

Assisted Solution

by:Jean Holland
Jean Holland earned 0 total points
Comment Utility
Thank you I will try that.  I logged a tech support call with Microsoft to try to resolve this.  I have been working with an engineer for over two weeks now with no results.  Of course they only call a couple of times per week and each session has been 1-3 hours.  When I figure out how to resolve it I will post here.
The tech support call cost $499.  Good grief.
Jean
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 250 total points
Comment Utility
Any progress yet, Jean ?

Mike
0
 

Assisted Solution

by:Jean Holland
Jean Holland earned 0 total points
Comment Utility
No.  Just finished up another week with Microsoft engineer.  We may be headed for a complete uninstall and reinstall of any whisper of SQL.  The engineer says this is not a SQL issue but rather the registry that is unable to repair itself.  He said that we may end up wiping the disk and starting all over.  I'm hoping beyond hope that I don't have to go that route. This is a relatively new computer (just a few months old).
This is completely unacceptable.  I came from a UNIX environment and we never had these kinds of issues. Why have they gone the route of the automobile so that nothing can be fixed, only replaced? It stinks.
0
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 250 total points
Comment Utility
Unfortunately the Registry is a somewhat primitive version of a database, and if yours is roached then what the tech says could be very right. However, before just wiping the whole disk (make two backups of everything first !) you might just try doing an uninstall of everything SSMS-related and then just installing 2014. If that works, run the other databases under it.

Hope this helps

Mike
0
 

Assisted Solution

by:Jean Holland
Jean Holland earned 0 total points
Comment Utility
Definitely will take your advice and will let you know how it goes.  It's a development machine with very little on it except my projects of course which are easily backed up.  Everything like that is on an external disk.
0
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 250 total points
Comment Utility
In that case you're very lucky! Just imagine if it was the company's accounting database!
Below is what I was going to suggest, but, while doing it, I ran into an upgrade message for SSMS, which led here. You might try installing this and seeing if it will run and accept all your versions.
--    --------------------------------------------------------------------------------
I was going to suggest that you consider installing the 2012 version after all the dust has settled and get all the 2008R2 databases up to 2014 level - for info on this see here.

Note that you won't be able to just copy the level 10 database files from your current disc if the SQL Server 2008R2 processes are running and you can't open your 2008R2 SSMS. You'll have to mount your disc under some other OS - someone else's Windows machine or else by using a live copy of Linux that you can get on a CD or DVD attached to a Linux magazine like Linux Format. Then you'll be able to copy the files to somewhere where you can attach to them in some other SSMS and upgrade them to a compatibility level good enough for your 2014 9or 2016, by then!) system.

BTW, Developer 2016 is free to download.

Hope this helps

Mike
0
 

Accepted Solution

by:
Jean Holland earned 0 total points
Comment Utility
After almost a month working with first level tech at Microsoft with no results, the issue was escalated to a SQL engineer at Microsoft.  There were elements of SQL 2014 and SQL 2012 that had not been properly removed with "Uninstall" from my original installation.  We ran the standard uninstall of all elements of SQL 2014 and SQL 2012 and did a fresh installation of 2012.  After that (and rebooting after each step), by navigating to the specific SQL 2012 instance of SQL Configuration Manager, it worked. However, if you added that program to the Start Menu, when you click on the icon in the start menu, it tries to execute SQL Configuration Manager for 2008 R2 and fails.  We called the problem resolved and I put a shortcut on my desktop to be able to run the one that worked.  Microsoft took a note of the Path problem in the Start Menu, reclassified the problem as an internal bug and gave me credit for the dollars I spent for the tech support call.  As far as I am concerned this is now resolved.
1
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Thank you for the feedback.
Cheers.
0
 

Author Closing Comment

by:Jean Holland
Comment Utility
This was a problem with the OS and I had to work with Microsoft to get it working.  All of the comments from members were very helpful.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now