* An error has occurred during report processing.

Created Report using SQL Server Business Intelligence 2005 using Visual studio 2005
MSSQL Server 2005
datasource is a filteredAppointment dbo from MS CRM 3
Shared Datasource
Report runs in visual studio 2005

deployed to ReportServer no errors
Report showing on home page in Report Server
Data source folder also on report server page

go to run report on the report server via internet explorer

getting following message

An error has occurred during report processing.

Cannot create a connection to data source 'FilteredAppointments'.

For more information about this error navigate to the report server on the local server machine, or enable remote errorsPlease can any one help!!!!!!

I am a novice to reporting services, can any one recommend a good basic to intermediate book.
have been on the Microsoft 2030A MSSQL server 2000 reporting services 4 months ago and not had a chance to use it until know

Thank you for all your time
ralph

Have you passed credentials to login in to datasource(database)..

May be it was using windows authentication previously.

Now to access it from IE you need to pass credentials to login to database.

You can store them on report manager also. even in vs2005 go to data view select (...) for data set than select (...) for dat source then go to credentials tab and set user name and password for that and re deploy that report.

|||

I have found the following book a good introduction/reference on SQL 2005 Reporting Services:

SQL Server 2005 Reporting Services Step-by-Step.

http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0735622507/ref=pd_bbs_1/105-2708315-8436407?ie=UTF8&s=books&qid=1189784803&sr=8-1

Gary.