login failed for iser''null'' not associated with a tristed SQL Server connection

• hli99

  SSC Eights!

  Points: 827

  More actions

  June 14, 2006 at 9:11 am

  #118412

  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

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  June 14, 2006 at 3:35 pm

  #643811

  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. Selburg