PRB: SQL Transfer Manager Fails with Destination/Source Error

  - Microsoft SQL Server version 4.21 and 6.0

SYMPTOMS

When you use SQL Server Transfer Manager to transfer a database from one server to another where the database names are the same, the transfer may fail with the error:

   The destination database must be different from the source database

CAUSE

If the source server and destination server have different names, two situations may cause the above error.

The first situation is that either the source or destination server name used was actually an alias server name that points to the same server. This situation can be checked by running the SQL Server Client Configuration Utility on the computer running Transfer Manager and checking the entries in the "Advanced" configuration window for aliases.

The second situation is that one of the server installations was a copy of the other. Either the MASTER.DAT may have been copied over or a MASTER database dump was loaded. This means that the entry for the local server in the SYSSERVERS table is identical for both the source and destination servers, and the @@servername global variable will contain the same name.

To confirm that this is the problem, run the following query on both servers:

   select @@servername

WORKAROUND

If "select @@servername" returns the same results on both the destination and source servers, you will need to determine which server needs to be updated. You can then run the following script to update the correct server:

   sp_configure allow, 1
   go
   reconfigure with override
   go
   update master..sysservers
   set srvname = "<new_server_name>",
       srvnetname = "<new_server_name>"
   where srvid = 0
   go
   sp_configure allow, 0
   go
   reconfigure with override
   go