Windows Forum

Ask something
Discussion Locked

SQL 7.0 Name Change

0 helpful
5 replies

by bsmontgomery1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
After SQL 7.0 has been installed, can I change the name of the server? How?

5 replies

by pete.zerger

the computer name and the SQL Server name must match. You can use the sp_addserver to change the server name. See SQL Books online for syntax of sp_addserver

by gutridgesj

i had an sql 7 svr named abc with ip 123. i had to migrate users from another sql server named def to use this data via odbc. so, i added another ip to abc called 456 and changed the dns entry for def to point to 456.

both work.

i am not sure if this helped or not.

This discussion is closed to new replies.