Discussion Locked

SQL 7.0 server domain change

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a SQL 7 server in a system that used to consist of 6 domains, we are in the process of moving to a single domain. What extra steps are required for the SQL server?

5 replies

by wsmoth

If the new domain name is the same as the domain name that the SQL server is in, nothing. If you are moving it to a new domain and SQL is on a stand alone server, you can just move it into the new domain. I would not recomend this though. We did thesame thing recently and I started having all sorts of problems. Here is my recommendation:
1)Backup all of SQL to tape.
2)Move the server into the new domain.
3)Reinstall SQL (nothing will be changed, but it will re-establish naming connections that are vital to how SQL works)
4) Test SQL for inconsistancies in the data.

If you find inconsistancies, do a complete restore from the tape backup.

Reinstalling SQL is the same procedure that you follow when, and if, you change a server's name. Nothing gets changed but name associations that are needed within SQL server.

Good Luck!

This discussion is closed to new replies.