Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2005 changed domains - reset security

Status
Not open for further replies.

JordanCN2

IS-IT--Management
Feb 7, 2011
39
US
Our company purchased another company and created a temporary trust in Active Directory between Company A and Company B. The small Company B had just on server which was their DC and SQL 2005 server.

We just took down the Company B domain by using DCPROMO to remove this server as the last DC in the domain and joined it as a member server to Company A. The server has a number of account logons that are from the old domain that we cannot seen to get rid of. How do I get rid of the orphan accounts (COMPANYB\Domain Users, COMPANYB\Domain Admins) ?
 
They are listed as logins within SQL Server? Just blow them away. There shouldn't be anything stopping you. Unless those accounts own objects in databases you should be able to just delete them. SQL shouldn't be contacting the domain in order to delete them.

Do you actually have admin rights to the SQL Server instance?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Site
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top