I am going to be publishing several reports over the next few months, that query the Operational Database instead of the Data warehouse. We will use these reports for getting all sorts of administrative information… which will allow us to get data without having to launch a SQL query analyzer window all the time.
First thing… we will need to create a new Data Source for the OpsDB.
Start, by opening a web page, and browsing to http://SRSServer/Reports where "SRSServer" is the name of your reporting server.
Click "New Data source"
1. For the Name – type "OpsDB" This will be the data source that I will be using for all my reports. If you want a different name, thats fine and dandy… you will just have to modify each report to link to your data source name. Not a big deal.
2. In the "Connections String" paste in the following: data source=DBSERVER;initial catalog=OperationsManager;Integrated Security=SSPI
DBSERVER is the name of the SQL server hosting your operational database. Initial Catalog is the name of your Operational Database.
3. Under "Connect Using" choose "Credentials are not required" Click OK.
Here is my example:
All done with the data source!
Now… we need a custom folder to place our custom reports. Click New Folder:
Give this folder a name. This name will appear to all reporting users in the OpsMgr console. I am calling mine "Custom – Reports"
Now – in the OpsMgr Console – we can see our new report folder:
When we publish or import new reports in the future, we can use this folder.