Hi All, I have created a SSIS package using BIDS-2008. This package is using XML configuration for package configuration and Xml configuration has following connection string Data Source=MYIP\sql2008; User ID=sa; Password=password; Initial Catalog=MyDatabase; Provider=SQLNCLI10.1; Persist Security Info=True; Auto Translate=False; Application Name=SSIS-Package-{D52E7BCF-719C-4774-8669-387586E74190}MYIP\sql2008.MyDatabase.sa ;< /ConfiguredValue> Other package information - ProctectionLevel : DontSaveSensitive - Run64BitRuntime : True (under package debugging node) This package is running absolutely fine in my system but I used following step to deploy on server - Copy Deployment folder to server ( this folder contains package, configuration file and package manifest file) - Click on manifest file =>next - Select File system deployment and validation package after installation - I got following error - - SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager " MyDatabase.sa" failed with error code 0xC0202009. (Login failed to sa) Please assist me that what/where I committed mistake. Any help would be appreciated. Here I want to deploy on server and to set as sql server job but now I totally frustrated by above error.

why you set protection level as Don'tSaveSensitive? !!! with this option, package will remove all sensitive information ( like connection password ), and this will cause that you got this error. use EncryptSensitiveWithPassword and set a password, this is a sample of how to deploy a package with EncryptSensitiveWithPassword and run it with sql server job: http://www.protalk.in/sql-server/steps-to-create-and-deploy-ssis-package-as-a-sqlagent-job/http://www.rad.pasfu.com

Initially I tried to deploy package with EncryptSensitiveWithPassword property but not succeeded then I read that use DontSaveSensitive property and save your password in configuration file. I also tried this one but it does not work for me. User account using to deploy on server does not have permission to login in SQLServer management server in window authentication, this might be cause. Or any other solution .

Initially I tried to deploy package with EncryptSensitiveWithPassword property but not succeeded then I read that use DontSaveSensitive property and save your password in configuration file. I also tried this one but it does not work for me. User account using to deploy on server does not have permission to login in SQLServer management server in window authentication, this might be cause. Or any other solution . Did you tried the link I suggested? it exactly explained how to use EncryptSensitiveWithPassword with pictures.http://www.rad.pasfu.com

Yes I tried this one also but it does not work for me

Yes I tried this one also but it does not work for me could you explain what did you do? and did you got any error ? if yes, what is error message?http://www.rad.pasfu.com

As Reza states, the password is removed when you deploy. Did you type the password back into the configuration file and try his link? When you say the package runs fine on your system, are you accessing the same SQL Server instance or is the server name in the deployed configuration file different. As a side issue, why are you running your package under the SQL Server "sa" account? This is bad design and definately not recommended as the 'sa' account. Better still, you should use Windows Authentication if you are running on a Windows domain. Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD