sql server service account permissions

Heisenberg 261 Reputation points
2022-11-08T01:17:32.31+00:00

hi folks,
i have a question, we are using a domain account to be used as sql service account. Does this account needs to have "interactive logon" permission at AD level?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,278 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,926 Reputation points
    2022-11-08T06:13:13.37+00:00

    Does this account needs to have "interactive logon" permission at AD level?

    SQL Server runs as a service, so the service account don't need to be allowed to interactive logon.
    See Configure Windows service accounts and permissions

    0 comments No comments

  2. Seeya Xi-MSFT 16,461 Reputation points
    2022-11-08T06:20:03.23+00:00

    Hi @Heisenberg ,

    Welcome to Microsoft Q&A!
    No. And you can refer to this article which introduce how to configure: http://sql-articles.com/articles/general/sql-server-service-accounts/

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments