Database Reference
In-Depth Information
3. Double-click on the
SCOM Data Reader
login. Then, under
User Mapping
,
check the
OperationsManager
database and assign the
db_datareader
role
(you can leave the
public
role enabled).
4. Click on
OK
.
5. Next, we have to create a data source for the
OperationsManager
database
in SQL Server Reporting Services. The instance of SQL Server Reporting Ser-
vices discussed in this section is the same instance you used to create the Open
Incidents report. Open your web browser and navigate to
http://[SSRS]/
Reports
. Replace
[SSRS]
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://[SSRS]/Re-
ports_[InstanceName]
.
6. Navigate to the folder where you would like to create your shared data source. We
recommend that you use a separate folder for data sources. Use the same folder
you used when you created the data source for the
ServiceManager
database.
7. Click on
New Data Source
and complete the form as follows:
◦ Name:
OperationsManager
◦ Data source type:
Microsoft SQL Server
◦ Connection string:
data source=[SCOMSQL];initial cata-
log=OperationsManager
(replace
[SCOMSQL]
with the Fully Qu-
alified Domain Name of the SQL Server that hosts the
Operation-
sManager
database)
Now perform the following steps:
1. Select
Credentials stored securely in the report server
.
2. Enter the username and password of the SCOM Data Reader account.
3. Select
Use as Windows credentials when connecting to the data
source
.
8. Click on
Test Connection
to validate the connection.
9. Click on
OK
to save the new data source.
Once you have created the shared data source, follow these instructions to create the Act-
ive Alerts report:
1. Start Report Builder (using the Report Manager website or from a standalone in-
stallation).
2. Under
New Report
, select
Blank Report
.
