MS SQL Server DTS - Cannot connect to the local server when creating Transfer Login Ta

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Cannot connect to the local server when creating Transfer Login Ta

T Ho

2006-01-30, 11:25 am

Hi,

I'm trying to create a new local DTS package. The first task is 'Transfer
Logins Task' (Task->16 Transfer Logins Task...). When the dialog displays,
it shows an IP address of some other Windows servers as the default of source
system. Normally, I see it display (local). So, I click the ... and select
(local) as the source system. Then I click on the destination tab. The
error displayed saying 'Cannot connect to the server WKELLABEL. Please check
the server name and try again'. However, WKELLABEL is the server name. What
is set wrong on this server? I logged in as a domain account, although it is
not a domain admin account, but I think it should be OK, right? Please help.
Thanks in advance.

Tsuey

Sponsored Links