Problem in opening Enterprise Manager??

Hi
I have used my MS SQl server successfully for all DataBAse related oprations. Of late I am unable to open Enter Prise Manager . If I try to open it (Programs - Mocrosoft SQL Server) I get a message saying "MMC cannot open the selected program".

If try to opne SQL Server through "Programs - Administrative Tools - Computer Management ..."
I can open the Database & can only view Tables under each databse, but not table contents.

Is the problem related to SQL Server or Windows?? I am totally new to this DB administration Please help.

shara

At command prompt try run this command:

c:\"SQL Server Enterprise Manager.MSC"

if it works check the shortcut from start menu if there is correct path..

default Path is "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\"

Sorry ... No difference.
I just want to know what is the reason for this problem??

shara

Problem is that MMC could not find the specified file. It's not a DB error. try this from command line...

C:\>mmc "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC"

works for me.

Or run only MMC and open the file through the menu Console\Open...

When I used
C:\>mmc "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC" at command line & got the message mmc couldn't find the file u mentioned

& When I tried to run through Console\Open... I could see the Console folder but nothing inside.

Can any one explain the reson for the above messages??

shara

Reinstall the sql server client. May be some files got deleted.

The msc file did exist and I definately has permissions to it. So I can only assume it some how got corrupt.

The solution to this is fairly simple... either get another copy of this file, or create one, as follows:

Select Start - Run.
At the Open prompt enter: mmc
Click OK
Select File - Add/Remove Snap-in...
Click Add...
Select Microsoft SQL Enterprise Manager
Click Add, then Close
Click Ok to return to the mmc.
Select File - Save As...
Delete or rename the original (offending) file out the way.
Save the new msc file as C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
Now your original shortcut should work.

Alternatively you can always access Enterprise Manager from within the Computer Management mmc.

reinstall sql server client and install service pack.

Instead of using
C:\>mmc "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC"

...use
mmc "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC"
instead

You don't need the drive letter because you open the MMC without it if you use that on its own.

C:\> means dos prompt I believe.

I think that would be a safe bet ... :)

Bill