Hi Steve,

After discussing with other SQL Engineers, they think that the problem is
likely due to the SSRS integration with SPS has something not configured
correctly. They'll suggest you try go through the steps for configuring
reporting service with MOSS/WSS, here I pasted the suggested steps from
them:

STEP 1:
-----------
Installing Reporting Services:
========================
We can install SQL 2005 Server with all the features or install just the
Reporting
Services. In order to get the integration feature in Reporting Services we
need to
install SP2 for Reporting Services.

Installing MOSS / WSS3.0 on Reporting Services SERVER1
==============================================
Install MOSS / WSS3.0 on SERVER1.

Installing SharePointRS Add-in:
=========================
Download the Add-in
<http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847
-B331-132274AE8C84&displaylang=en>

We need to install the Add-in on SERVER1

STEP2:
----------
Create New Web App on the MOSS / WSS3.0 server:
==========================================
We need to create Web App before we could configure any thing Further.

Configuring Reporting Services for SharePoint Integration:
==============================================
- Open ?onfigure Report Server?from the SERVER1.
- From ?eport Server Virtual Directory?Create a new Web Site for Report
Server with a Different Port.
- We can Skip the ?eport Manager Virtual Directory?
- From ?indows Service Identity?Use the SharePoint Services account to
configure the ?indows Service Identity?
- From ?eb Service Identity?created a new AppPool for the Report Server web
site. Make sure you use the SharePoint Services account.
- Next step is to create a Reports Database on the Database Server. While
creating a New Reports Database make sure you create it with ?harePoint
Integrated?Mode.
- Once all these steps are complete the ?harePoint Integration?shows up
with tick next to saying that the integration is configured with SharePoint.

Now to confirm the configuration browse to the reports server web site
which you created Ex : <http://SERVER1:8080/ReportsServer>
You now should be able to browse to the report server and it should display
the web app which we created earlier.

Configure SharePoint Central Administrator Site for Reporting Services:
========================================================
- From the Application management -> Reporting Services -> Click on ?anage
Integration Settings?
- Type in the report server URL and Select Windows Authentication. Click
OK- Now select the ?rant Database Access?and then type in the Reporting
Services Server name and then click OK. Then it would prompt for User name
and password. Specify the user account. This account I used to retrieve the
Reporting services from the SERVER1. I would use the SharePoint Services
account since I have using a sigle account for integrating.
- Click on the ?et Server Defaults?you should see the defaults value for
the Reporting Services.

Configure the SQL Reporting Services Web Part on the Portal:
=================================================
Now we can add the SQL Reporting Services Web and you should be able to get
it working fine.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.com.

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------