Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Cannot Execute SQL Configuration Manager

Posted on 2016-07-22
15
Medium Priority
?
117 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
  • 2
15 Comments
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 1000 total points
ID: 41725967
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
ID: 41727818
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 1000 total points
ID: 41729286
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 52

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 total points
ID: 41750330
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
ID: 41750578
Thanks for the ideas.  Will try them today.
0
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 1000 total points
ID: 41769695
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
ID: 41770407
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
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 1000 total points
ID: 41772497
Any progress yet, Jean ?

Mike
0
 

Assisted Solution

by:Jean Holland
Jean Holland earned 0 total points
ID: 41772555
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 1000 total points
ID: 41772630
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
ID: 41772964
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 1000 total points
ID: 41773108
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
ID: 41796153
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 52

Expert Comment

by:Vitor Montalvão
ID: 41796173
Thank you for the feedback.
Cheers.
0
 

Author Closing Comment

by:Jean Holland
ID: 41803557
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

670 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