A subsidiary of my company has been sold, need advice on pre-emptive tasks before Domain1 is removed from trusted Domain2.

• Velveeta22

  Ten Centuries

  Points: 1289

  More actions

  June 24, 2015 at 8:14 am

  #298003

  My company currently has two very different lines of business, each on different domains. In the coming month, Domain1 will no longer be a trusted domain over to Domain2. I know there are objects owned by Domain1\user on Domain2 and vice versa. Can anyone give me advice for a checklist on items that need to be completed on the sql servers before the domain trust breaks?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 728159

  More actions

  June 24, 2015 at 8:33 am

  #1807767

  My short list, which is probably incomplete as I've never done this. I've gone the other way.

  Look in these areas, for dependencies. You should be able to query DMVs for the info on all instances. Look for the domain1 name.

  - server_principals

  - linked servers

  - proxies (SQL Agent, xp_cmdshell)

  - jobs

  - maintenance plans/SSIS packages

  - filters in audits/ee sessions/traces

  - database owners

  - service accounts

  - replication items

  - database mail

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com