February 14, 2007 at 7:24 pm
I just found out we need to move 2 sql severs (2000 and 2005) into our domain in a few days. Can anyone tell me what is involved here. I have some ideas but any help would be great.
February 15, 2007 at 1:06 pm
1. Check if users from the other domain that will not be accessible are logins in your SQL Server and owns anything including running jobs and DTS packages. Jobs and Packages will not run, users will not be able to connect if these domains don't have trust.
2. Check services startup accounts.
3. Check printers and other resources if appropriate.
4. Check fully qualified names for the servers, shares etc.used for connections from your server. Since it could be in the packages or jobs, ask your developers to check.
5. On your servers: add a DNS Suffix for the old domain to TCP/IP properties in Local Connection properties. Maybe old connections will work then.
6. (should be # 1) Tell your users! Update their connections.
7. Request DNS aliases referencing the old fully qualified names if possible in the new domain if the old server fully qualified name will not be used in the old domain.
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply