Wednesday, March 21, 2012

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

No comments:

Post a Comment