Skip to content

lesson-2-specifying-connection-information-reporting-services.md

Latest commit

 

History

History
57 lines (40 loc) · 3.32 KB

lesson-2-specifying-connection-information-reporting-services.md

File metadata and controls

57 lines (40 loc) · 3.32 KB
title Lesson 2: Specifying Connection Information (Reporting Services) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology reporting-services-native
ms.topic conceptual
ms.assetid 54405a3a-d7fa-4d95-8963-9aa224e5901e
author maggiesMSFT
ms.author maggies
manager kfile

Lesson 2: Specifying Connection Information (Reporting Services)

After you add a report to the Tutorial project, you need to define a data source, which is connection information the report uses to access data from either a relational database, multidimensional database, or other resource.

In this lesson, you will use the [!INCLUDEssSampleDBobject] sample database as your data source. This tutorial assumes that this database is located in a default instance of [!INCLUDEssNoVersion] [!INCLUDEssDE] that is installed on your local computer.

To set up a connection

  1. In the Report Data pane, click New and then click Data Source....

    [!NOTE]
    If the Report Data pane is not visible, from the View menu, click Report Data.

  2. In Name, type [!INCLUDEssSampleDBUserInputNonLocal].

  3. Make sure Embedded connection is selected.

  4. In Type, select Microsoft SQL Server.

  5. In Connection string, type the following:

    Data source=localhost; initial catalog=AdventureWorks2012

    This connection string assumes that [!INCLUDEssBIDevStudioFull], the report server, and the [!INCLUDEssSampleDBobject] database are all installed on the local computer and that you have permission to log on to the [!INCLUDEssSampleDBobject] database.

    [!NOTE]
    If you are using [!INCLUDEssExpress] with Advanced Services or a named instance, the connection string must include instance information:

    Data source=localhost\SQLEXPRESS; initial catalog=AdventureWorks2012

    For more information about connection strings, see Data Connections, Data Sources, and Connection Strings in Reporting Services and Data Source Properties Dialog Box, General.

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

  7. [!INCLUDEclickOK] data source [!INCLUDEssSampleDBnormal] is added to the Report Data pane.

Next Task

You have successfully defined a connection to the [!INCLUDEssSampleDBobject] 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