there is no sysadmin

Question

Post reply

there is no sysadmin

hany-donia

Newbie

Points: 4
More actions
May 13, 2009 at 5:50 am

#132265

Dear all;
Currently I’m facing an issue with one of the instances in my company , this instance is running forefront databases, the situation as follow.
1- The server authentication is windows authentication mode,
2- There no one in the sysadmin role except the SA account,
Now I want to add myself to the sysadmin role and I’m not able any idea please as this is very critical to us.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Is the BuiltIn\Administrators group there? Is it sysadmin?

Are you a member of the Local Administrators group on that server?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

hany-donia Newbie Points: 4 More actions · Answer 2

no it is not there , and i'm a local admin , but the issue as you know if the BuiltIn\Administrators , then i have no privileges over SQL Server ,

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

Can you stop the SQL Server for a short while?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

hany-donia Newbie Points: 4 More actions · Answer 4

sure if there is need i'll raise a RFC with the required downtime.

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 5

If you are a local Administrator in Windows on the SQL Server server, you can start the service in single user mode with the -m parameter and any local administrator account on the server will have sysadmin rights to login while the service is in single user mode.

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

hany-donia Newbie Points: 4 More actions · Answer 6

Dear MR. Jonathan;

Tested and it is working fine , I can’t thanks you enough but thanks thanks.

Warm Regards ...

Hany Samir Donia

Windows System Administrator

Windows Admins Team

ITO – Zain KSA

Zain Datacenter Bldg, Riyadh – KSA

+966 592445200

+966 592415200

+2 0105520023

hany.donia@sa.zain.com

Wonderful World...

High Quality Service … Customer Satisfaction

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 7

It is the same direction that Gail was sending you. I've had to get myself out of a jamb in the past where I removed BuiltIn\Admins before putting my login into a new server and then locked myself out of the instance.