Database Reference
In-Depth Information
Next, we have to create a data source for the ServiceManager database in SQL Server
Reporting Services. Perform the following steps:
1. Open your web browser and navigate to http://[SCSMDWSQL]/Reports .
Replace [SCSMDWSQL] with the fully qualified domain name of the SQL server
that is used for reporting. If SQL Server Reporting Service is running as a named
instance, the syntax of the URL will be http://[SCSMDWSQL]/Re-
ports_[InstanceName] .
2. Click on the SystemCenter folder and then on the ServiceManager folder.
3. Click on New Data Source and complete the form as follows:
◦ Name: ServiceManager
◦ Data source type: Microsoft SQL Server
◦ Connection string: data source=[SCSMSQL];initial cata-
log=ServiceManager (replace [SCSMSQL] with the fully qualified
domain name of the SQL Server hosts the ServiceManager database)
4. Select Credentials stored securely in the report server
5. Enter the username and password of the SCSM Reporting Account
6. Select Use as Windows credentials when connecting to the data source
7. Click on Test Connection to validate the connection.
8. Click on OK to save the new data source, as shown in the following screenshot:
Search WWH ::




Custom Search