security error when report processing | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

security error when report processing

urgently looking for help. I created a new report using 2003.The shared data sources connection to server successful. I created a dataset to get the data from remote server using the shared data sources. I run the dataset and the result return on the result panel.Then i create the report layout. At last I preview the report, the error msg come out: An error has occur during report processing.
Can not create a connection to data sources ‘database name’.
Login fail for user ‘sa’. If the I connect to local server,it should no problem.
Thanks a lot if u able to provide help.

Are u using a MSDE ?! then you should set it for mixed mode authentication ,please have a look at followed link :<br /><br /<a target="_blank" href=></a> <br /><br /><br />or is their any password for ‘sa’ ?! <br /><br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br /><br />Regards<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
may help you