SQL Server 2005 Tidbit 029

Happy SQL Express User

Another tidbit?  It’s been awhile! 

FAR too long.  My apologies.

This tidbit is about a new flexible security feature in SQL Server 2005: SQL Server Agent Proxies.

In the past, if you wanted a job to have access to some secured subsystem, you had to basically give that job rights as the sa user, or some other account that you created specifically for all agent job steps.  So the job had all-or-nothing access.

In SQL 2005, the SQL Server agent has access to some subsystems that it didn’t have access to before, such as SQL Server Integration Services, and Analysis Services. 

But the big benefit in 2005 is that you can create or use Windows accounts or groups (but preferably accounts) that you specify, and then proxy those for the sake of agent jobs and those special protected tasks. 

Got an IT question?  Give me a comment, or contact me.