moving reporting services databases

[jpotucek]

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
Server.

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?????

 

[jodonnell]

As you have moved your SRS system to a second server you may be hitting kerberos errors. Here is the link to the article

http://www.microsoft.com/downloads/...20-bd00-4759-8378-b38eefda7b99&DisplayLang=en

John O'Donnell, Microsoft CRM MVP, MCSE, MCSA
Microsoft Business Solution Certified Master – Microsoft Dynamics CRM
Crowe Chizek and Company LLC

http://www.crowechizek.com/microsoft