I created a package that I am having problems deploying and running on a
remote server. I have the following properties set on the package:

ProtectionLevel = DontSaveSensative
CreateDeploymentUtility = True

I created an xml configuration file and have the passwords for my connection
strings (FTP Conn Mgr and SQLClient Data Provider).

I run the manifest file selecting a sql deployment and to validate the
installation. I enter the values for the passwords in the configuration file
and finish running the utility. The validation completes with no errors.

I manually run the package from Mgt Studio on my machine and it works. I
then remote into the server where package was installed (using the same NT
credentials), manually run the package and it fails. The error returned is
0x80131904 “Error: System.Data.SqlClient.SqlException: Login failed for…”.
Of course, when I setup a job this also fails. If I manually run the package
from the server and use the exact same configuration file used when deploying
the package everything works fine.

Any help would be greatly appreciated.