Contents
Why is MY SQL Server Configuration Manager not working?
I also have this problem with the following series of events: I download the Windows Azure SDK from here: http://www.windowsazure.com/en-us/develop/downloads/, which installs SQL 2012 express; immediate I try to run SQL Server Configuration Manager, and the installation of SQL 2012 has broken it such that I get the “remote procedure call failed”.
How to troubleshoot SQL Server Configuration Manager RPC failed?
If using Window Server 2008 and above, run command from command prompt to verify WMI repository: winmgmt / verifyrepository If you get any error, please contact your OS team for WMI rebuild. c:\\program files (x86)\\Microsoft SQL server\\140\\shared>mofcomp.exe sqlmgmproviderxpsp2up.mof
What to do if SQL Server 2008 R2 fails?
Solution: Install SQL Server 2008 R2 SP2, restart, open SQL Server Configuration Manager and ALL is good. No need to re-install or update your SQL Server 2008 R2 instance. I got the same error and it get resolved by simply starting the MSSQLSERVER standard service.
Cannot connect to WMI provider. You do not have permission or the server is unreachable, Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. SQL Server Configuration Manager use Window Management Instrumentation (WMI) to view and change some server settings.
Where are the permissions assigned in SQL Server?
Beginning with SQL Server 2012 (11.x) permissions are assigned to the per-service SID for each of its services. This system helps provide service isolation and defense in depth.
How to configure permissions for database engine?
Right-click the file system folder, and then click Properties. On the Security tab, click Edit, and then Add. In the Select Users, Computer, Service Account, or Groups dialog box, click Locations, at the top of the location list, select your computer name, and then click OK.
How to configure Windows service accounts and permissions?
In the Select Users, Computer, Service Account, or Groups dialog box, click Locations, at the top of the location list, select your computer name, and then click OK. In the Enter the object names to select box, type the name of the per-service SID name listed in the Books Online topic Configure Windows Service Accounts and Permissions.