Re: Lost sysadmin, but yet I have it???

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 07:56:02 -0600

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

You might try rebuilding master and then restoring the master and msdb
databases from your last known good backup.

I've never seen the behavior you describe so I'd be concerned about the
underlying cause. Did you have a strong 'sa' password? 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Chris" <Chris@discussions.microsoft.com> wrote in message 
news:E36728CB-57A5-4996-97C4-93ECC95C7796@microsoft.com...
> 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

  • Re: i am denied access to my back up files
    ... my computer but now i cant get access to anyfiles cause it says access ... user does not have privileges. ... i am the owner and only user of this ...
    (microsoft.public.windowsxp.help_and_support)
  • Automatic updates
    ... Cant use SUS admin as the server is running NT4 ...
    (microsoft.public.win2000.windows_update)