SQL Enterprise Manager.msc opens only for local administrator
In SQL 2000 Enterprise Manager will not open for me when I'm logged on to the server using my domain account. I get the warning " MMC cannot open the file e:\program files\microsoft sql server\80\tools\binn\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 have sdded my domain account with full control permissions to the file.
If I use the runas command on the SQL Server Enterprise Manager.MSC, it will open using the local administrator account.
Thanks,
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 have sdded my domain account with full control permissions to the file.
If I use the runas command on the SQL Server Enterprise Manager.MSC, it will open using the local administrator account.
Thanks,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes it was a corruption. I followed your steps 1 to 6 above and this has fixed the issue.
Thanks for all your prompt help.
Good Luck to you.
Blossom Park
Thanks for all your prompt help.
Good Luck to you.
Blossom Park
ASKER