The Reporting Services 3-Trick Pony

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rodney Landrum » The Reporting Services 3-Trick Pony

22 posts, Page 2 of 3

««1 2 3 »»

The Reporting Services 3-Trick Pony

Rate Topic

Display Mode

Topic Options

Author

Message

Ryan Austin

Posted Tuesday, October 23, 2007 4:32 PM

SSC 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

Rodney Landrum

Posted Tuesday, October 23, 2007 7:46 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:40 PM
Points: 29, Visits: 519

Try downloading the latest RDLs. There was an issue.
Rodney

Post #414141

Ryan Austin

Posted Tuesday, October 23, 2007 10:18 PM

SSC 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. Crazy

Post #414175

Ramseier Andreas

Posted Wednesday, October 24, 2007 12:04 AM

Forum 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

Ryan Austin

Posted Wednesday, October 24, 2007 12:17 PM

SSC 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

Rodney Landrum

Posted Wednesday, October 24, 2007 12:40 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:40 PM
Points: 29, Visits: 519

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

Ryan Austin

Posted Wednesday, October 24, 2007 12:43 PM

SSC 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

Ramseier Andreas

Posted Thursday, October 25, 2007 2:55 AM

Forum 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

VSVaidya

Posted Thursday, October 25, 2007 3:41 AM

SSCrazy

Group: Banned Members
Last Login: Today @ 3:36 AM
Points: 2,303, Visits: 301

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

VSVaidya

Posted Thursday, October 25, 2007 3:45 AM

SSCrazy

Group: Banned Members
Last Login: Today @ 3:36 AM
Points: 2,303, Visits: 301

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 »

22 posts, Page 2 of 3

««1 2 3 »»

Permissions