General discussion

Locked

SQL 7.0 server domain change

By matt ·
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?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL 7.0 server domain change

by wsmoth In reply to SQL 7.0 server domain cha ...

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!

Collapse -

SQL 7.0 server domain change

by matt In reply to SQL 7.0 server domain cha ...

Poster rated this answer

Collapse -

SQL 7.0 server domain change

by rsutton In reply to SQL 7.0 server domain cha ...

See BOL and search on "ATTACH"!

Good Luck

Collapse -

SQL 7.0 server domain change

by matt In reply to SQL 7.0 server domain cha ...

Poster rated this answer

Collapse -

SQL 7.0 server domain change

by matt In reply to SQL 7.0 server domain cha ...

This question was closed by the author

Back to Windows Forum
5 total posts (Page 1 of 1)  

Operating Systems Forums