O'Reilly logo

SQL Server 2012 with PowerShell V3 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 our 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 AdventureWorks2008R2 database.

Before we start, we will need to identify the typical information needed for a data source, including:

Property

Value

Data source name

Sample

Data source type

SQL

Connection string

Data Source=KERRIGAN;Initial Catalog=AdventureWorks2008R2

Credentials

Integrated

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

/Data Sources

These are the same pieces of information you can find when you go to a data source's properties ...

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