I have a package which will run in Management Studio. The package is saved in MSDB. When I try to set up a job, the step errors out with what appears to be a login error. I am specifying windows authentication in the job and also used that when creating the package.
the reason is security, probably you created the package with a different account than the sql server agent is running.
you can create the package with the agent account,
or in the package -> properties -> security -> protectionlevel -> choose encryptsensitivewithpassword en fill in a password.
the package was originally created in management studio using the administrator account. do I need to set up the SQL Agent as a user? Is there a book on SQL Server 2005 which walks you through creating a sample solution from start to finish? I have the Administrator's Consultant and 'Changing the Paradigm' books. SQL Server 2005 is entirely new to me; I was a dba for Sql Server 2000 before this.
Thanks for your help!