Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Desperate to get "sa" acct reinstted

Status
Not open for further replies.

btturner

Programmer
May 17, 2001
175
US
I'm desperate to get our "sa" account reinstated-- (SQL 2K)

"sa" is not showing in Ent. Mgr. Security / Logins however it is displayed when I do a SELECT * FROM SYSXLOGINS

"sa" was inadvertantly dropped by issuing DELETE FROM SYSXLOGINS (by another DBA!)

Is there a way to reinstate SA -- so it displays under EnterPrise Mgr's Security / Logins???

thx in advance
 
I uninstalled & reinstalled SQL Server (after doing the prereq tasks of backing everything up.. and rebuilding) all is fine.
 
im curious why did you need to get it done so fast? no one should be using sa for anything. was it impacting your server, were things failing?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top