How to share external user my SSRS reports(My data source is Azure DB)

Question

HI Team,
How to share external user my SSRS reports.

My Data source is Azure DB

please anybody share steps how share External user what permission i need to guve them

Thanks
Shanvitha

Answer 1

Hi @Shanvitha ,

In Reporting Services, if we want to access Reporting Services from other domain, we should apply domain trust or do extranet deployment. It will be considered as “same” domain to SSRS so that users from a trusted domain can access Reporting Services. And when the outer domain user access the current domain, they need to provide the credential.

Here is an official documentation about Extranet or Internet Deployment.

Follow the steps and then we could successfully put Reporting Services on an Internet-facing Web server to distribute general information to the public at large or private corporate data to authorized and authenticated users.

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms159272(v=sql.105)

Set different domain as trust domain and then grant the external user permission.
https://www.oreilly.com/library/view/active-directory-cookbook/0596004648/ch02s18.html
https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2003/cc775736(v=ws.10)?redirectedfrom=MSDN

Reporting Services provides an extensible architecture that allows you to plug in custom or forms-based authentication modules. The most common scenario for using custom authentication is to support Internet or extranet access to a Web application.

For more information, please refer to the article below:

https://learn.microsoft.com/en-us/sql/reporting-services/security/configure-custom-or-forms-authentication-on-the-report-server?redirectedfrom=MSDN&view=sql-server-ver15

Regards，

Zoe

---

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.