Shared Data Source Window will open and click Edit button.
Connection Properties Window will open, type the Server name, select the Authentication, user name, password, select or enter a database name and finally, you can check the database connection succeed, followed by clicking the Test Connection button. Now, click OK button.
Shared Data Source Window will open. Select the new data source, connection string and click OK button.
After creating a new data source file, you can see Shared Data Source folder structure, as shown below.
How to modify Shared Data Source
Go to Shared Data Source folder, click the ProductDataSource.rds data source name. Now, Shared Data Source Window will open, as shown below.
Now, you can change the name, type, connection string and data source credentials.
How to delete Shared Data Source
Go to Shared Data Source folder, right-click the ProductDataSource.rds and point to Delete context menu item, followed by clicking delete the item.
Microsoft Visual Studio Window will open and prompt delete confirmation option. Click OK button to delete the data source file, else click Cancel button to cancel the delete process, as shown below.
After deleting the ProductDataSource.rds file, you can see Shared Data Source folder structure, as shown below.
You can also read this article at my blog
here
Conclusion
I hope you understood how we can create a Shared Data Source in SQL Server Reporting Services 2016, how to create a Shared Data Source, using Report wizard, how to create a Shared Data Source without using the Report wizard, how to modify Shared Data Source and how to delete Shared Data Sources. I have covered all the required things. If you find anything which I missed in this article, please let me know. Please share your valuable feedback or comments and suggestions to improve the future articles.