Sql-server – how to add a data source to SSRS – reporting services 2014

reportingsql serversql server 2014ssrsssrs-2014

For infomation as Create, Modify, and Delete Shared Data Sources (SSRS)
but I want to get this done quickly, so when I have been requested to add a new data source to our reporting services:

enter image description here

This is the way I am currently doing it:
I look for another data source that I already have – (example only – the real server name has been modified)


there I have already another data source working fine,
I get the information like the connection string,
and the credentials (user name of the account running the report) and modify accordingly for my new data source.

enter image description here

then, for creating a new data source I go to the page below and press new data source adding the relevant data.

enter image description here


Isn't there another simpler way of creating a data sources?

I was thinking something like from the ReportingServices database there must be some table with the datasource records, and all the information.
Just copying that info into another record, doing the appropriate changes – and I will have my new data source.

This question shows how to find data sources in the reporting services database

How can I tell which data sources are being used in SSRS?

Best Answer

With Visual Studio with SSDT-BI installed you can create new shared DataSources or copy/paste them. https://msdn.microsoft.com/en-us/library/ms155845(v=sql.120).aspx