When running both SQL Server 4.2 and SQL Server 6.0 servers at the same time on the same computer, to be supported by the graphical tools, the servers must use different names. For example, if you want to use SQL Transfer Manager to transfer data between the two, each must use a different server name.
You change a server name by using sp_addserver with the local option. For example:
sp_addserver POODLE, local
This changes the server name in the master.dbo.sysservers table and sets the @@servername global variable. The server must be restarted for the change to take effect.
Note The server name is only an issue if the two SQL Server installations are run simultaneously. You can have SQL Server 4.2 and SQL Server 6.0 installed on the same computer and have both use the same server name, as long as you run them one at a time.
For information about setting up a side-by-side installation, see Microsoft SQL Server Setup. For instructions on using sp_addserver, see the Microsoft SQL Server Transact-SQL Reference.