dtsrun and network protocols

• nmoore

  SSCrazy

  Points: 2414

  More actions

  October 10, 2005 at 7:38 am

  #95375

  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

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  October 13, 2005 at 10:50 am

  #597163

  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