The Reporting Services 3-Trick Pony

Question

The Reporting Services 3-Trick Pony

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Rodney Landrum SSCommitted Points: 1900 More actions · Answer 1

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 Old Hand Points: 373 More actions · Answer 2

OK that does make sense because I have the DBA_Rep on another server altogether from the SSRS instance.

Ramseier Andreas SSC Enthusiast Points: 192 More actions · Answer 3

Hi

Indeed Express Edition only supports local Datasource...

So this report doesn't run on Express Edition Report Service

Andy

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 4

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

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 5

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

Ramseier Andreas SSC Enthusiast Points: 192 More actions · Answer 6

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 Right there with Babe Points: 759 More actions · Answer 7

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!