Database Reference
In-Depth Information
Getting ready
Before we can access the operational database, we need to grant read permissions to a user
account for reporting access to the data. We will use the SCSM Reporting service account
for this purpose. Perform the following steps:
1. Start SQL Server Management Studio and connect to the SQL server that hosts the
ServiceManager
database.
2. Expand
Security
and
Logins
, and check whether the SCSM Reporting Account is
present in the list of logins. If not, add the login.
3. Double-click on the SCSM Reporting Account login. Then, under
User Mapping
,
select the
ServiceManager
database and assign the
db_datareader
role (you
can leave the
public
role enabled).
4. Click on
OK
, as shown in the following screenshot: