question

Normajean avatar image
Normajean asked

Steps to move server from one domain into another?

Hello; I am a developer who has become the "accidental" dba for a hosted web app. Our IT dept is planning to move all servers (database, web, sharepoint) for our app off of the corporate domain and into it's own domain. The SQL databases will stay on the same server, we just need to move it from one domain to another. I've searched on the web, but all the instructions I've found all assume that you're also going to move the databases onto a new server too, and I can't find much info on my more simple case where the database will stay put but the server will move. Here is what I've put together so far (does it look like I am missing anything?)

Thanks sooo much for the extra set of eyes and any advice you can give! Normajean

  1. Backup SQL Server databases and copy them to another machine
  2. Change SQL Server accounts to local system.
  3. Restart SQL server and verify correct operation.
  4. Stop and disable SQL Server Services.
  5. Move the machine to the other domain
  6. Enable SQL Server Services.
  7. Start SQL Server
  8. Change the service accounts to the new domains accounts
  9. Restart the server to verify correct operation.
domains
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered

I'm by no means a networking expert, so if there are subtle bits of information that I don't know about... I don't know about them. However, based on what I can see you doing, I think you have the bases covered. The only addition I would make is to have a client validation step where you verify client connectivity prior to announcing completion of the migration. Also, what's your GTH plan?

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Normajean avatar image Normajean commented ·
Hi Grant! Thanks for your feedback - I'm not sure what a GTH plan is. My first thought was that this is the plan if things 'go-to-hell' LOL, but that's probably not what you meant.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
No, you got it right. If everything goes south, what's the plan?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.