sa Connection Error

• sql_Reporter

  SSCrazy

  Points: 2329

  More actions

  August 22, 2008 at 4:22 am

  #123185

  Hi i've 2 servers and want to work between them doing some ETL work.

  So i created my connections is SSIS to server 1 and then to server 2 am working off server 2.

  I use windows authentication to connect to server 1 and server 2.

  This worked fine when i ran the package in the SSIS designer

  I then use SQL authentication to connect to server 1 i used sa and the sa password and windows authentication for server 2.

  But this time the package failed on the connection to server 1 i tick to save password and tested the connection and it was fine but when i executed the package it failed. any ideas ?

• Sarang Bobde

  Mr or Mrs. 500

  Points: 534

  More actions

  August 22, 2008 at 5:50 pm

  #862165

  I think even you store the password, in SSIS password is not stored in the connectionstring. You can check the property value fir the connection.

  Use SSIS Configurations for SQL server authenticaton in SSIS.

  Hope This helps 😉