Lesson 2: Specifying Connection Information (Reporting Services)

After you add a Reporting Services paginated report to your Tutorial project in Lesson 1, now you need to define a data source, which is the connection information the report uses to access data from either a relational database, multidimensional database, or another source.

In this lesson, you use the AdventureWorks2014 sample database as your data source. This tutorial assumes that this database is located in a default instance of SQL Server Database Engine installed on your local computer.

To set up a connection

  1. In the Report Data pane, click New and then click Data Source.
    If the Report Data pane is not visible, from the View menu, click Report Data.

    ssrs-table-tutorial-2-new-data-source

    1. In Name, type AdventureWorks2014.
  2. Make sure Embedded connection is selected.

  3. In Type, select Microsoft SQL Server.

  4. In Connection string, type the following:

    Data source=localhost; initial catalog=AdventureWorks2014  
    

    This connection string assumes that SQL Server Data Tools (SSDT), the report server, and the AdventureWorks2014 database are all installed on the local computer and that you have permission to log on to the AdventureWorks2014 database. If your AdventureWorks2014 database is not on the local computer, change the connection string and replace localhost with the name of your database server instance.

    Note

    If you are using SQL Server Express with Advanced Services or a named instance, the connection string must include instance information:

    Data source=localhost\SQLEXPRESS; initial catalog=AdventureWorks2014

    For more information about connection strings, see: Data Connections, Data Sources, and Connection Strings in Reporting Services.

  5. Click Credentials in the left pane and click Use Windows Authentication (integrated security).

  6. Click OK. The data source AdventureWorks2014 is added to the Report Data pane.
    ssrs_adventureworks_datasource

Next Task

You have successfully defined a connection to the AdventureWorks2014 sample database. Next, you will create the report. See Lesson 3: Defining a Dataset for the Table Report (Reporting Services).

See Also

Data Connections, Data Sources, and Connection Strings in Reporting Services