locked
HOW do you assign these permissions to an account using group policy? RRS feed

  • Question

  • Hi,

    An active directory account needs the permissions below applying via group policy but they are NOT in the list of permissions under user rights assignment - so HOW do you assign these permissions below via Group Policy?

    These are not under user rights assignment:

    • Permission to start SQL Writer
    • Permission to read the Event Log service
    • Permission to read the Remote Procedure Call service


    • Edited by xyz2012 Monday, November 18, 2019 10:42 AM
    Monday, November 18, 2019 10:41 AM

All replies

  • Hi xyz2012,

    Thank you for posting in our forum.

    According to your description, there are no three strategies in xxx. I also checked the group policy. There is no specific policy in the group policy.
    My understanding, it may not be recommended to use Group Policy to configure, but to configure through SQL
    If my understanding is wrong, please let me know.


    reference:SQL Server Service Account Permissions and Security Policy Setup

    I hope this information can help you.

    Best Regards,

    Vicky


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Tuesday, November 19, 2019 9:45 AM
  • Hi,

    You can refer to the following link if you want set SQL service permission :

    Set permissions on a service


    Please don't forget to mark the correct answer, to help others who have the same issue. Thameur BOURBITA MCSE | MCSA My Blog : http://bourbitathameur.blogspot.fr/

    Wednesday, November 20, 2019 1:12 AM
  • HOW do you do the config of these permissions thru SQL?
    Thursday, November 21, 2019 1:58 PM
  • Hi xyz2012,

    Thank you for your update

    I recommend you try the method in the article.

    reference:HOW TO ASSIGN PARTICULAR PERMISSIONS TO SQL SERVER DATABASE USER FROM SQL SERVER MANAGEMENT STUDIO?

    I hope this information can help you.

    If there is anything else we can do for you, please feel free to post in the forum.

    Best Regards,

    Vicky


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, November 22, 2019 1:11 AM
  • Hi,

    Just want to confirm the current situations.

    Please feel free to let us know if you need further assistance.

    Best Regards,

    Vicky

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, November 25, 2019 1:15 AM
  • You need use gpmc.msc from the machine where the services reside. Once there, you can create your GPO and apply the needed permissions on the services.

    This posting is provided AS IS with no warranties or guarantees , and confers no rights.

    Ahmed MALEK

    My Website Link

    My Linkedin Profile

    My MVP Profile

    Monday, November 25, 2019 12:24 PM
  • Hi,

     

    Just checking in to see if the information provided was helpful. Please let us know if you would like further assistance.

     

    Best Regards,

    Vicky


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Wednesday, November 27, 2019 1:57 AM