SSRS with Domain Accounts Credentials

Patrick Laza 1 Reputation point
2021-02-10T03:32:49.917+00:00

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?

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,853 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,591 Reputation points
    2021-02-10T05:53:46.31+00:00

    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.

    66177-screenshot-2021-02-10-135156.jpg

    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