Creating an SSRS data source

In this recipe, we will create an SSRS data source.

Getting ready

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

Sample

Data source type

SQL

Connection string

Data Source=localhost;Initial Catalog=AdventureWorks2014

Credentials

Integrated

Parent (that is, a folder where this data source will be placed; it must already exist)

/Data Sources

Note

Note that the /Data Sources folder is the default ...

Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial