Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Run As SQL Server Connection

Author  Topic  dfaber Starting Member 1 Post Posted - 2008-11-13 : 14:12:10 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.