Solved

DTS Lookup Error - Could not find server '' in sysservers.

Posted on 2004-04-23
5
1,007 Views
Last Modified: 2012-08-14
Error Source : Microsoft OLE DB Provider for SQL Server

Error Description : Could not find server '' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

I am getting this error when I try and create a lookup for a data transformation in a DTS package. The lookup is needed on the local server. At a point in the past this machine has been renamed, which may have caused the problem, and if I had more time I would rebuild the system as it needs it anyway. However, it is not possible now and I need to have this DTS package created and tested ASAP.

Whats causing the error, how do I solve it so that I can create a Lookup on the local machine. Currently I can make the lookup, and it works ok, but this error does not bode well for future performance.

Cheers
0
Comment
Question by:sshelton2
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:ranjit_jerome
ID: 10898302
Hi

You need to add the server name in master..sysservers.  Use sp_addserver

sp_addserver 'servername', 'local'
0
 
LVL 1

Author Comment

by:sshelton2
ID: 10898318
And how do I run that - Command prompt or Stored Procedure?

Sorry - low level is not normally my residence in SQL Server...
0
 
LVL 3

Accepted Solution

by:
ranjit_jerome earned 400 total points
ID: 10898378
Use query analyzer, this is a one time setting to correct the sysserver entry to recogzine your server.
0
 
LVL 1

Author Comment

by:sshelton2
ID: 10898419
Bang on, thats killed the error off and solved the problem. All tables are populating as it should, thanks.
0
 
LVL 3

Expert Comment

by:ranjit_jerome
ID: 10898432
No problem :)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now