In this article, we will show you, How to create Shared Data Source in SSRS Report Manager.
Creating Shared Data Source in SSRS Report Manager
To do this, Please open your report manager and click on the New Data Source button as shown in below screenshot
Once you click on the New Data Source button, below screenshot will be displayed. Please refer SSRS Shared Data Source article to understand the below properties:
Below screenshot will show you the Data Source Types supported by the Report Manager.
Connection Properties: Here we have to specify the Data Source (Provider), Server Name (or Instance Name), Login credentials and Database Name.
Connect Using: Here we have to mention the Credentials required to connect the Reports with selected Database
- Credentials supplied by the user running the report: When the report is connecting to the data source, it will prompt the given text (Type or enter a username and password to access the data source). If you check mark, Use as Windows credentials when connecting to the data source option then reporting server will pass the current user windows credentials to the external server instead of prompting otherwise, it will prompt for credentials.
- Credentials stored securely in the report server: If you select this option, Please specify the username and password to log into the data source and these credentials will be stored inside the report. This option is very important for Report Subscriptions.
- Windows Integrated Security: It will pass the current user windows credentials to an external server to connect to the data source. For now, We are using this option
- Credentials are not required: Report will not use any credentials to connect with the data source. For instance, If we are accessing a file in the local file system then we can select this option. However, try to avoid this option.
Once we finished configuring the Data Source, Click on the Test Connection button to check whether the connection is valid or not.
Click Ok to finish creating Shared data Source in Report Manager. Now, Please navigate to Data Source Folder and check for the newly created data source
Thank You for Visiting Our Blog