Could not find server <ip address> in sysservers

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Could not find server <ip address> in sysservers

Author

Topic

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2004-07-15 : 02:57:26

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.

Kristen
Test

22859 Posts

Posted - 2004-07-15 : 09:36:01

Could be 4 part naming.

So I connect to a database called MyDB server called VIVID01 which is on IP address 10.1.1.10

I can reference a table by:

SELECT * FROM MyTable
SELECT * FROM dbo.MyTable
SELECT * FROM MyDB.dbo.MyTable
SELECT * FROM VIVID01.MyDB.dbo.MyTable
SELECT * FROM [10.1.1.10].MyDB.dbo.MyTable

Also, I can select stuff from ANOTHER Server which is linked to this one. The "Link" provides me with the name, and I can only use that name. So I MAY have set up the linked server with a Friendly Name or (if I hadn't figured out how to use ALIAS on the server<g>) with the IP Address.

SELECT * FROM MyFriendlyLinkedServerName.MyDB.dbo.MyTable
or
SELECT * FROM [1.2.3.4].MyDB.dbo.MyTable

If they set up a linked server on the old box using the IP Adress method you're pretty much hosed - the application/SProcs/Triggers/DTS/Jobs/etc will need to be changed.

However, I reckon (if that IS the case) that you could set up a new Linked Server using the old IP Address as the "Friendly name" - that would be a First Class Cheesy Solution

If any of this looks like the area of your problem I've got some scripts lying around which will help create the linked server as-you-need-it.

Other possibility is you just need to change the connection string to use the SERVER NAME and not the IP ADDRESS (you'll need some DNS to get the name resolved, type PING VIVID01 from DOS on the machines attempting to connect to your server)

P.S. Matt - just seen you are at 181 posts, sorry if I've pitched this at Newbie level

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources