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

Moving SQL Server 2008 R2 Single instance to new domain Expand / Collapse
Author
Message
Posted Wednesday, February 06, 2013 10:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 28, 2014 8:02 AM
Points: 197, Visits: 698
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
Post #1416645
Posted Wednesday, February 06, 2013 1:00 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, March 27, 2014 6:04 PM
Points: 450, Visits: 991
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.



--SQLFRNDZ
Post #1416702
Posted Wednesday, February 06, 2013 1:14 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 28, 2014 8:02 AM
Points: 197, Visits: 698
@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.
Post #1416706
Posted Wednesday, February 06, 2013 1:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 10:03 AM
Points: 1,256, Visits: 1,758
DONT FORGET ALTER LOGIN [DOMAIN1\USER] with name=[DOMAIN2\USER]

Alex S
Post #1416712
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse