Moving SQL Server 2008 R2 Single instance to new domain

Question

Moving SQL Server 2008 R2 Single instance to new domain

Guras

SSCertifiable

Points: 6518
More actions
February 6, 2013 at 10:55 am

#273810

We are migrating to a new domain and I have few questions -
1. I need to change the SQL server start up service account from domain1\SVC_SQL to domain2\SVC_SQL
2. We are using a windows group domain1\GroupA and I need to have a new windows group account as domain2\GroupA. Is there a script to add all the permissions of the old account domain1\GroupA to the new windows group domain2\GroupA?
Besides all these is there any other thing I need to look at? Any help would be greatly appreicated. Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 1

Guras (2/6/2013)
We are migrating to a new domain and I have few questions -
1. I need to change the SQL server start up service account from domain1\SVC_SQL to domain2\SVC_SQL

No issues unless you have used this account to run the other jobs or linked servers etc..

2. We are using a windows group domain1\GroupA and I need to have a new windows group account as domain2\GroupA. Is there a script to add all the permissions of the old account domain1\GroupA to the new windows group domain2\GroupA?

you can script out as create login

Besides all these is there any other thing I need to look at? Any help would be greatly appreicated. Thanks

Make sure you have backup of all databases including system databases before you do anything ,...anytime.

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

Guras SSCertifiable Points: 6518 More actions · Answer 2

@SQLFRNDZ (2/6/2013)
Guras (2/6/2013)
We are migrating to a new domain and I have few questions -
1. I need to change the SQL server start up service account from domain1\SVC_SQL to domain2\SVC_SQL
No issues unless you have used this account to run the other jobs or linked servers etc..
Yes we have
2. We are using a windows group domain1\GroupA and I need to have a new windows group account as domain2\GroupA. Is there a script to add all the permissions of the old account domain1\GroupA to the new windows group domain2\GroupA?
you can script out as create login
Besides all these is there any other thing I need to look at? Any help would be greatly appreicated. Thanks
Make sure you have backup of all databases including system databases before you do anything ,...anytime.

AlexSQLForums SSChampion Points: 14277 More actions · Answer 3

DONT FORGET ALTER LOGIN [DOMAIN1\USER] with name=[DOMAIN2\USER]

Alex S