Home > SSRS Expert > Report Model Project – All About Data Source

Report Model Project – All About Data Source

When deploying a report model, setting up the data source is an important step.

In the report model project below, dsEAMPC is the data source I set up in BIDS. It uses Windows Integration Authentication to access the database.

image

On the report server, Windows Integration Authentication does not seem to work. Here is how I set up the data source that finally worked.

In BIDS, set up the project property as below. For the first time deployment, I will allow overwritting of the data source. After this, change the OverwriteDataSource to False.

image 

Then deploy the report model to the report server. The data source dsEAMPC will be automatically created on the Report Server under the folder EAM Data Source.

image

Go to the Report Server, and make the following changes to the data source:

In the Connection string textbox, remove Integrated Security=True, then select “Credentials stored securely in the report server”, and enter the appropriate user name and password. This credential is usually a batch login, created specifically for reporting.

image

Categories: SSRS Expert
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: