Problem in opening Enterprise Manager??

[shanuragu]

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

[YuckFou]

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\"

[shanuragu]

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

shara

[YuckFou]

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.

[YuckFou]

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

[shanuragu]

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

[skhanal]

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

[deepaks]

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.

[MAK]

reinstall sql server client and install service pack.

[jharrod]

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.

[rmiao]

C:\> means dos prompt I believe.

[Island1]

I think that would be a safe bet ...

Bill