Post reply

sql service startup account

  • June 12, 2013 at 12:18 pm

    #294472

    Hi Team,

    I have sql service account which does not have sa rights but have all required domain rights and there is seperate account for agent service and this account has sa rights.

    When backup job runs it does not delete the old backup files.

    When I grant sa rights to sql service account it does.

    So my question is does sql service account always need 'sa' rights?

  • June 12, 2013 at 1:28 pm

    #1623485

    I would suspect that the service account needs sysadmin rights in order to execute all the method/function calls inside SQL Server, but I can't find documentation on this page:

    http://msdn.microsoft.com/en-us/library/ms143504.aspx

    The only think I see is that it is grant sysadmin when it's installed.

  • June 18, 2013 at 3:27 am

    #1624922

    Thanks Steve

    I have granted sa rights and it worked. 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply