Jeffrey Williams-493691 (8/7/2011)
Gift Peddie (8/7/2011)
The only time you need to have the agent service account as part of the local administrators group is IF YOU REQUIRE the autostart functionality to be enabled. In almost all cases, that additional funtionality is neither required or needed.
The ACL was an error but I would rather you explain how autostart is not needed in automation operation processing gigs of data in almost real time.
What do you think the autostart functionality provides for? It has nothing to do with automation processing gigs of data in almost real time.
Again, if YOUR system needs that functionality - then, yes the agent service account must be a local administrator. However, that is not a normal configuration and is not something that is required is most instances.
So, again - what is it that you believe that functionality provides that is essential for normal SQL Server Agent operation?
What is normal in a place where users query data and what is normal when many different pieces work together for user experience outside the company Domain are not related, I am talking about the later and you are talking about the former. The later saves the cost of Informatica and DataStage while the former just keeps the business running both are not related.
And as to the previous posters comment about integrated security with Oracle and DB2, there is no integrated security in web use because it does not scale beyond company intranet use. You notice I didnot add Winform because as of .NET 3.5 the client services can pipe both permissions through the web.config with few lines of code.
Kind regards,
Gift Peddie