Tuesday, July 01, 2008

SSRS Cannot create a connection to data source 'dataSource1' Report builder



Symptoms:


In report builder getting Error message when trying to run a report :



Login for user XXX failed Cannot create a connection to data source 'dataSource1'





















Solution:

This error is caused by the executing user account (in the SSRS) not having permissions to run the report.

The datasource1 is an internal datasource so don't bother looking for it.

To sort out the problem:

1. Open Report Manager (http:\\localhost\reports)
2. Navigate to Home > Data Sources
3. Make sure Connection string is using Integrated Security=True
4. Select Credentials stored securely in the report server
5. Fill in the Username and password with an admin account on the machine that hosts SSRS
6. Tick Use as Windows credentials when connecting to the data source (to keep your user accounts setup like user folder premisions) working OR just Select credentials are not required

Make sure you unselect Windows integrated security if you are using a windows account that is not an administrator to connect to SSRS server


























































7. Click apply








4 comments:

Anonymous said...

Thanks a lot for your useful step-by-step !!!

Drikus said...

The mentioned solution is not the greatest one. Access to the data source is a SQL Server function and the user needs access to it via the database server. Putting the user in question into the group [SQLServer2005ReportServerUser$(Server Name)$SQLEXPRESS] provides access to Reports and then STEP 2: Add the user to the group [SQLServer2005MSSQLUser$(Server Name)$SQLEXPRESS] should solve the problem.

This does not compromise your active directory authentication and you don't have to store local credentials and start impersonating etc.

jagan said...

super solution... it really worked

Anonymous said...

hi! [url=http://esnips.com/web/minnaregina/]Hello. And Bye.
[/url] http://esnips.com/web/minnaregina/ free nude video clips of milfs
thanks!
free nude video clips of milfs