Lost sysadmin, but yet I have it???

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

Date: Sun, 19 Dec 2004 15:45:02 -0800

SQL Server 2000 SP5a on Windows 2000 SP4

Friday 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.

Saturday I was able to restart the instance (actually, several times now),
but that does not seem to resolve the problem. I have also rebooted the
server, which does not solve the problem.

The next option would be to restore Master from a few days ago, but since I
have no privileges I cant even do that!!!

Help? Ideas? 

-- 
Chris

Relevant Pages

  • Lost sysadmin priv, but I still have it???
    ... This morning we discovered that we no longer have sysadmin privileges. ... and we have many SQL Server ... authenticated accounts with sysadmin privs. ... If not then restoring Master from a ...
    (microsoft.public.sqlserver.connect)
  • 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)