Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

The Reporting Services 3-Trick Pony Expand / Collapse
Author
Message
Posted Tuesday, October 23, 2007 4:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 25, 2010 1:43 PM
Points: 39, Visits: 81
I'm still getting the "Cannot create a connection to data source 'test' " error message even though I have changed the DataSet2 to be a Stored Proc.

I've only added one server to the table for simplicity and still nothing, do I need to pass a service account for credentials or something??
Post #414124
Posted Tuesday, October 23, 2007 7:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:29 AM
Points: 32, Visits: 579
Try downloading the latest RDLs. There was an issue.
Rodney
Post #414141
Posted Tuesday, October 23, 2007 10:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 25, 2010 1:43 PM
Points: 39, Visits: 81
I did try that and still getting the same problems.
Post #414175
Posted Wednesday, October 24, 2007 12:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 07, 2008 11:26 PM
Points: 8, Visits: 90
Hi

The new version works fine within Visual Studio. But if i deploy it to my local report server (Expresion Edition). I had first this error:

"The 'ServerName' parameter is missing a value "

-> so i changed the default Paramter for ServerName from default "NULL" to
="localhost"

But now i have to following error when running the report outside from VS:

"An error has occurred during report processing.
Cannot create a connection to data source 'test'.
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services."

-> Maybe this reports don't run with express edition?
Regards
Any

Post #414212
Posted Wednesday, October 24, 2007 12:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 25, 2010 1:43 PM
Points: 39, Visits: 81
Well in my case, its not because its Express, it is the Standard install of SQL2005 with Reporting Services and the tests all work fine when previewing from Visual Studio, so I am a little stumped.
Post #414571
Posted Wednesday, October 24, 2007 12:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:29 AM
Points: 32, Visits: 579
It could be the local server connection in the DBA_Rep data source. You might need to change it to the server where the DBA_Rep database resides if it is not local to the SSRS server instance. Most likely it is working in design because that is where you have the DBA_Rep database.
Rodney
Post #414582
Posted Wednesday, October 24, 2007 12:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 25, 2010 1:43 PM
Points: 39, Visits: 81
OK that does make sense because I have the DBA_Rep on another server altogether from the SSRS instance.
Post #414584
Posted Thursday, October 25, 2007 2:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 07, 2008 11:26 PM
Points: 8, Visits: 90
Hi

Indeed Express Edition only supports local Datasource...
So this report doesn't run on Express Edition Report Service

Andy
Post #414830
Posted Thursday, October 25, 2007 3:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: Banned Members
Last Login: Wednesday, February 19, 2014 3:34 AM
Points: 2,559, Visits: 326
You have configured the Reporting services while installing the Sql Server Exp Edition. Please read the below mentioned link on more to do that.....

msdn2.microsoft.com/en-us/library/ms365166.aspx
Post #414844
Posted Thursday, October 25, 2007 3:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: Banned Members
Last Login: Wednesday, February 19, 2014 3:34 AM
Points: 2,559, Visits: 326
You have not configured the Reporting services while installing the Sql Server Exp Edition. Please read the below mentioned link on more to do that.....

msdn2.microsoft.com/en-us/library/ms365166.aspx
Post #414845
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse