0

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)

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.

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

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

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

1

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

1

Look into rs.exe (installed with SQL reporting services configuration). Is uses a vbscript syntax but it will allow you to do data source updates with command line/script.

https://msdn.microsoft.com/en-us/library/ms162839.aspx

Here is an example of the call to RS.EXE that you could put in a cmd or bat file. If there is only one instance of SSRS and it is in the default instance then exclude the "_instancename" from the URL.

rs -i c:\temp\SSRS_EnableRemoteErrors.rss -s http://reportservername/ReportServer_instancename

pause

Here is the script it calls, in this example the script will enable remote errors on the SSRS instance. There

Public Sub Main()
  Dim P As New [Property]()
  P.Name = "EnableRemoteErrors"
  P.Value = True
  Dim Properties(0) As [Property]
  Properties(0) = P
  Try
    rs.SetSystemProperties(Properties)
    Console.WriteLine("Remote errors enabled.")
  Catch SE As SoapException
    Console.WriteLine(SE.Detail.OuterXml)
  End Try
End Sub
  • this is very interesting. I would like to see more examples though. Do you know of any? – marcello miorelli Aug 25 '16 at 10:02
  • 1
    I updated my answer with code samples. – Jason Cumberland Aug 26 '16 at 17:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.