Re: What do you do when no one has sysadmin rights?


"mbgrood" <mgrood@xxxxxxxxxxxxxx> wrote in message
news:1146083718.487278.197670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
We have an installation of SQL Server 2005 that allows windows
authentication only. None of our windows users have been explicitly
granted sysadmin rights, but my understanding was that if you are a
member of the windows administrator group you will automatically have
sysadmin rights to sql server. This does not appear to be the case.
Is there a way to get our sysadmin rights back or will we have to do a
re-installation?



Restart the instance in single user mode (which only a local admin can do).

http://msdn2.microsoft.com/en-us/library/ms180965.aspx

Then log in as a local admin and you will magically be a sysadmin.

Re-add builtin\administrators login and give it the sysadmin server role and
restart the server in normal mode.

David


.

Relevant Pages

  • Re: Processing Cube from different machine
    ... But at client place our application do not get SysAdmin rights ... you could always have your DSO scripts running on the ... >> server and have something like NT Scheduled Tasks ... > SQL server. ...
    (microsoft.public.sqlserver.olap)
  • Re: Security problem of Transfer Login Task
    ... > ids from one server to another server. ... > which does not have sysadmin rights. ... The task transferred the login ids that I selected successfully. ...
    (microsoft.public.sqlserver.security)
  • RE: Non SA Job owner running under SA security context
    ... Look in the database security (and I would look at the server security as ... the name of the login that runs the SQL Server agent as if it has SA rights. ... This login does NOT have sysadmin rights and I ...
    (microsoft.public.sqlserver.server)
  • Re: order of columns
    ... I'm not supposed to have sysadmin rights but I accidentally have ... > You invoke Profiler using menu option SQL Server Profiler in Microsoft SQL ...
    (microsoft.public.sqlserver.programming)