Help ! -- Cannot open Enterprise Manager --
Posted on 2004-09-18
My Enterprise Manager works well before, and today after un-normally shut down the computer, and re-start the computer, I could not run the Enterprise Manager with the Microsoft Management Console fatal error message: "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 doesn't exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have suffieient access right to the file.", and you can only click button.
I still can run 'Query Analyzer', 'Profiler' and others. I only cannot run 'Enterprise Manager'. I try to un-install SQL Server 2000, then re-install it. The problem still is the same. The computer's OS is Windows XP Professional Edition. MSDE was installed first. Then SQL Server 2000 Enterprise was installed so that I can use Enterprise Manager to manage the database. The database is local, not in the network. This is very urgent, and I don't want to format the hard drive and re-install everything. Please help me.
The file C:\Program files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC does exist. and other file 'sql iis admin.msc' in the same folder can be opened without any problem.