How To Create A Shared Data Source In SSRS 2016

by Santhakumar Munuswamy

  Posted on  05 March 2017

  SSRS


 

In this blog, we will discuss how to create a shared Datasource in SQL Server Reporting Services 2016. Shared data source is a collection of the data sources that can be used in multiple reports, report models, and subscriptions etc. We can create shared date source and run on the Reporting Service into Report Server.

Prerequisite

We should have some basic knowledge of SQL Server Query and Visual Studio Tool for creating an SSRS Report using Visual Studio 2015.

  • SQL Server Basic Query
  • Visual Studio 2015

How to create a shared Datasource using Wizard

After creating an SSRS Project successfully, go to "Shared Data Source" folder, right-click on it, and point to Add New Data Source and click the Add New Data Source.


The Shared Data Source window will open. Click the "Edit" button.


The "Connection Properties" window will open. Type Server name, select Authentication, Username, Password, Select or Enter a database name, and finally, you can check the database connection success, followed by clicking the "Test Connection" button. Then, click the OK button.


The Shared Data Source window will open. Select the new data source, connection string, and click the OK button.


After creating new data source file, you can see the shared data source folder structure, as shown in the below screenshot


Thank you for reading my blog !!

 


About the Author
Santhakumar Munuswamy is a seasoned Solution Architect and Most Valuable Professional in Cloud /AI solutions. He has been experienced around 14 years in Solution designing, Software Product Development, Technical Documentation, Project Management for Web and Cloud Applications. He has experience in the IT industry across different domains (Automotive, Telecommunications, Healthcare, Logistics & Warehouse Automation, etc.) with roles in Technical Architect, Genesys Consultant, Technical Lead, Team Lead, and Developer. He has experienced in mentorship and coaching high potential developers.

Follow Me: Facebook, Twitter, Google Plus, LinkedIn
blog comments powered by Disqus


Month List

Community Badges