Couple of things to look at:
1) Do you have an alias configured on your development box for the remote
database server but not one configured on the report server?
2) Back to 1, but do you use non-default tcp listener port?
3) If 1 (and subsequently 2) are a negative, can you TS into the report
server machine and resolve the IP of the database server?
4) Are you using integrated security for the database connection when you
design the report model? If so, try specifying a user for the data source
on the report server and see if this clears up the connectivity issue.
-Tim
[quoted text, click to view] "Roy" <Roy@discussions.microsoft.com> wrote in message
news:1C61DBB0-8C80-4639-968C-C669B80F1392@microsoft.com...
> Hi All,
> We have SQL Server 2005 Enterprise installed on Windows Server 2003.
> I created a data model from a remote server and deployed the model. When I
> browse to the folder and click Report Builder and create the report then
> click Run Report I get the following error:
> Report Execution Error
> The report might not be valid or the server could not process the data.
> The details are as follows:
> For more information about this error navigate to the report server on the
> local server machine, or enable remote errors
> ----------------------------
> Cannot create a connection to data source 'dataSource1'.
> ----------------------------
> An error has occurred during report processing.
>
> I really need help and will appreciate any and all help.
> Roy
>
