Report Services can't connect to remote DB

I have 2 servers. The first with SBS 2003 and SQL 2005 (Workgroup edition).
The full install was done for SQL 2005 (all features). My report server DB's
are running on the SBS server. The second is a W2k3 R2 server with an app DB
running on SQL 2000.
I have created a report that extracts data from the remote SQL2000 DB. The
report runs fine through Business Intelligence. When I build and deploy
the report, the report can't connect to the DB. I get an error message "
Impossible to create a connection to the DB. This fonction is not supported
in this version of reporting services.(This is a translation since message is
in French).
I have tried using a Windows authentication connection and also with sa.
Do I really need to get SQL 2005 Standard Ed.?
--
Eric Simonneau
Hotel Logistics specialistFound the answer. SQL 2005 Workgroup edition will only permit connection to
the local machine. Remote queries are not permitted.
--
Eric Simonneau
Hotel Logistics specialist
"eric simonneau" wrote:
> I have 2 servers. The first with SBS 2003 and SQL 2005 (Workgroup edition).
> The full install was done for SQL 2005 (all features). My report server DB's
> are running on the SBS server. The second is a W2k3 R2 server with an app DB
> running on SQL 2000.
> I have created a report that extracts data from the remote SQL2000 DB. The
> report runs fine through Business Intelligence. When I build and deploy
> the report, the report can't connect to the DB. I get an error message "
> Impossible to create a connection to the DB. This fonction is not supported
> in this version of reporting services.(This is a translation since message is
> in French).
> I have tried using a Windows authentication connection and also with sa.
> Do I really need to get SQL 2005 Standard Ed.?
> --
> Eric Simonneau
> Hotel Logistics specialist