-
An importanat problem to be solved
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
-
An importanat problem to be solved (reply)
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
-
An importanat problem to be solved (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|