"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