Advertisement

04.14.2008 at 09:39AM PDT, ID: 23320871
[x]
Attachment Details

How do I idenitfy required SQL Server Agent Service account permissions.

Asked by DADITWebGroup in MS SQL Server, Databases Miscellaneous

Tags: Microsoft, SQL, 2000

I need to idenitfy a list of "Sufficient Privileges" to my admin team to the SQL Server Agent Service account.  We created a new user group, however I am getting an error when I change the Agent account details: "Please provide an account with administrator privileges".  My admin tells me that this defeats the entire purpose of what we are trying to do with the policies on this account.  We want the minimal amount of privileges available to run all the jobs assigned the server.  Any ideas?  Start Free Trial
 
Keywords: How do I idenitfy required SQL Server …
Title
1 EMC CX-300 Agent Issue, can not…
2 Agent XPs disabled
3 Agent Push
4 SQL Server Agent started and then sto…
5 SQL server agent job not running
6 SQL Server Agent: SSIS
 
Loading Advertisement...
 
[+][-]04.15.2008 at 01:16AM PDT, ID: 21356836

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.15.2008 at 04:33AM PDT, ID: 21357652

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.15.2008 at 12:29PM PDT, ID: 21361981

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, Databases Miscellaneous
Tags: Microsoft, SQL, 2000
Sign Up Now!
Solution Provided By: jimpen
Participating Experts: 3
Solution Grade: B
 
 
[+][-]04.22.2008 at 05:21AM PDT, ID: 21410242

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628