Share via

Is it more secure to install Reporting Service and SQL Server on different servers?

Jason Huang 21 Reputation points
2020-09-24T08:05:33.61+00:00

Hi,

For security sake, will it be safer to install the Reporting Service and SQL Server on different machine?
Thanks for help.

Jason

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,860 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2020-09-24T09:19:20.753+00:00

    Hi @Jason Huang ,
    Generally, I would say no. The security vulnerability is not quite relative with whether SQL Server or SSRS server are installed in one machine. SSRS has its own execution account and service account. The two server are in this perspective independent .

    BTW, if we install them on different server, for each server we would need one independent license.
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,926 Reputation points
    2020-09-24T09:20:17.083+00:00

    Regarding security I don't see any difference.
    Note, installing DB and SSRS on two different machine requires 2 server licenses.

    1 person found this answer helpful.
    0 comments