Service account for reporting services

Xiaowen Dong 100 Reputation points
2023-11-30T00:30:36.98+00:00

What is the difference between a built-in account and a domain account?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,867 questions
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2023-11-30T02:48:21.6433333+00:00

    Hi @Xiaowen Dong

    Virtual Service Account represents the Windows service. It is a built-in least-privilege account that has network log on permissions. This account is recommended if you don't have a domain user account available or if you want to avoid any service disruptions that might occur as a result of password expiration policies.

    Network Service is a built-in least-privilege account that has network log on permissions.

    If you have a Windows domain user account that has the minimum permissions required for report server operations, you should use it. A domain user account is recommended because it isolates the Report Server service from other applications.

    For more details, you can refer to this link: Choosing an Account.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments No comments

0 additional answers

Sort by: Most helpful