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

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

Date: Thu, 30 Dec 2004 05:25:03 -0800

Conclusion.

I was never able to find a fix to my missing sysadmin privs problem.

As part of a Windows 2003 migration effort, we moved all the development
databases to a new (reused) Windows 2003 server. I simply copied all the
data files over and attached them.

If not for the migration then I was going to execute Dan's suggestion.
Hopefully, it may help someone else.

Thanks!!!

"Dan Guzman" wrote:

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