October 10, 2005 at 7:38 am
Sorry,I originally posted this in administration but then realised I was in admin uder notification services section so I have reposted it here:
If you have a SQL Server in another domain and the user can connect via a trusted connection from isql using named pipes but not TCP/IP can dtsrun be used to start a dts package on that server that requires a trusted connection?
Nigel Moore
======================
October 13, 2005 at 8:00 am
This was removed by the editor as SPAM
October 13, 2005 at 10:50 am
Nigel,
DTSRUN is a command-line utility. One of the parameters is
/E Specifies a trusted connection (password not required).
So yes, integrated authentication can be used.
For named Pipes to be used I would create an entry in Client Network Utility to explicitly specify Named Pipes protocol when connecting to this server
Yelena
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply