Data Source Credentials (Report Designer)
Use the Report Wizard Data Source Credentials dialog box to display and modify credentials for a data source in the report. The credentials that you provide will be used to access the data source and cache a copy of the data for report preview. For more information about how preview data is cached, see Previewing Reports. For more information about credentials, see Specifying Credential and Connection Information.
- Use Windows Authentication (Integrated Security)
Select this option to use Windows Authentication.
- Use a specific user name and password
Select this option to provide a specific user name and password. For shared data sources: when you publish the report server project to the target server, the user name and password are saved as the stored credentials for the database. If you want to use the user name and password as Windows credentials, you can edit the properties for the published shared data source on the target server. For more information, see How to: Create, Delete, or Modify a Shared Data Source (Report Manager).
- User name
Type a user name to log in to the data source.
Type a password to log in to the data source.
- Prompt for credentials
Select this option to prompt for credentials when the report is run.
- Prompt string
Type a prompt to indicate to the user to provide login credentials for the data source.
- No credentials
Select this option to provide no credentials for the data source. This option only works if the data source does not accept credentials or if you are passing credentials some other way. For more information, see Specifying Credential and Connection Information.