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: