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 2008 Forums
 SSIS and Import/Export (2008)
 Login fails with package configuration

Author  Topic 

varalakshmi
Yak Posting Veteran

98 Posts

Posted - 2012-02-16 : 02:07:54
Hi,

When package configuration is used to store a Database connection which has sql server authentication, the package fails with the error 'Login fails for the user' error.

When the same package is run with using the windows authentication database connection with package configuration enabled, it runs fine.

Please help in solving this issue as we prefer using SQL Server authentication for certain reason.

Thanks in advance.

- Varalakshmi
   

- Advertisement -