Database Reference
In-Depth Information
How to do it...
The steps to complete this recipe are as follows.
Creating a dataset
The dataset is the result of a query to the data source (the DPM database in this example),
and in this case, it is created in the
Microsoft SQL Server Management Studio
(
MSSMS
) application. Perform the following steps:
1. Launch the MSSMS application and connect to the DPM SQL Server instance us-
ing the report user account (you must have created and delegated this account as
discussed in the previous recipe), as shown in this screenshot:
2. Expand
Databases
. Then expand
DPMDB_<DPMSERVERNAME>
(replace
<DPMSERVERNAME>
with your DPM server name).
3. Right-click on
Views
and select
New View…
, as shown in the following screen-
shot:
4. The
Add Table
dialog box is launched. Select the following views one at a time
with the
Add
button:
vw_DPM_Agents (dbo)
,
vw_DPM_ProtectedDataSource(dbo)
, and
vw_DPM_ProtectedGroup (dbo)
.