O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required