I have a SQL Server 2000 instance (runs Microsoft Dynamics GP) that is installed on a domain controller.
I am moving to a new domain with a SQL Server 2008 instance, but for approximately one weekend, I need to maintain access to the SQL 2000 instance.
The instance is using mixed mode and logins are stored inside of SQL. I'm not looking to add the server to the new domain for the one week period.
My plan is to:
1) Demote the server 2) Make sure I have a local administrator login on the server 3) Connect to new network and let DHCP assign it an IP 4) Reboot server and login locally 5) Change ODBC settings on the user machines to point to the new instance
Is there anything else that I need to check or do to make this work?
Consider using CNAMES in the DNS - therefore you won't need to change ODBC settings in the future Check there aren't SQL Server Agent jobs or scheduled tasks running Check there isn't momitoring What are you doing about backups?
I'm going to do a full backup prior to the domain disconnect. Then each night, a full backup stored on an external USB will be sufficient based on our service level agreement.
SQL Server 2000 - Domain Changes
Posted - 10/06/2012 : 18:11:00
