Could not find server '<server ip address here>' in sysservers.

Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000 o
n a WIN 2003 box. Both are different domains. I have set up several database
s to test and most work fine except for some .NET applications where I get t
his error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute sp_a
ddlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master
db > sysserver table the server name is VIVID01 and there is no mention of
IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.Can you show us which exact statement is failing? Are you trying to use the
4-part naming convention to connect from one server to another. In that
case, you will have to configure that other server as a linked server.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:5B8A7E57-322A-4674-A95B-1DDC9281DD6A@.microsoft.com...
Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000
on a WIN 2003 box. Both are different domains. I have set up several
databases to test and most work fine except for some .NET applications where
I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master
db > sysserver table the server name is VIVID01 and there is no mention of
IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.