Setting up SQL Auth for Azure SQL DB via SSRS

Question

Hello,

I am referring the below MSFT doc :

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-ver16

wherein confused with the below statement: 

SQL Database supports only SQL Server Authentication (user name and password) and users must provide credentials (login and password) every time they connect to SQL Database. 

Does this mean that when the report is published in SSRS server, we would have to share the username and password of the SQL account with all the users?

Answer 1

You can use a "Shared Datasource" with fix setup credentials for logon, then user don't need to enter them.

See

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/create-modify-and-delete-shared-data-sources-ssrs?view=sql-server-ver16

Answer 2

Hi @Rohit,

we would have to share the username and password of the SQL account with all the users

No, you needn't.

A report server uses credentials to connect to external data sources that provide content to reports or recipient information to a data-driven subscription. You can specify credentials that use Windows Authentication, database authentication, no authentication, or custom authentication. When sending a connection request over the network, the report server will either impersonate a user account or the unattended execution account. For more information about the security context under which a connection request is made, see Data Source Configuration and Network Connections further on in this topic.

Specify Credential and Connection Information for Report Data Sources

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.