SQL Server Performance

security error when report processing

Discussion in 'SQL Server Reporting Services' started by tboonleong, Aug 8, 2005.

  1. tboonleong Member

    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.
  2. ghemant Moderator

    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 />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  3. dineshasanka Moderator

Share This Page