From the course: SQL Server: Reporting Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a shared data source

Create a shared data source - SQL Server Tutorial

From the course: SQL Server: Reporting Services

Start my 1-month free trial

Create a shared data source

“

- [Narrator] Rather than embedding the data source connection information inside of each individual report, you can create shared data sources on the report server that reports can reference when it comes time for them to fetch data from a database. This makes management of the data sources easier since if a password changes or the location of the database moves you only need to update the single shared data source definition, rather than modifying every report that accesses the database. You'll create shared data sources from the web portal. Click on the new button and then come down and choose data source. This will open up a new data source page where you can fill in the connection details. I'll call mine Wide World Importers. Then I can give it a simple description. I want to make sure I'm enabling this data source. So, make sure that stays checked on and we'll scroll down, and find the connection details. This is the type of connection that we're going to be making to our data…

Contents