Post reply

dtsrun and network protocols

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply