Setting up SQL Auth for Azure SQL DB via SSRS

Rohit 226 Reputation points
2024-06-10T08:28:06.8433333+00:00

Hello,

I am referring the below MSFT doc :

https://video2.skills-academy.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?

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,918 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,501 Reputation points
    2024-06-10T16:23:25.1933333+00:00

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

    See

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

    0 comments
  2. ZoeHui-MSFT 36,511 Reputation points
    2024-06-11T02:26:46.42+00:00

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.