In this recipe, we will create an SSRS data source.
In this recipe, we will create a data source called Sample that is stored in the /Data Sources folder. This data source uses integrated authentication and points to the AdventureWorks2014 database.
Before we start, we will need to identify the typical information needed for a data source, which is shown in the following table:
|
Property |
Value |
|---|---|
|
Data source name |
|
|
Data source type |
|
|
Connection string |
|
|
Credentials |
|
|
Parent (that is, a folder where this data source will be placed; it must already exist) |
|
Note
Note that the /Data Sources folder is the default folder that gets created when you deploy reports to Report Server via SSDT.
These are the same pieces of information that you will find when you go to a data source's properties in your Report Manager:
