Enterprise Manager Won't Start

All of a sudden, whenever I try to start the SQL Server
Enterprise Manager, I get the following error:
MMC cannot open the file C:\Program File\...\SQL Server
Enterprise Manager.MSC.
This may be because the file does not 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've uninstalled and re-installed SQL Server at least
four times now. I still get the same error. What is
going on? The file exists. I can see it. Please, I
need some insight on this. Help!Does the account SQL Server is using have rights to the
directory? that would be my first guess
>--Original Message--
>All of a sudden, whenever I try to start the SQL Server
>Enterprise Manager, I get the following error:
>MMC cannot open the file C:\Program File\...\SQL Server
>Enterprise Manager.MSC.
>This may be because the file does not 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've uninstalled and re-installed SQL Server at least
>four times now. I still get the same error. What is
>going on? The file exists. I can see it. Please, I
>need some insight on this. Help!
>.
>|||Glenn,
Try reapplying the latest SQL Server 2000 service pack. If that doesn't
work try copying SQLEM.MSC from the SQL Server CD (remember to rename it
to Enterprise Manager.msc on your machine).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Glenn Cadoret wrote:
> All of a sudden, whenever I try to start the SQL Server
> Enterprise Manager, I get the following error:
> MMC cannot open the file C:\Program File\...\SQL Server
> Enterprise Manager.MSC.
> This may be because the file does not 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've uninstalled and re-installed SQL Server at least
> four times now. I still get the same error. What is
> going on? The file exists. I can see it. Please, I
> need some insight on this. Help!|||Still no success. I have:
1. Verified all of the file permissions.
2. Installed SP3a.
3. Copied the SQLEM.MSC file, renamed it.
I still get the same error.
Any other possibilities?
Glenn Cadoret
>--Original Message--
>Glenn,
>Try reapplying the latest SQL Server 2000 service pack.
If that doesn't
>work try copying SQLEM.MSC from the SQL Server CD
(remember to rename it
>to Enterprise Manager.msc on your machine).
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>Glenn Cadoret wrote:
>> All of a sudden, whenever I try to start the SQL
Server
>> Enterprise Manager, I get the following error:
>> MMC cannot open the file C:\Program File\...\SQL
Server
>> Enterprise Manager.MSC.
>> This may be because the file does not 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've uninstalled and re-installed SQL Server at least
>> four times now. I still get the same error. What is
>> going on? The file exists. I can see it. Please, I
>> need some insight on this. Help!
>.
>|||Glenn,
Well, it sounds like a permissions issue to me. What did you change? ;-)
Can you log on as local administrator and open EM?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Glenn Cadoret wrote:
> Still no success. I have:
> 1. Verified all of the file permissions.
> 2. Installed SP3a.
> 3. Copied the SQLEM.MSC file, renamed it.
> I still get the same error.
> Any other possibilities?
> Glenn Cadoret
>
>>--Original Message--
>>Glenn,
>>Try reapplying the latest SQL Server 2000 service pack.
> If that doesn't
>>work try copying SQLEM.MSC from the SQL Server CD
> (remember to rename it
>>to Enterprise Manager.msc on your machine).
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>Glenn Cadoret wrote:
>>All of a sudden, whenever I try to start the SQL
> Server
>>Enterprise Manager, I get the following error:
>>MMC cannot open the file C:\Program File\...\SQL
> Server
>>Enterprise Manager.MSC.
>>This may be because the file does not 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've uninstalled and re-installed SQL Server at least
>>four times now. I still get the same error. What is
>>going on? The file exists. I can see it. Please, I
>>need some insight on this. Help!
>>.sql

Enterprise Manager launch error

Not sure what has caused this to suddenly happen, but each time I attempt to launch Enterprise Manager I get the error:

"MMC cannot open the file C:\MSSQL\BINN\SQL Server Enterprises Manager.MSC
This may be because the file does not 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."

Now, I've already attempted to reinstall the client tools with no luck. The file does exist, and I have not changed my security settings -- at least that I'm aware of.

I use EM daily, so I'm perplexed as to why over night it stopped working. Is it possible a Windows Update could have caused this?

If you have any insight I'd appreciate it. Thanks.

PS. I'm using SQL 7.0 on a WinXP Pro laptop.

DavidI feel there could be some issue with h/w on the box and may refer to this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;315341 to fix it.

Ensure to obtain latest service pack for XP also, if nothing works reinstall from scratch.

Enterprise Manager for DTS doesn't work

When I try to open a package in Server/Data transformation
Services/Local packages MMC opens a new window and displays
a warning with the following text: "The specified module
could not be found" The caption of the box says: "DTS
Designer error"
Anybody a solution?
Server: W2K, sp 4
Client: XPPro, sp1
SQL server 2000
Thanks in advance,
Tjalling
Can you re-apply the latest SP please, seems like one of the files is not
registered/config'd correctly.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tjalling" <t.ament@.go-tan.nl> wrote in message
news:347c01c47ebe$644f9680$a401280a@.phx.gbl...
> When I try to open a package in Server/Data transformation
> Services/Local packages MMC opens a new window and displays
> a warning with the following text: "The specified module
> could not be found" The caption of the box says: "DTS
> Designer error"
> Anybody a solution?
> Server: W2K, sp 4
> Client: XPPro, sp1
> SQL server 2000
> Thanks in advance,
> Tjalling
|||

Quote:

Originally posted by Euan Garden[MS]
Can you re-apply the latest SP please, seems like one of the files is not
registered/config'd correctly.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tjalling" <t.ament@.go-tan.nl> wrote in message
news:347c01c47ebe$644f9680$a401280a@.phx.gbl...
> When I try to open a package in Server/Data transformation
> Services/Local packages MMC opens a new window and displays
> a warning with the following text: "The specified module
> could not be found" The caption of the box says: "DTS
> Designer error"
> Anybody a solution?
> Server: W2K, sp 4
> Client: XPPro, sp1
> SQL server 2000
> Thanks in advance,
> Tjalling

I had the same error message.
I looked at the the sqlsp installation log "C:\WINDOWS\sqlsp.log" and found what seemed to be a warning about Microsoft Data Access Components (MDAC) and installed MDAC 2.8.
Log entry:
C:\Download\mdac26Sp2\sql2ksp3\x86\Other\sqlredis. exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS" ExitCode: 0
After installing it worked.
SQL Server 2000
XPPro, sp1
Nicole

Enterprise Manager Closing with Access Violation

Hi, can anybody help me
I am using SQL Server 2000 Developer Edition
I am getting the following error
Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation reading location 0x00000064.
I'm sure its because of the following:
Access Violation Error Message in Mmc.exe After You Apply Internet Explorer Privacy Update from Q316116 or After You Apply Internet Explorer 6 SP1
How do I fix it?
Is there a patch/fix available
Did you try re-installing the client tools and/or reinstalling SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Noel" <anonymous@.discussions.microsoft.com> wrote in message
news:AA995939-AD26-485B-ABE4-AE59C838C1CE@.microsoft.com...
> Hi, can anybody help me
> I am using SQL Server 2000 Developer Edition
> I am getting the following error
> Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation
reading location 0x00000064.
> I'm sure its because of the following:
> Access Violation Error Message in Mmc.exe After You Apply Internet
Explorer Privacy Update from Q316116 or After You Apply Internet Explorer 6
SP1
> How do I fix it?
> Is there a patch/fix available
>
>
|||Yes, error still persists

Enterprise Manager Closing with Access Violation

Hi, can anybody help me
I am using SQL Server 2000 Developer Edition
I am getting the following error
Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation r
eading location 0x00000064.
I'm sure its because of the following:
Access Violation Error Message in Mmc.exe After You Apply Internet Explorer
Privacy Update from Q316116 or After You Apply Internet Explorer 6 SP1
How do I fix it?
Is there a patch/fix availableDid you try re-installing the client tools and/or reinstalling SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Noel" <anonymous@.discussions.microsoft.com> wrote in message
news:AA995939-AD26-485B-ABE4-AE59C838C1CE@.microsoft.com...
> Hi, can anybody help me
> I am using SQL Server 2000 Developer Edition
> I am getting the following error
> Unhandled exception at 0x0100bb5b in mmc.exe: 0xC0000005: Access violation
reading location 0x00000064.
> I'm sure its because of the following:
> Access Violation Error Message in Mmc.exe After You Apply Internet
Explorer Privacy Update from Q316116 or After You Apply Internet Explorer 6
SP1
> How do I fix it?
> Is there a patch/fix available
>
>|||Yes, error still persists

Enterprise Manager

Hello,
after starting the Manager, following error message is shown:
Error message details:
caption: MMC.exe - Entrypoint not found
details: Cannot find entrypoint of procedure ?
ProcessExecute@.@.YAXPAUHWND__@.@.PBG1@.Z not found in DLL-
file SEMSFC.dll
and the manager will be closed.
Perhaps anybdy can help me.
Martin F.
Can you give us more info. Did you install only the client tools? Are you
connecting to MSDE? Which version have you installed? Did you try to install
SQL Server SP3?
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Martin Feist" <M_Feist@.gmx.de> wrote in message
news:%23gSd0SaIFHA.1860@.TK2MSFTNGP15.phx.gbl...
> Hello,
> after starting the Manager, following error message is shown:
> Error message details:
> caption: MMC.exe - Entrypoint not found
> details: Cannot find entrypoint of procedure ?
> ProcessExecute@.@.YAXPAUHWND__@.@.PBG1@.Z not found in DLL-
> file SEMSFC.dll
> and the manager will be closed.
> Perhaps anybdy can help me.
> Martin F.
>
|||Hello,
i have installed SQL Server 2000 and SP3a,
a Database is running
then i wanted to install the Enterprise Manager
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> schrieb im Newsbeitrag
news:d0h113$4hl$1@.news01.intel.com...
> Can you give us more info. Did you install only the client tools? Are you
> connecting to MSDE? Which version have you installed? Did you try to
> install
> SQL Server SP3?
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
> "Martin Feist" <M_Feist@.gmx.de> wrote in message
> news:%23gSd0SaIFHA.1860@.TK2MSFTNGP15.phx.gbl...
>