asked
Question about sqlagent account.
I have couple of ssis packages that call an access database. The jobs won't run. I asked server guy to make sure sql agent had rights to the folder he sent this following response. I really don't know how to do this or what exactly he means. I'd rather ask you all for guidance before my boss realizes I'm lost. Here is the response to my email. I think we’re going to continue to run into this problem if we don’t stop now and set SQL server and SQLAgent to run as an account. The issue that we’re having is that it is making the call as a local system. I can’t give that account access to other resources. Can we get in front of this and get the ACBSQLServerAgent set as the caller account without causing too many issues? This will also alleviate our issue with Wspiffdata3 being able to connect to the Yeti drive to do backups.
SSIS Package should run under a proxy account in SQL Server jobs, make sure you have created proxy account for this. Check [here][1] and [here][2]. [1]:
http://msdn.microsoft.com/en-us/library/ms139805(v=sql.90).aspx [2]:
http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/
It still errors after i added that which was yesterday
11 People are following this question.
