Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services 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 March 8th, 2006, 04:46 PM
Authorized User
 
Join Date: Feb 2006
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cannot create a connection to data source

I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group! Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password. I thought that since this datasource was set to Windows Authentification that it would just pass it through?

I'm pulling my hair out at this point:

Screen Shots:

http://www.webfound.net/datasource_connection.jpg

http://www.webfound.net/datasource_connection2.jpg

http://www.webfound.net/datasource_connection3.jpg


Also As far as I know, I've given proper permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run

An error has occurred during report processing.
Cannot create a connection to data source 'my datasourcename'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors





Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot create a connection to data source error mojo1979 BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 April 22nd, 2008 10:24 AM
Shared Data source Vs connection on report level mverma4you Reporting Services 0 June 6th, 2007 01:47 AM
How to create reports based on TFS Source Control woojtii Visual Studio 2005 0 March 28th, 2007 04:16 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
how to create a socket connection? Janet Classic ASP Professional 0 December 30th, 2003 06:42 PM





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