Run As SQL Server Connection

• dfaber5

  Newbie

  Points: 5

  More actions

  November 13, 2008 at 1:13 pm

  #126877

  I'm trying to connect to a remote SQL Server using SSIS 2005 in BIDS. I can only connect to this remote server using Run As a different user and Windows Authentication in SSMS from my local machine. The remote server does not allow SQL authentication and is managed by a different team. How can I connect to it using SSIS BIDS? Thank you for any help.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  November 13, 2008 at 8:55 pm

  #898394

  Execute devenv with RunAs command. devenv is the executable used for BIDS.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/