


Credentials that you enter in this dialog box are not stored on the report server and are not available for use by other users. These credentials are used to make a data connection from Report Builder to the external data source, or to preview a report that is configured to prompt for credentials. These credentials enable other users to run the report without providing credentials for the underlying data connection.ĭata source credentials that you enter in the Enter Data Source Credentials Dialog Box when you run a dataset query, refresh dataset fields, or preview the report. For some types of data sources, credentials can be stored securely on the report server. These credentials are used by the report server to make a data connection to the external data source. The report server administrator or SharePoint administrator specifies which type of credentials to use.ĭata source credentials that you enter in the Data Source Properties Dialog Box, Credentials (Report Builder) page for an embedded data source. In subsequent Report Builder sessions, saved credentials are used to connect to the same report server or SharePoint site. If you choose to save the credentials, they are stored securely with your user settings on your computer. The credentials that you enter are used until the Report Builder session ends. When you first save to, publish to, or browse to a report server or SharePoint site, you might need to enter your credentials. Report server credentials that you enter in the Reporting Services Login Dialog Box. The following list describes the types of credentials that you might need to provide, where they are stored, and how they are used: They are managed separately on the report server or on the local client. Credentials are not stored in the report. In Report Builder, credentials are often used when you connect to a report server or for data-related tasks, such as creating an embedded data source, running a dataset query, or previewing a report. When Credentials are Used in Report Builder For more information about how to specify a data source type and connection string, see Create data connection strings - Report Builder & SSRS. You can specify a static connection string or an expression that allows users to select a data source from a dynamic list. It can be managed separately after the report is published. The connection to an external data source is defined when you create the report. Information about authenticating users to a report server is provided in another topic.

Credentials are also used to authenticate users who access a report server.
