Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • JS
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs
  • MySQL

Embedded Data Source in SSRS

In SQL Server Reporting Services, Data Source is a connection setting that is used to connect with underlying Databases or Data Warehouses. In this article, we will show you, Steps involved in creating Embedded Data Source in SSRS, a practical example.

The SSRS Embedded data source is a combination of Provider name, Server instance Name, Database Name, and Database credentials. SQL Server Reporting Services supports two types of data sources: Shared Data Source and Embedded Data Sources.

SSRS Embedded Data Source: If you want to use the data source in single reports, then there is no point in creating a shared data source. In these situations, we create SSRS Embedded data Source

Creating Embedded Data Source in SSRS

After creating the New SQL Reporting Services project (SSRS project), the Report Data looks like below.

Embedded Data Source in SSRS 1

To create an Embedded data source in SSRS, Right-click on the Data Sources folder present in the Report data and select the Add Data Source option from the context menu

Embedded Data Source in SSRS 2

Once you click on that option, it will open the Data Source Properties window to configure the SSRS Data Source. Following are the properties inside the SSRS Embedded Data Source Properties window

  • Name: Please specify a valid unique name for the data source you want to create.
  • Type: Please select the connection type from the drop-down list. SSRS Data Source supports multiple connection types. For instance, if your data source is SQL Server, then select Microsoft SQL Server or OLE DB. If your data source is SQL Server Analysis Service, then select Microsoft SQL Server Analysis Services.
  • Connection Strings: If you know, How to write the connection string, then write down here. If not, click on the Edit button to specify the Data Source (Provider), Server Instance Name, Login credentials, and Database Name.
Embedded Data Source in SSRS 3

TIP: If you want to use the already created Shared data source then, Please select Use Shared data source reference radio button, and select the existing shared data source from the drop-down list.

Click on the Edit button from the above screenshot will open another window to configure the Connection Properties. Here we have to specify the Data Source (Provider), Server Name (or Instance Name), Login credentials, and Database Name.

Embedded Data Source in SSRS 4

In this SSRS Embedded Data Source example,

  • Data Source: We are retrieving data from SQL Server so, We selected the Microsoft SQL Server (SqlClient). You can change this option as per your requirement.
  • Server name: Please specify the SQL Server name. For now, we are using our local hostname.
  • Log on to the Server: Please specify, How you want to log into SQL Server. For now, we are using windows authentication.
Embedded Data Source in SSRS 5

From the above screenshot, you can observe that we are using selecting the [AdventureWorksDW2014] database from the list.

Click on the Test Connection button provided below to check whether the connection is successful or not.

Embedded Data Source in SSRS 6

Click Ok to finish configuring the SSSR Embedded Data Source connection properties.

Credentials Tab:

  • Use Windows Authentication: It will use the current user windows credentials to connect to the data source. For now, We are using this option
  • Use this User name and Password: Please specify the username and password to log into the data source. The report will use this username and password to connect to the data source
  • Prompt for credentials: When the report establishes a connection to a data source, it will prompt the given text (asking for credentials).
  • Do not use credentials: Report will not use any credentials to connect with the data source.
Embedded Data Source in SSRS 7

Click Ok to finish creating the Embedded Data Source in SSRS. Let us see in the Report Data tab

Embedded Data Source in SSRS 8

Filed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021· All Rights Reserved by Suresh.
About | Contact | Privacy Policy