 | |
Re: DTS fails connecting to remote server
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: DTS fails connecting to remote server -
09-17-2004
, 04:28 PM
|
We have two W2K servers in Workgroup mode running SQL 2K. We use xp_cmdshell with /E switch to run DTS packages locally on each server. I have a new DTS package that deletes table rows on the other server, then copies local rows to remote table. The DTS package will execute directly & delete/add rows. But it gets error running xp_cmdshell from a stored procedure: 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' I have tried: exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /E' and exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /Usa /Ppassword' Thanks - |
#2
| |||
| |||
|
|
I have tried: exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /E' and exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /Usa /Ppassword' configuring as a domain is not feasable here. BC |
Quote:
|
Don't use /E switch, use the /U<SQL Login> and /P<SQL password> switches... or add your server to a domain and use domain credentials that have access... "Bil Click" <Bil Click (AT) discussions (DOT) microsoft.com> wrote in message news:7154E3E7-4616-4890-9759-65632D34E46B (AT) microsoft (DOT) com... We have two W2K servers in Workgroup mode running SQL 2K. We use xp_cmdshell with /E switch to run DTS packages locally on each server. I have a new DTS package that deletes table rows on the other server, then copies local rows to remote table. The DTS package will execute directly & delete/add rows. But it gets error running xp_cmdshell from a stored procedure: 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' I have tried: exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /E' and exec master..xp_cmdshell 'dtsrun /Sncid03 /Ncopy_control /Usa /Ppassword' Thanks - |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.