Enterprise Manager Problem

Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJ
Try reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegr oups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>

Enterprise Manager Problem

Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>

Enterprise Manager Problem

Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>

enterprise manager login to local server

I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
Steve
Whats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.

enterprise manager login to local server

I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.

enterprise manager login to local server

I'm running a local MSSQL 2000 server and everything has worked fine until
this week... when it suddenly stopped working and to fix it I had to
reinstall the master database... which now allows the server to run.
My problem is however that I cannot login to the database using windows
authentication mode... and when selecting new sql server registration within
enterprise manager and then clicking on the browse feature nothing is
returned as an active server.
Does anyone have any ideas as to how to resolve this?
For instance as I have reinstalled all the default databases do I have to
reset default usernames, etc... and if so how... as you can see I'm lost...
help?
SteveWhats the exact error or your problem ? Did you thought abou thte
orphaned users ?
http://support.microsoft.com/default.aspx?kbid=246133
HTH, jens Suessmeyer.

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.