June 14, 2006 at 9:11 am
Hi all,
I got a problem connecting to our sql database. I am working on a very similar report that I have finished before - yes that one is working. I copied the rdl file to the new report solution under Reports folder. I then changed the parameter to only one instead of three in RDL file.
The stored procedure's name is also changed in RDL. I created a shared dataSource by getting it from existing item. But when I preview, I got 'login failed for iser'null' not associated with a tristed SQL Server connection' error message.
I have re-typed many times of the server name, userName, passWord, databaseName at the connection Tab under Tools->connect to database. It's even tested connection seccessfully.
What went wrong? I think maybe the parameter has something to do with it??
I'll really appreciate your help, thanks in advance
June 14, 2006 at 3:35 pm
This may be a stupid question, but do you have "Allow saving Password" selected?
______________________________________________________________________
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply