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.
| Author |
Topic |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2009-10-02 : 11:13:46
|
| Hi,I currently have sql server 2005 64 bit. I have created a ssis package that ftps a file from the server to another server. It runs fine if ran manually but when I schedule it using the SQL Job Agent... it fails.(It worked fine in sql server 2005 32 bit)I looked in event viewer on the destination server and the error I got was:"The server was unable to logon the Windows NT account #### due to the following error: Logon failure: unknown user name and bad password" This does not make sense because I can run it manually without any issues.Please help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 11:25:04
|
| whats the service account created for sql server agent for executing this package? |
 |
|
|
nguyenl
Posting Yak Master
128 Posts |
Posted - 2009-10-02 : 11:36:27
|
| I have tested used:1. Sql Agent Service Account2. A proxy account I have created. I have used the "sql agent service account" on sql server 2005 32 bit and it is working fine with no errors. |
|
|
|
|
|
|
sql 2005 64 bit SSIS FTP failure