An importanat problem to be solved

[Jay]

Hello friends I need a very ergent help!!!!!!!!!!!!!
Problem: my sql server on production had everything grayed out, when I want to administer this server as a SA. eg: I can't add users, I can't backup and so on.
but the database is still running and users are accessing it.
This SQL database is accessed by an application(it can also create users on
the backend). I don't know how it happend ( i cant even get to errorlog).
I beleive somehow sa user rights were taken away from him. Can anyone tell me how to restore sa with all rights.

Please help me on this matter, because I have to do lots of important tasks on this server.

I appreciate all of your help.

Thanks
Ragul

[Craig]

Unregister and re-register using standard security with SA as the userid and the password.

You must be connecting trusted and someone changed permissions......


------------
Jay at 12/8/99 10:36:21 AM

Hello friends I need a very ergent help!!!!!!!!!!!!!
Problem: my sql server on production had everything grayed out, when I want to administer this server as a SA. eg: I can't add users, I can't backup and so on.
but the database is still running and users are accessing it.
This SQL database is accessed by an application(it can also create users on
the backend). I don't know how it happend ( i cant even get to errorlog).
I beleive somehow sa user rights were taken away from him. Can anyone tell me how to restore sa with all rights.

Please help me on this matter, because I have to do lots of important tasks on this server.

I appreciate all of your help.

Thanks
Ragul

[jay]

Hi Crig,
I did exactly what you were asking me to do, still the same. I can connect as sa using isql, register the server with sa passwd. but everything still grayedout. I am also domainadmin aswell as local admin on my nt. Please help me, the strees level is reaching very badly, and I really appreciate your prompt repley, Thanks a lot.

Jay


------------
Jay at 12/8/99 10:36:21 AM

Hello friends I need a very ergent help!!!!!!!!!!!!!
Problem: my sql server on production had everything grayed out, when I want to administer this server as a SA. eg: I can't add users, I can't backup and so on.
but the database is still running and users are accessing it.
This SQL database is accessed by an application(it can also create users on
the backend). I don't know how it happend ( i cant even get to errorlog).
I beleive somehow sa user rights were taken away from him. Can anyone tell me how to restore sa with all rights.

Please help me on this matter, because I have to do lots of important tasks on this server.

I appreciate all of your help.

Thanks
Ragul