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:
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)
http://myreportingserver/Reports/Pages/DataSource.aspx?ItemPath=%2fData+Sources%2fOEL_UK
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.
then, for creating a new data source I go to the page below and press new data source
adding the relevant data.
Question
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