In this article we will show you, How to create 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. For instance, if your data source is SQL Server then select Microsoft SQL Server or OLE DB. If your data source is SQL Server Analysis Service then select Microsoft SQL Server Analysis Services.
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 data source, it will prompt the given text (Type or enter a user name 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 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 user name and password to log into 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 external server for 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 data source. For instance, If we are accessing file in local file system then we can select this option. However, try to avoid this option.
Once we finished configuring the Data Source, Click on 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