SQL Server 2008 R2 , change domain

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Modest DBA Right there with Babe Points: 756 More actions · Answer 1

Hey, speak to the system admins, to add an alias on the DNS pointing to the new server.

fasttrack2 Mr or Mrs. 500 Points: 537 More actions · Answer 2

Hello,

many thanks.

Your solution looks very interesting but we are sure that an ALIAS in DNS solves our problem?

The domain change should change the <famous> SID for the user? This could affect the entire user access?

Thanks

fasttrack2 Mr or Mrs. 500 Points: 537 More actions · Answer 3

Hi,

Do you have any advise about the change domain?

Kind regards

Superdoc SSCommitted Points: 1654 More actions · Answer 4

Hi,

There will be impact to the SQL Server when a domain name is changed, you'll have to see the steps below to get back SQL to the new domain.

1. All Logins must be re-added back to the sql server with same global level permission and user level permissions on each databases.

2. Ensure you have at least one SQL account that has sysadmin access so you would have to enough permissions to add back the users.

3. Update the SQL Server's service account to the new domainname\user for all services logon from SQL Server Configuration Manager.

4. If Replication or Logshipping used then you must ensure the shared folders have the same permissions since you'd have to re-add the users.

5. If linked servers then you need to reconfigure them with new credentials.

Regards,

pradeep.mohan SSCrazy Points: 2849 More actions · Answer 5

Hi,

Will it log shipping work without interrupt the below points did?

SQL server's service account changed to new domain account and log shipping shared folder permission is re-added to users.

Thanks.

Pradeep