January 4, 2010 at 3:17 am
I have to do an SQL Server 2005 domain migration & renaming
Is my checklist complete?
Is there an impact if the "Database Owner" is from the old domain?
--Domain migration
security tab of the sql server:
check old domain groups/add new domain groups
sql services::
deactivate all sql services
change the service accounts to the new domain accounts
domain::
change the domain of the server
Reboot and activate the deactivated services.
--Rename SQL Server with default instance
Pre-Step Delete all your maintenance plans and recreate them after you changed the name
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO
January 4, 2010 at 1:06 pm
simon.ciglia (1/4/2010)
Is there an impact if the "Database Owner" is from the old domain?
As long as the domain still exists and there is a trust relationship between the two - then no impact. It is better to make sure the DB Owner is an account that exists.
--Domain migration
security tab of the sql server:
check old domain groups/add new domain groups
sql services::
deactivate all sql services
change the service accounts to the new domain accounts
domain::
change the domain of the server
Reboot and activate the deactivated services.
--Rename SQL Server with default instance
Pre-Step Delete all your maintenance plans and recreate them after you changed the name
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO
Looks like you have it covered.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply