Lost sysadmin priv, but I still have it???

From: Chris (Chris_at_discussions.microsoft.com)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 06:31:05 -0800

SQL Server 2000 SP5a on Windows 2000 SP4

This morning we discovered that we no longer have sysadmin privileges. We
were able to query the syslogins table. In the output we can clearly see
that our accounts do have the sysadmin privileges, since there is a 1 in that
column. But yet we do not have sysadmin privs!?!?!?!??!?!? Puzzling.

We are not able to get into the SA account, since no one knows the password.
 But we are in BUILTIN/Administrators, and we have many SQL Server
authenticated accounts with sysadmin privs. But yet none of them seem to
have the privilege.

For tonight, were thinking about restarting the instance. If that doesnt
solve it then rebooting the server. If not then restoring Master from a
previous backup. If not then rebuilding Master and then reattaching all the
user databases.

Help? Ideas? 

-- 
Chris

Relevant Pages

  • Lost sysadmin, but yet I have it???
    ... Friday morning we discovered that we no longer have sysadmin privileges. ... were able to query the syslogins table. ... and we have many SQL Server ... authenticated accounts with sysadmin privs. ...
    (microsoft.public.sqlserver.security)
  • Re: Error 87 from GetProxyAccount on line 604
    ... Make sure the 'Only users with sysadmin privileges ...' ... unchecked from Enterprise Manager ... >execute permissions on the proc and used ... The version number of SQL Server is 08.00.0818 ...
    (microsoft.public.sqlserver.security)
  • Re: changing sa password
    ... And once you've changed the password, stop using sa to log in to SQL Server. ... should create logins for people who really need sysadmin privileges so that you ... Change the Applcation connection strings to use new user ... Change the Linked server security credentials if SA is used ...
    (microsoft.public.sqlserver.security)