Yesterday, I encountered a very strange file. SQL Server was well-used. I don't know how to suddenly see this error. I thought it was because SQL Server had missing any files and I re-installed it again, as a result, all the registries and temporary files are cleared and re-installed. The error persists. Very depressing.
The error is as follows:
---------------------------
Microsoft Management Console
---------------------------
MMC cannot open the file c: \ Program Files \ Microsoft SQL Server \ 80 \ tools \ binn \ SQL Server Enterprise Manager. MSC.
This may be because the file does not exist, it is not an MMC console, or it was created using a later version of MMC. It may also be because you do not have sufficient permissions to access this file.
---------------------------
OK
---------------------------
Later, search onlineArticleFinally, I found a solution and recorded it. I hope it will help my friends who encounter such problems in the future! Solution:
Start-run-input: MMC-open "file"-Add/delete snap-in-add an SQL Server snap-in = OK
Go back to the console -- option -- select "user mode full access" in Console mode -- Cancel all the following options. Finally, choose console -- save as -- Storage: C: \ Program Files \ Microsoft SQL Server \ 80 \ tools \ binn \ SQL Server Enterprise Manager. MSC (the binn folder under the installation directory of sqlserver ).
Otherwise, register the DLL again.
Run: regsvr32 c: \ windows \ system32 \ msxml3.dll"
This article from the csdn blog, reproduced please indicate the source: http://blog.csdn.net/elangno1/archive/2009/05/17/4194591.aspx