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 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.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.|||The statement is:
SELECT * FROM OPENQUERY([<ipaddresshere>],'CCI.dbo.p_GetCMSGroupsByContentID "6918"') WHERE ID = 6
We have used the IP address instead of the server name.
This only fails when using the OPENQUERY statement. If I add a server using sp_addlinkedserver with the IP address specified it works.
"Narayana Vyas Kondreddi" wrote:
> 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.
>
>