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 vs.net 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=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331</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
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21495110.html
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=53336
]]>