November 29, 2007 at 7:27 am
I have written numerous ssrs reports, which have Parameters and have never failed to work, but everytime i create a report which has Parameters and then has one of those Parameters defaulted i start to get into problems when they are deployed.
the problem arises not on the first run of the report but after the initial run of the report when any user opts to alter one of the Parameters to something else it seems to do something then show the following "One or more data sources is missing credentials"
now if i click back in IE then the parameter is set as expected and then clicking view report is fine, but again if you then change a parameter the same happens "One or more data sources is missing credentials" gets shown.
Has anyone experienced this before and if so know why it is happening and how to correct it.. its becoming a right pain...
November 29, 2007 at 7:41 am
On the Datasource Properties, what are the settings for Connect using: ?
The error points to a Datasource Security issue not report parameter.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2007 at 7:50 am
i have looked into this but the report datasource is using a shared datasource which uses a specific username and password to authenticate, this user also has all the required access to anything it needs within the db being referenced.
If i remove the default all goes back to work fine and dandy and i can run the report then select whatever parameters without issue...
November 29, 2007 at 7:52 am
Oh i also didnt add the fact that in the development environment all is fine when defaulted or not defaulted
November 29, 2007 at 7:55 am
Sorry, you got me on this one.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply