Builtin\Administrators Needs to be added

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Builtin\Administrators Needs to be added

43 posts, Page 1 of 5

1 2 3 4 5 »»»

Builtin\Administrators Needs to be added

Rate Topic

Display Mode

Topic Options

Author

Message

Jeetendra

Posted Sunday, January 31, 2010 9:11 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:42 PM
Points: 612, Visits: 439

HI ALL,

I have removed the BuiltIn\Administrators group from SQL Server 2005.

Now I dont have any access to the SQL Server.

Also the SQL Server has been configured for the Windows Authentication Mode only.

Now i need to get the access to the SQL Server and add back the above group to the sysadmin role.

Also please note that i dont have the SA Password set as the SQL Server has been configured for the Windows Authentication only.

Please do let me know to achieve the above.

Kindest Regards,

Jeetendra

Post #856908

Steve Jones - SSC Editor

Posted Sunday, January 31, 2010 10:11 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

If you don't have a windows account with administrative access, I suggest you find the media for SQL Server and perform an uninstall/reinstall.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #856928

Lynn Pettis

Posted Sunday, January 31, 2010 11:31 PM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:17 PM
Points: 21,617, Visits: 27,450

Actually, since you are running SQL Server 2005, if yoour account has SysAdmin rights you can still can access to your system. You will need to restart SQL Server in single user mode. Not sure how to do it right off the top of my head, but if you check Books Online, you should be able to find the necessary switch settings.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #856949

Jeetendra

Posted Monday, February 01, 2010 3:32 AM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:42 PM
Points: 612, Visits: 439

Hi,

As mentioned I dont have any Windows account that have sysadmin rights in the SQL Server.

Also the SQL Server is configured for windows Authentication Only.

Please do let me know how do i add the BuiltIn\Administrators group back to SQL Server.

Kindest Regards,

Jeetendra

Post #857021

Robbert Hof

Posted Monday, February 01, 2010 4:02 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:29 AM
Points: 1,282, Visits: 744

Jeetendra,

as Lynn stated, start the SQL Server in single user mode.
When you are administrator on the server, you will have sysadmin rights on the SQL Server, no matter what.

HTH

Robbert

Post #857040

Steve Jones - SSC Editor

Posted Monday, February 01, 2010 8:53 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

Robert,

Is that true? In that case, security is being bypassed for single user mode. That's a big hole. If you don't have rights, you shouldn't be able to connect in Single user mode.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #857250

Lynn Pettis

Posted Monday, February 01, 2010 8:57 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:17 PM
Points: 21,617, Visits: 27,450

Requires restarting SQL Server from the command line using a switch (check with K Brian Kelley (sp ?)) which means you need access to the server; actually physically or using RDP.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #857259

DavidZahner

Posted Monday, February 01, 2010 9:06 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 3:03 PM
Points: 40, Visits: 210

Have you tried this: http://www.sqlservercentral.com/articles/Administration/68271/

How to Connect to a SQL 2005 Server When You Are Completely Locked Out
By Rudy Panigas, 2009/11/03

David Zahner

Post #857268

Robbert Hof

Posted Monday, February 01, 2010 9:31 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:29 AM
Points: 1,282, Visits: 744

From http://msdn.microsoft.com/en-us/library/ms188236.aspx
Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role. For more information, see Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out.

Post #857305

Steve Jones - SSC Editor

Posted Monday, February 01, 2010 9:36 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

Robbert,

Thanks, didn't realize that. In essence, I think that means that all your encryption security is gone if someone can get Admin access to the box. A hole I didn't realize.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #857319

« Prev Topic | Next Topic »

43 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions