SSRS with Domain Accounts Credentials

Question

Hi,

Im currently using SSRS with domain account as credential in accessing SQL Server DB, what is currently happening is that every time a user is accessing a report, ssrs always ask for credentials before they can view the report.

My question is, is there a way where the domain user will only input their credentials once everyday and access assigned reports without re-inputting their credentials?

Answer 1

Hi @Patrick Laza ,

When we deployed the reports to the report server, we could manage the data source of the reports.

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 you configure a report data source connection to use prompted credentials, each user who access the report must enter a user name and password to retrieve the data. (Suppose that you are using this.)

When you use the Windows Integrated Security option, the report server passes the security token of the user accessing the report to the server hosting the external data source. In this case, the user is not prompted to type a user name or password.

More details you may refer:

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources?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.
Hot issues October