November 21, 2006 at 7:01 am
I have my Report Model deployed on Report Server. But in case i try adding my attributes to filter which are defined as drop down in report Model the values are not getting populated. I m getting the following error" A connection couldnot be made to datasource or the qUERY IS NOT VALID ". But the thing is query is running fine when i traced it from profiler.Just that its taking some time to return values. And thid problem is occuring only while populating filter values. Pls let me know if any one has incountered a similar issue.
Cheers
November 27, 2006 at 7:34 pm
I had a similar problem. After googling it seems that the problem is using windows integrated security, it seems the server doesn't know who the user is if the data source is on another box.
I suggest you create a SQL lonin and try then.
Martin
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply