Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Can't access SQL server Configuration Manager

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

Can't access SQL server Configuration Manager

Postby blin » Fri Feb 09, 2018 4:13 pm

After login my domain admin account to a VM, I can access SQL Server Management Studio with any problem. However, the same account can't run SQL Server Configuration Manager with this error: Cannot connect to WMI provide with invalid namespace 8004100e. Why?
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: Can't access SQL server Configuration Manager

Postby blin » Fri Feb 09, 2018 4:14 pm

this issue may occur because the WMI provider is removed or not started. To workaround this issue, open a command prompt, type the following command, and then press ENTER:



mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"

The value of number depends on the version of SQL Server

Microsoft SQL Server 2016 130

Microsoft SQL Server 2014 120

Microsoft SQL Server 2012 110

Microsoft SQL Server 2008 R2 100

After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: Can't access SQL server Configuration Manager

Postby blin » Fri Feb 09, 2018 4:14 pm

That fixes the problem. By the way it is SQL server 2017 and the number is 140. Thank you very much.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 4 guests