Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Builtin\Administrators Needs to be added Expand / Collapse
Author
Message
Posted Sunday, January 31, 2010 9:11 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 11:20 PM
Points: 612, Visits: 452
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
Posted Sunday, January 31, 2010 10:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:11 PM
Points: 32,810, Visits: 14,959
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
Posted Sunday, January 31, 2010 11:31 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:12 PM
Points: 22,518, Visits: 30,269
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.



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
Posted Monday, February 01, 2010 3:32 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 11:20 PM
Points: 612, Visits: 452
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
Posted Monday, February 01, 2010 4:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 1,287, Visits: 777
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
Posted Monday, February 01, 2010 8:53 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:11 PM
Points: 32,810, Visits: 14,959
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
Posted Monday, February 01, 2010 8:57 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:12 PM
Points: 22,518, Visits: 30,269
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.



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 #857259
Posted Monday, February 01, 2010 9:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, November 17, 2013 1:30 PM
Points: 41, Visits: 220
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
Post #857268
Posted Monday, February 01, 2010 9:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 1,287, Visits: 777
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
Posted Monday, February 01, 2010 9:36 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:11 PM
Points: 32,810, Visits: 14,959
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 »

Add to briefcase 12345»»»

Permissions Expand / Collapse