Report displays fine in Visual Studio 2003 but we get this follwing error message when trying to access it from the /ReportServer or /Reports Web browser folders:
SQL Server Cannot create a connection to data source 'AdventureWorks2000'. (rsErrorOpeningConnection)
Has anyone encountered this and if so what is is the resolution?