Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Reporting Services 3-Trick Pony


The Reporting Services 3-Trick Pony

Author
Message
Ryan Austin
Ryan Austin
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
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??
Rodney Landrum
Rodney Landrum
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 711
Try downloading the latest RDLs. There was an issue.
Rodney
Ryan Austin
Ryan Austin
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 81
I did try that and still getting the same problems. Crazy
Ramseier Andreas
Ramseier Andreas
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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
Ryan Austin
Ryan Austin
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
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.
Rodney Landrum
Rodney Landrum
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 711
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
Ryan Austin
Ryan Austin
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 81
OK that does make sense because I have the DBA_Rep on another server altogether from the SSRS instance.
Ramseier Andreas
Ramseier Andreas
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 90
Hi

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

Andy
Ramseier Andreas
Ramseier Andreas
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 90
Hi

Thank's for the link. Yes, on this site it says under "unsupported features" that
"Remote data sources are not supported"
So only local data sources are supported and i cannot connect to other servers

Andy
chenthor
chenthor
SSC Veteran
SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)SSC Veteran (229 reputation)

Group: General Forum Members
Points: 229 Visits: 142
I have tried to get this report to work to no avail, either. I downloaded what I believe to be the latest code, I am using SSRS2005 from within VS2005. I have set up the serverlist to only point to a remote dev box that I use all the time, but is sql2k, not 2k5.

"Cannot create a connection to data source "test"
An error has occurred while establishing a connection to the server. When connecting to Sql Server 2005 (which I am not), this failure may be caused by the fact that under the default settings sql server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to sql server)"
My serverlist and the static data source are on this dev box,and when I hit the exclamation point in the data tab, it brings back a server list result set, so I know I can connect to it.

When I hard code the data connection string, it works fine. it just doesnt like the dynamic part.

Also, what is the @loginname param used for? where is it set?

Thanks!



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search