During the installation we got an error message for the Reporting Services.

Microsoft CRM 3.0 Server Setup
Activating SQL Server Reporting Services failed.
The underlying connection was closed: Unable to connect to the reemote
server. https://xxx/ReportServer

Except for that the installation went on but now the system is extremely
slow. To open the contacts in Outlook or via the web interface takes
minutes...

How can I fix the installation? I guess I need to re-install the reporting
services and connect CRM to the reporting service. How do I do that?

We are using Windows SBS and upgraded from CRM 1.2 to 3.0. Everything is
installed at one server (yes I know...).

There are couple of ways to fix this issues.

Uninstall CRM, installing standalone reporting service, installing CRM
server again with connecting to existing reporting service is most reliable
approach.

You could also fix it without uninstall CRM server first. You can install
standalone reporting service, and then use publishreports.exe under Program
Files\Microsoft CRM\Reports folder. You need to supply all the optional
parameters, and please make sure to provide the AD group guid correctly.
Putting the wrong AD could confuse CRM, and your reports won't work.

So the first choice is a more reliable choice.

Also, if you see "Activating SQL Server Reporting Services failed" during
nested install of reporting service, you will likely to see it again during
standalone installations. There are several KB articles around this error
message for reporting service. You may want to dig in to find out the cause
of the failure.

Min Fan
SDE Lead
Microsoft Dynamics CRM

--
This posting is provided "AS IS" with no warranties, and confers no rights.


"FC" wrote: