Configure the Microsoft Reporting Services Samples

The following information guides you through the process of configuring Microsoft reporting services samples.

Procedure

  1. Open the applicable tool based on the version of SQL Server that you are working with.
    For this version...Open this tool...
    SQL Server 2012SQL Server Data Tools
    SQL Server 2008SQL Server Business Intelligence Development Studio
  2. Select File > Open > Project Solution.
    The Open Project dialog box appears.
  3. Navigate to the local folder where the sample report files were installed and select PlatformDMReports.rptproj.
  4. Click Open.
  5. Verify the content of the Microsoft SQL Server Reporting Services project.
    Note: For more information, see Microsoft Reporting Service Samples Files for a list of the sample report files.
  6. In the Shared Data Sources folder, double-click SOADM.rds.
    The Shared Data Source dialog box appears.
  7. Click Edit.
    The Connection Properties dialog box appears.
  8. Complete the following fields on the Connection Properties dialog box.
    1. In the Server name field, enter the server name of the Reporting Database server or leave the default name of localhost.
    2. Under Log on to the server, select the appropriate authentication method.
    3. In the Select or enter a database name field, under Connect to a database, set the connection to ReportDatamartDB.
  9. Click Test Connection.
    Note: If the connection is not successful, repeat steps 2-8.