Reporting Services -- Connection issues

RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
a XP Pro.
Installation was no problem ... installed the AdventureWorks sample reports
(via a Command script).
Able to open http://<servername>/reports however when running the sample
reports the following message is received "An error has occurred during
report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'AdventureWorks'.
(rsErrorOpeningConnection)"
I have unsuccessfully reset the "Data Source Properties" several ways
(credential are not required and Use Win credentals with Impersonate, and
etc)
Additionally when creating a report with VS all the dataset queries run fine
... the report "Preview" returns the report and no error when doing a
"Build". However when "Deploying" this error message is returned " The
report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing."
Some sort of successful connection has to exist to return the Web page with
the sample reports listed and the successful "Preview'. So what's the
problem.
Could this be an issue because the SQL Server installation is a 'Named
Instance' .. If so is there a work around?
Thanks in advance
GeneH
I miss posted this question ... I have move it to sqlserver.reportingsvcs
thanks
"GeneH" wrote:

> RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
> a XP Pro.
> Installation was no problem ... installed the AdventureWorks sample reports
> (via a Command script).
> Able to open http://<servername>/reports however when running the sample
> reports the following message is received "An error has occurred during
> report processing. (rsProcessingAborted) Get Online Help
> Cannot create a connection to data source 'AdventureWorks'.
> (rsErrorOpeningConnection)"
> I have unsuccessfully reset the "Data Source Properties" several ways
> (credential are not required and Use Win credentals with Impersonate, and
> etc)
> Additionally when creating a report with VS all the dataset queries run fine
> ... the report "Preview" returns the report and no error when doing a
> "Build". However when "Deploying" this error message is returned " The
> report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing."
>
> Some sort of successful connection has to exist to return the Web page with
> the sample reports listed and the successful "Preview'. So what's the
> problem.
> Could this be an issue because the SQL Server installation is a 'Named
> Instance' .. If so is there a work around?
> --
> Thanks in advance
> GeneH
sql