0

I am thinking of installing a Sql Server 2017 Express with Advanced Services. All data will be stored in the local instance as well as the Reporting Services. The question is if someone in another server could see that reports or only users logged in local server could see them. Thx in advance.

U. Busto
  • 141
  • 1
  • 8

1 Answers1

1

The short answer is yes users from another server could see the reports on that server.

This article shows how to configure SSRS SQL 2017. If you look at the article the screenshot for 'Web Service URL' you will see a 'Report Server Web Service URLs'. When you set up SSRS on the machine this is the URL you would give to users to access the SSRS portal. This is how they could access the SSRS portal.

Once you have set up and configured the SSRS portal you will need to set up the user accounts to grant access to the SSRS portal. Configure any firewall access. Set up data sources, deploy reports etc.

SQLBobScot
  • 111
  • 2