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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-08-06 : 05:13:09
|
| Hey, i seem to be having alot of problems with trying to get my SSIS package to schedule as a job. I keep getting erros on the job related to login failed for user of the machine am log into. I created a package configuration file and made sure that all of connections to other database were selected as part of this. Am using windows authentication on all of my connection to the other database. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-08-06 : 06:23:23
|
| Am using windows authentication on all of my connection to the other databaseI am not sure...Maybe the Jobagent is not a member for windows authentication and you have to change to SQL Server Authentication.Webfred |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-06 : 22:49:59
|
| Or grant proper windows permission to sql agent service account. |
|
|
|
|
|
|
Package configuration