Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 22nd, 2008, 09:49 AM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cannot create a connection to data source error

Hi,



I have setup SSRS with 3 data models using 3 different datasources on one server. I can create reports ok, but if any of the other users I want to access these reports tries to open the report I created or run there own reports (they can create a report), it gives them the error:



 Report Execution Error



Cannot create a connection to the data source 'datasource1'



I do not recieve this error, but the other users do. I have set the other users as System administrator in the site-wide permissions, so they have access to everything.



Everything is set to integrated windows authentication.



On the Reporting Server Configuration Manager, the Unattended Execution Account is not selected and is blank.



What could cause these users not to be able to run existing or new reports they create?



Thanks for any help,



Steve
 
Old April 22nd, 2008, 10:24 AM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Solved it, although not sure of the security implications...enabled anonymous access on the Reports directory within IIS




Similar Threads
Thread Thread Starter Forum Replies Last Post
Object Data Source error shoakat ASP.NET 2.0 Professional 1 June 20th, 2007 05:40 PM
Shared Data source Vs connection on report level mverma4you Reporting Services 0 June 6th, 2007 01:47 AM
Data source control for Create User zoltac007 BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 13 August 16th, 2006 02:34 PM
VBA Data Source error akalehzan Excel VBA 1 June 26th, 2006 01:30 PM
Cannot create a connection to data source dba123 Reporting Services 0 March 8th, 2006 04:46 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.