question

artistlover avatar image
artistlover 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.
sql-server-agent
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
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/
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I have proxy created.
0 Likes 0 ·
artistlover avatar image
artistlover answered
It still errors after i added that which was yesterday
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.