MMC Cannot open

who knows how to fix this
MMC cannot open the file C:\Program Files\Microsoft SQ
Server\80\Tools\BINN\Sql Server Enterprise Manager.MSC
This may be because the file doesnt exist, is not an MMC console, o
was created by a later version of MMC. This may also be becaus
you do not have sufficient access rights to the file
I have rebooted the server, and restarted my machine, uninstalled and reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise Manager. Can anyone help?
Thanks in advanc
JanJane, once again, have you considered using SQL Server 2000 Enterprise
Manager? You seem to have both installed on your machine, and when you try
to launch 7.0 it is looking in \80\ and causing a conflict. I suggest
uninstalling SQL 7.0 client, reinstalling 2000 client, installing 2000 SP3a,
and using 2000 client tools.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:C0397850-DCCD-4AEE-9ADF-AAD21DC84737@.microsoft.com...
> who knows how to fix this:
> 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 doesnt exist, is not an MMC console, or
> was created by a later version of MMC. This may also be because
> you do not have sufficient access rights to the file.
> I have rebooted the server, and restarted my machine, uninstalled and
reinstalled SQL Server 7.0 Client. I still can't start SQL Server Enterprise
Manager. Can anyone help?
> Thanks in advance
> Jane
>|||Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000. The problem is very strange. I suppose I am locked by the server. Don't know what to do now
As I said, I am new to SQL Server, I am trying to explore it. But there isn't a senior member in our team, so your help turns to be very important for me. I am looking forward to any ideas
Cheer
Jane|||Jane,
Refer the steps 3 to 5 given in the 'workaround' section of this article:
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000'
http://support.microsoft.com/default.aspx?id=272453
PS: I know that the title of the article doesnt concern you, but those steps
might help.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000.
The problem is very strange. I suppose I am locked by the server. Don't know
what to do now.
> As I said, I am new to SQL Server, I am trying to explore it. But there
isn't a senior member in our team, so your help turns to be very important
for me. I am looking forward to any ideas.
> Cheers
> Jane|||Thanks for your help, but it doesn't work. Any ideas
Jan
-- Dinesh T.K wrote: --
Jane
Refer the steps 3 to 5 given in the 'workaround' section of this article
'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000
http://support.microsoft.com/default.aspx?id=27245
PS: I know that the title of the article doesnt concern you, but those step
might help
-
Dines
SQL Server MV
-
-
SQL Server FAQ a
http://www.tkdinesh.co
"Jane" <anonymous@.discussions.microsoft.com> wrote in messag
news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com..
> Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server 2000
The problem is very strange. I suppose I am locked by the server. Don't kno
what to do now
> As I said, I am new to SQL Server, I am trying to explore it. But ther
isn't a senior member in our team, so your help turns to be very importan
for me. I am looking forward to any ideas
> Cheer
> Jan|||Jane,
May be EM is missing some DLLs .The relevant ones are
sqlns.dll,sqlmmc.dll,sqldmo.dll,dtsui.dll and sqllex.dll.Usually you can
find them in c:\mssql7\binn\.
Try re-registering them using regsvr32.exe.After each one, try opening up
EM.
If this too doesnt help, see if a reinstall of the relevant MDAC helps.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>|||Jane,
What is the version of you mmc.exe? What is the OS and SP level of your
workstation?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Jane" <anonymous@.discussions.microsoft.com> wrote in message
news:032389DE-4113-42A4-9DA0-B78F4864A746@.microsoft.com...
> Thanks for your help, but it doesn't work. Any ideas?
> Jane
> -- Dinesh T.K wrote: --
> Jane,
> Refer the steps 3 to 5 given in the 'workaround' section of this
article:
> 'PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server
2000'
> http://support.microsoft.com/default.aspx?id=272453
> PS: I know that the title of the article doesnt concern you, but
those steps
> might help.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane" <anonymous@.discussions.microsoft.com> wrote in message
> news:42525A24-E330-44F9-A037-F17141FB0156@.microsoft.com...
> > Hi, Aaron, Thanks for your reply. Actually I don't have SQL Server
2000.
> The problem is very strange. I suppose I am locked by the server.
Don't know
> what to do now.
> > As I said, I am new to SQL Server, I am trying to explore it. But
there
> isn't a senior member in our team, so your help turns to be very
important
> for me. I am looking forward to any ideas.
> > Cheers
> > Jane
>
>sql