Total Pageviews

Tuesday, October 25, 2011

SQL server Configuration Manager not able to Open.


Issue:On one of the servers we are not able to open the SQL server configuration Manager and getting error as mentioned below


To resolve
1.I have verified that I have permission and verified the WMI service also running fine.
2. Something I checked  it -
Found that it happens when 32bit MSSSQL application is installed on 64bit .
Hence to resolve we need to store the data back to repository of this file mofcomp
where information about this file is as mentioned below-

MOF files are appropriate for static management data or dynamic management data. Static data includes details such as the computer user’s phone number, office number, and name.
Dynamic data includes details such as Microsoft SQL Server(tm) database sizes and applications installed with Windows Installer
3.Note this file has to be present in the binary path where the SQL server installation present I,e
SQL binary files for eg->in our case is as mentioned below


If not present that file you need to copy to here. Then follow the below steps
Go to CMD
Execute the below query


See the out put the result says :Done with Storing data I the repository.
5.Open the SCM now the trick works as mentioned below

(I didn’t copy all the things above).


No comments: