Hi, when I go to the SQL Server Configuration Manager utility, the following error pops up :
Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
Access is denied. [0x80070005]
This is on a Windows 2003 SP1 server, and the database is an upgraded MSDE 2000 database. The database itself appears to be working OK. My application can connect to it, I can connect to it via sqlcmd, etc. (all locally). I'm logged on as an Administrator, so permissions shouldn't be a problem.
I ran FileMon to see which file it's complaining about, and it seems the culprit is sqlmgmprovider.dll. It's trying to access this .dll as Network Service. Just to check, I added Network Service to the .dll permissions and got a slightly different message :
Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
The application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. [0x800736b1]
I now also get two errors in the event log :
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error message: Access is denied.
And :
Generate Activation Context failed for c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmprovider.dll. Reference error message: Access is denied.
Both of those have a source of "SideBySide".
Any ideas how I can fix this problem Do I need to reinstall SQL Server Configuration Manager If so, how Thanks for any help you can offer.
SQL Express 2005 Configuration Manager - Cannot connect to WMI provider
Hot Topic
- sp_xml_preparedocument VS nodes()
- Domain Groups and Windows Authentication
- Slowly Changing Dimension question
- Error in Transacitonal Replication - SQL Server 2005
- Question: About RDA.SubmitSQL
- ResultSet in Avalon (WinFX-WPF-.net3.0)
- How can we limit the data regions in a specific report page?
- Get the variable from Execute Process Task to C#
- Scheduled Jobs
- Trigger data corruption
SQL Server
- foreach loop?
- Multilingual reports in Windows sharepoint services
- Way to manually create Aggregation?
- [DBNETLIB][ConnectionClient(SEDC.ClientHandshake().]SSL Server error
- Insert after rda pull
- Excel Worksheets Become Corrupt -- Bad Metadata?
- deployment options
- Report Builder and optional parameters
- Meta Data Services SQL 2000 "msdb database could not be opened"
- Connecting to Oracle on 64-bit (x64) machine
SQL Express 2005 Configuration Manager - Cannot connect to WMI provider
Ricardo Pinto
Win2k3 Server Standard, MS SQL 2005 Standard.
Tewks
Hello MS support team....where is your support
I have the same problem when I try connenct on remote server with no admin user.
What is need permission to connect on remote server with SQL Server Configuration Manager
thx
Nilton Pinheiro
www.mcdbabrasil.com.br (portuguese)
chriserin
I encountered the exact same behavior that Inetcor described in his original post, including the "SideBySide" errors in the event log. I suspect this happens when the default "Users" and "Everyone" permissions have been removed from the C: drive.
The "mofcomp" solution did NOT work for me. (Note that the "mofcomp" blog entry involved "Invalid class [0x80041010]", while my error was "Access is denied. [0x80070005]")
I was able to resolve the error by adding "Network Service" or "Users" permission to C:\Program Files\Microsoft SQL Server\90\Shared.
This was on a new installation of SQL Server 2005 Workgroup Edition, using Windows 2003 Server Enterprise on Microsoft Virtual Server. Note, after removing the additional permission, the problem did not recur until the VPS was rebooted.
KimmoK
Matthew Erwin
This fixed the issue for me
http://www.webservertalk.com/message1633161.html
It is a privilege problem with the performance logs
Solution:
Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory):
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
cabledog
Bas de Zwart
I had the same problem on Windows XP after installing VS 2005 and the solution is to go to a command prompt and then run mofcomp.C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"
When it says done you should be fine!
Although I can't take credit as I found the answer on this guys blog!
http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
Hope that helps!
Nathanael4499
Unfortunatelly, none of the solutions described in this post have solved my problem. The installation is on an XP SP2 laptop.
I have tried the "mofcomp" idea, I have given full rights to everything but still the problem persists. I have even uninstall SQL Server 2005 Express and install it back with no luck. I am that close to rebuild the laptop again from scratch. Any other idea before I do
Regards
KoryS
None of the solutions described in this post have worked for me either. I get the Access is denied. [0x80070005] error, when I run "mofcomp". I'm running SQL Server Development Edition 9.0.3159 on Vista Ultimate.
Any ideas on this one
Mimuka
Using a template with Virtuozzo, we had the same problem on w2k3 and SQL Server 2005 SE.
Now it works.
boran_blok_edan
Thanks All.
I too had the same problem and this has fixed it for me. It's obscure issues like this that these newsgroups are so valuable for!
My notes for people trying this;
1. I am running SQL 2005 Ent Edition RTM on Win 2003 Ent Edition SP1. I also have a SQL 2000 Ent Edition SP4 instance on the same server.
2. You can do this live on a production server - there is no server reboot required.
3. Make sure that the service called "Windows Management Instrumentation" is running and set to AutoStart - else you get an equally odd error.
4. You can run the command over and over again till it works! No server impact.
Cheers - R.