|
CAUSE
This problem occurs because Microsoft CRM uses the certificate that you created
for the server after you installed or upgraded the program. Microsoft CRM is
installed on this server. By default, the installer program uses the Web
address that is specified in this certificate. Microsoft CRM reports do not
work if you try to access Reports by using this Web address.
RESOLUTION
Warning Serious problems might occur if you modify the registry incorrectly by
using Registry Editor or by using another method. These problems might require
that you reinstall your operating system. Microsoft cannot guarantee that these
problems can be solved. Modify the registry at your own risk.
To resolve this problem, remove the Web address from the report configuration
files and from the registry. To do this, follow these steps.
Note This procedure uses the default file locations for
Microsoft SQL Server 2000. If you are using Microsoft SQL Server 2005, the
files may be in different locations
1.On the server on which SQL Server Reporting Services (SSRS)
is installed, modify the Rswebapplication.config file. To do this, follow these
steps.
Note You can verify the installation location of Reporting Services by using
Microsoft Internet Information Services (IIS) Manager. The Reports folder and
the ReportServer folder are listed under the default Web site.
a. Open the Rswebapplication.config file. By default, this
file is in the following location:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
b. In the file, locate the following section:
https://Servername.example_domain.10.com/ReportServer
Note In this step and in step c, Servername represents the actual server name,
and example_domain.10.com represents an actual domain name.
c. In the path that is mentioned in step b, change
https://Servername.example_domain.10.com to https://Servername.
d. Save and close the file.
2. Modify the Rsreportserver.config file. To do this, follow
these steps:
a. Open the Rsreportserver.config file.
Note By default, this file is in the following location:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\
b. In the file, locate the following section:
https://Servername.example_domain.10.com/ReportServer
Note In this step and in step c, Servername represents the actual server name,
and example_domain.10.com represents an actual domain name.
c. In the path that is mentioned in step b, change
https://Servername.example_domain.10.com to https://Servername.
d. Save and close the file.
3. Modify the registry for Reporting Services. To do this,
follow these steps:
a. Click Start, click Run, type Regedit, and then click OK.
b. In Registry Editor, click the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Reporting
Services
c. Click Reporting Services.
d. Right-click RSVirtualDir. Then click Modify.
e. Change the value that is in the Value data field from
https://Servername.example_domain.10.com/ReportServer to
https://Servername/ReportServer, and then click OK.
Note In this step, Servername represents the actual server name, and
example_domain.10.com represents an actual domain name.
f. Right-click WAVirtualDir. Then click Modify.
g. Change the value that is in the Value data field from
https://Servername.example_domain.10.com/Reports to https://Servername/Reports,
and then click OK.
Note In this step, Servername represents the actual server name, and
example_domain.10.com represents an actual domain name.
h. In Registry Editor, click the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
i. Click MSCRM.
j. Right-click SQLRSServerURL. Then click Modify.
k. Change the value that is in the Value data field from
https://Servername.example_domain.10.com/ReportServer to
https://Servername/ReportServer, and then click OK.
Note In this step, Servername represents the actual server name, and
example_domain.10.com represents an actual domain name.
l. On the File menu, click Exit.
4. Verify that you can access the SSRS Manager by using the
following Web address:
https://Servername/Reports
Notes
In this step, Servername represents the actual server name.
You may receive an error message if you access the SSRS Manager by using the
Web address and if you are using Microsoft SQL Server 2005. To resolve this
problem, follow the instructions in the following Microsoft Knowledge Base
article:
916163 (http://kbalertz.com/Feedback.aspx?kbNumber=916163/) You receive an
error message when you access Calendar or Reports in Microsoft CRM
5. Verify that you can view Microsoft CRM reports.
|