October 17, 2008 at 6:39 am
Hi, we have been bought out and will be recreating our new domain. We are going to be moving our sql server (hardware and software) to the new domain. The server name will stay the same as well as the entire database. All we are going to do is disconnect the physical server from the current domain and attach it to the new domain. We have domain accounts that run the sql services and only a few AD accounts as most of the connections to the database are SQL accounts.
What gotchas should we be looking for during this migration?
Thanks in advance.
November 23, 2008 at 3:44 am
if you have removed builtin admins group i would add that back first before switching domain memberships then remove when finished. If all the logins are SQL and you're not changing the server name then you shouldn't have too much of an issue at all
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 1, 2008 at 3:53 pm
Make sure the SPNs are created for the service accounts properly.
A.J.
DBA with an attitude
January 29, 2009 at 3:13 pm
First question, are your systems standalone or clustered?
From my experience, domain changes for standalones are straightforward. If your running off an existing domain account, change it to local and add your new domain after the restart.
Clusters are a bit more tricky, one experience is that when applying a service pack or update, sql would just throw up. It has something to do with the SIDs on which accounts setup the cluster.
Microsoft's suggestion was to rebuild.
March 10, 2009 at 2:33 pm
I recently moved a standalone 2005 SQL Server to a new domain and now I get an error when attempting to connect to the database that I had been using prior to the move. The server name and ip remained the same, just the domain changed. Any debug ideas that might help me understand why this is happening and resolve this?
March 10, 2009 at 4:09 pm
what is the error you are seeing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply