Help ! -- Cannot open Enterprise Manager --
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.
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.
ASKER
As I said in my qustion, the 'SQL Server Enterprise Manager.MSC' file does exist in Binn directory.
I un-install SQL Server 2000, then reinstall it. The problem still exists. Note: When I uninstall SQL Server 2000, it says uninstall successfully. But in the detail message, it says some folders failed to delete, and all sub-folder under Microsoft SQL Server folder still exist there, and also the SQL Server Group still exist in 'All Programs' menu. It seems un-install almost do nothing. I even tried to uninsall SQL server 2000 first, then uninstall MSDE. Then reinstall MSDE, then reinstall SQL Server 2000. I still cannot open Enterprise Manager. I don't know why? Problem happened after un-normally shut down the OS. But un-normally shutting down OS happened many times before, and no problem at all before. Do you thing I have to format the hard drive, then reinstall everything?
Thanks.
I un-install SQL Server 2000, then reinstall it. The problem still exists. Note: When I uninstall SQL Server 2000, it says uninstall successfully. But in the detail message, it says some folders failed to delete, and all sub-folder under Microsoft SQL Server folder still exist there, and also the SQL Server Group still exist in 'All Programs' menu. It seems un-install almost do nothing. I even tried to uninsall SQL server 2000 first, then uninstall MSDE. Then reinstall MSDE, then reinstall SQL Server 2000. I still cannot open Enterprise Manager. I don't know why? Problem happened after un-normally shut down the OS. But un-normally shutting down OS happened many times before, and no problem at all before. Do you thing I have to format the hard drive, then reinstall everything?
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, experts, thank you so much. Even though your answers don't directly solve my problem, you do give me a lot of information. I finanlly fix that problem by changing that file 'SQL Server Enterprise Manager.MSC' name to any other name, then you can open it. It seems it is a security privilege issue. Anyway, I am happy I can open it now. After you change that file's name, don't forget change its shrot-cut icon with new file name.
Thanks again.
Thanks again.
I had this exact same problem. I installed SQL Server 2000 Developer Edition from the MSDN subscription download site which you get as an .iso image file. I burned that to CD and then installed from the CD. I ran the default install. SQL Server Service Manager showed up and I got the new start menu program group called "Microsoft SQL Server", however the SQL Enterprise Manager was not there in the group. I double checked to make sure I had the management tools selected for the install by running the installer again and checking the option to install/remove components: Management Tools was showing up as being already installed. I did a search for SQL Server Enterprise Manager.MSC and found it under C:Program Files\Microsoft SQL Server\80\Tools\Binn. Running that works. Also doing the steps mentioned above for Add-Remove Snap-in worked. I don't understand where I was supposed to find and run it to begin with, I expected it to have a shortcut included in the program group under the start menu/All Programs/Microsoft SQL Server after the install.
other than this reinstall should work, just make sure you back up your Data and Log files.