Database Reference
In-Depth Information
1. Launch the Report Builder application using the
Report Manager Website
op-
tion by navigating to
http://<ServerName>/Reports
(substitute the URL
with your specific environment values).
2. On the
Report Manager
home page, click on
New Data Source
to launch the
New Data Source
properties page, as shown in the following screenshot:
3. On the
New Data Source
page, type a name for the data source in the
Name:
field. Optionally, provide a description in the
Description
field. Select
Microsoft
SQL Server
for
Data source type
. Type the connection string information you
copied to notepad from the Creating an embedded Data Source section (step 7).
Select
Windows integrated security
and click on
Test Connection
, as shown in
the following screenshot:
4. Verify that the connection is a success and click on
OK
.
5. Optionally, click on the new data source to open its properties. Click on
Move
and select the data source folder you created in the
Creating Reporting organiza-
tional folders
section of the
Organizing the reporting environment
recipe.
6. Click on
Apply
to complete the move.
7. Close the Report Builder application from the previous task steps.