<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
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 3 of 3
««
«
1
2
3
The Reporting Services 3-Trick Pony
Rate Topic
Display Mode
Topic Options
Author
Message
Ramseier Andreas
Ramseier Andreas
Posted Thursday, October 25, 2007 3:47 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, January 07, 2008 11:26 PM
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
Post #414846
chenthor
chenthor
Posted Friday, December 14, 2007 1:34 PM
SSC Veteran
Group: General Forum Members
Last Login: Friday, May 10, 2013 8:22 AM
Points: 227,
Visits: 108
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!
Post #433582
« Prev Topic
|
Next Topic »
22 posts, Page 3 of 3
««
«
1
2
3
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
