Answer: Shared Datasource

Hey ladies and gentlemen,
I am trying to create a shared data source and am getting the following error -

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Best_Data_Corp'. (rsErrorOpeningConnection)
Login failed for user 'XvTVTVTVXOP.

Background information:
- I have a sql server 2000 with sp3 on a windows 2003 server which is within a network.
- I have reportings services on a web server thats outside my network and configured through dmz so its accessible through the network and it can see within the network.
- I am using reporting services 2000...

Any one seen this error and what where your fixes if any. I have been working on this problem for about a week now...I have seen post with people with similar problems but no one has posted a resolution.

Thanks in advance...

Check if you have access to this datasource. When you added this ds as a shared datasource, did you 'test connection' ?|||Check that the views being used by your report have DBO ownerhips. VS 2005 has a habit of creating views with the developer as owner. Things then work fine on your development box but not when deployed.