Sooo, I've got this SQL Server 2000 server and the SQL Server agent currently runs as the default local account (NT AUTHORITY\System) which has been fine and dandy up until now, but I need to be able to have the agent do stuff over our domain.
From an AD point of view I'm happy about what I need to do, but I wanted to sound out opinion regarding the level of access that the agent account should be granted. Currently it's "everything", but I was wondering what other people are doing especially if it's something a bit more involved than making the account a server administrator and local os administrator.
From an AD point of view I'm happy about what I need to do, but I wanted to sound out opinion regarding the level of access that the agent account should be granted. Currently it's "everything", but I was wondering what other people are doing especially if it's something a bit more involved than making the account a server administrator and local os administrator.
