Requirements for a dedicated domain account to run jobs and SSIS packages in them

[RRinTetons]

I want to create a dedicated domain account to assign to the services for running jobs and SSIS packages in Configuration Manager. Can someone point me towards some guidance on what permissions and roles the account would need on the server machine, SQL Server overall and each database it accesses?

-
Richard Ray
DBA, Developer, Data Analyst
Jackson Hole Mountain Resort

 

[SQLScholar]

IF you mean you are using a proxy account - then it should just need whatever rights the package requires. Its not package specific.

If you are talking about the SQL Agent Service account then microsoft explain it quite well:

[URL unfurl="true"]http://msdn.microsoft.com/en-us/library/ms191543(v=sql.105).aspx[/url]

I would personally create an account to run the SQL agent service as this account requires it to be sysadmin.

Then create proxy accounts in SQL so that the account that the SQL agent job runs with can have reduced permissions.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[RRinTetons]

Thanks for the pointer on the security design information.

re your Dijkstra quote - One of my uncles (Donald H. Thurnau) was Dijkstra's host and driver while he was travelling around the US lecturing many years ago. My uncle always referred to Computing Science, not Computer Science, as he said that Dijkstra said that calling it Computer Science was like calling surgery Knife Science.

-
Richard Ray
DBA, Developer, Data Analyst
Jackson Hole Mountain Resort

 

[SQLScholar]

Very interesting on the Dijkstra quote.

Its very odd as he seems to always quote this a Computer Science.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------