SQL Server Agent Permissions Question

Question

SQL Server Agent Permissions Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

SSIS not liking share drive is not the issue because SSIS cannot get to any location without the Agent so it is dependent on the account used to run the Agent and permissions of the owner of the package and Agent job. Check the first link below for accounts used to run the Agent which you can change in configuration manager right click properties change account. The second link is about permissions to run SSIS package in a network share.

http://msdn.microsoft.com/en-us/library/ms345380.aspx

http://www.sqlservercentral.com/Forums/Topic661486-148-1.aspx

Kind regards,
Gift Peddie

Mike Green-427952 SSC Veteran Points: 296 More actions · Answer 2

SSCrazy, thanks for responding.

First, the account the SQL Server Agent runs under currently is Local System.

Second, the owner of the package will be the sa account.

So is it implied that I need to get with my company's Network Group and have a special Domain Account that is a Domain Admin created and this is what the SQL Server Agent would run under and it will be the owner of package?

I'm hoping there is another way besides having to create a special account.

Let me know if I am not understanding correctly.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

Mike Green-427952 (12/17/2009)
SSCrazy, thanks for responding.
First, the account the SQL Server Agent runs under currently is Local System.
Second, the owner of the package will be the sa account.
So is it implied that I need to get with my company's Network Group and have a special Domain Account that is a Domain Admin created and this is what the SQL Server Agent would run under and it will be the owner of package?
I'm hoping there is another way besides having to create a special account.
Let me know if I am not understanding correctly.

You understand me correctly because that is what Microsoft says in the link I posted because when running in local system account the Agent those not have access to network resources.

Kind regards,
Gift Peddie

Mike Green-427952 SSC Veteran Points: 296 More actions · Answer 4

SSCrazy, thanks.

I will have to get with the Network Group and have them make me a Domain Admin Account.