Monday, July 5, 2010

Creating Shared Data Source in SSRS 2008

In this post, I'll explain how to create a Shared Data Source in SSRS 2008 with an example.

We need Data Source while developing reports in Report Designer and Report Builder tools. For this example, I will be using SQL Server Business Intelligence Development Studio 2008.

To begin, I'll create a new Report Server Project.

Create Report Server Project

1. Open BIDS: Click on Start --> All Programs --> SQL Server 2008 --> SQL Server Business Intelligence Development Studio as shown below:


2. From the menu bar, select File --> New --> Project...

3. Select Report Server Project template from New Project wizard as shown below:
4. Click OK to complete the wizard.

Create Shared Data Source
Follow below steps to create a shared data source:
1. In the Solution Explorer pane, right click on Shared Data Sources folder --> click on Add New Data Source. This will open Shared Data Source Properties dialog.
2. Enter Data Source name in Name textbox (in our example its dsTestHN) and Type as Microsoft SQL Server. Click on Edit button to set connection string.


3. Enter Server name and Database name from dropdown boxes. Finally click on Test Connection to check the connection, You should receive Test connection succeeded message.

4. Click OK to complete and save changes. Now you can see dsTestHN data source in Solution Explorer pane as shown below:
That's all! We have successfully created a Shared Data Source.

Click here to understand about Data Sources Supported by Reporting Services.

2 comments:

  1. Hey !

    We have done that. And now is the question: can we reuse a shared Data source between projects, and people? and if yes - how? The only method I found, is through the WEB UI, going to the properties of an existing report--> Data Source --> browse...
    Is there a way to define it in the Visual Studio SSRS itself?

    ReplyDelete
  2. Hi Greenozaur,

    Take a look at this article: http://msdn.microsoft.com/en-us/library/cc671619.aspx. It is for 2005, but I think that it still applies.

    My personal opinion...use indirect configurations for your data sources: http://msdn.microsoft.com/en-us/library/cc671625.aspx

    ReplyDelete

Note: Only a member of this blog may post a comment.