Today, I forced SQL2000 to be disabled, causing the MSC to be unavailable. The database server can be started, but the Enterprise Manager cannot be opened. A prompt message is displayed.
:
It's really strange that we have never encountered such a situation.
I thought that the installation file of SQL Server was damaged, so I considered re-installing SQL Server 2000. As a result, the problem persists after installation.
I checked C:/program files/Microsoft SQL Server/80/tools/binn/SQL Server Enterprise Manager. MSC. The results are good. Why can't I find them?
There are a lot of solutions on the Internet. One by one, the result is that the following method is easy to use and recorded to prevent this problem from occurring one day.
"Start"-> "run"-> type the MMC command
The following window is displayed:
"File"-> "Add/delete Management Unit (m)" or press Ctrl + m to bring up the following window:
Click the "add" button below and select "Microsoft SQL Enterprise Manager ":
Click the Add button to close the window. The Enterprise Manager is displayed in the Add/delete Management Unit list, at the same time, click "OK" and Microsoft SQL servers will appear on "console 1.
Most
Then, select "file"-> "Save as" to save the added console to C:/program files/Microsoft SQL
Server/80/tools/binn/SQL Server Enterprise Manager. msc directory, directly overwrite the existing SQL
Server Enterprise Manager. msc file.
Now you can start the Enterprise Manager.
I found a complete post and shared it with you.
Turn: http://blog.csdn.net/taipion/archive/2009/08/01/4400842.aspx