Moving SQL Server Backend for CRM & Reporting Services

Last week, we moved the SQL Server backend for our CRM 3.0 site from the
Local machine SQL Server instance to a Named Instance on another Database
Server (SQL Server 2000 Standard) We moved the Databases AND the
associated Security Model (SQL Server Users and Groups), then used rsconfig
on the Source Server to repoint Reporting Services to the new Database

Everything seemed to be working fine. We don't have much data loaded into
CRM yet to report against (this is not quite in Production yet) so I need to
get this resolved before we start punping data into the site..

What is happening is when I go to http://CRMServer/Reports our Reporting
Services site loads up just fine but when I click on any of the reports, I
get this error::

Reporting Services Error --------------------------------------------------------------------------------

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
SQL Server does not exist or access denied.

I obviously missed something in moving the Databases and repointing the
Report Server. Maybe something in IIS????? Can anyone help or steer me in
the right Direction?????

9/12/2006 1:56:33 PM 4514 articles. 1 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 17
Get it on Google Play
Get it on Apple App Store