Database Reference
In-Depth Information
How to do it...
In this recipe, we will create a data source for an SCCM database. The recipe will demon-
strate how to create an embedded data source and a shared data source.
Creating an embedded data source
Follow these steps to create an embedded data source:
1. Launch the Report Builder application using the
Report Manager Website
option
by navigating to
http://<ServerName>/Reports
(substitute the URL with
your specific environment values) and then click on
Report Builder
.
2. Close the
Getting Started
page. Ensure that the
Home
tab is selected. Under
Re-
port Data
, click on
New
and select
Data Source…
, as shown in the following
screenshot:
3. On the
General
tab, type a name for the data source in the
Name:
field. Select
Use
a connection embedded in my report
and ensure that
Microsoft SQL Server
is
selected as the connection type, as shown in the following screenshot:
4. Under
Connection String:
, click on
Build…
. Type the data source server name
(for this example, the SCCM server is named
SEUKSCCM01
) and accept the
Use
Windows Authentication
to log on to the server.