When you install Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008 and SQL Server 2008 Reporting Services all on the same server, you may receive the following error message:
This issue occurs when the path of Reporting Services does not exist on the server.
To work around this issue, create a Web site that runs on the same port and the same URL that the Reporting Services server is using. In SQL Server 2008 Reporting Services, IIS is not used for accessing reports. However, if Microsoft Dynamics CRM 4.0 is installed on the same server, Microsoft Dynamics CRM 4.0 must find a Web site that has the same URL to bypass the error. To verify the URL of Reporting Services, follow these steps:
- Click Start, click All Programs, click Microsoft SQL Server 2008, click Configuration Tools, and then click Reporting Services Configuration Manager.
- Click connect to connect to your report server instance.
- Click the Web service URL, and see what the report server Web service URL is. For example, the URL may be http://SQLServername:8181/ReportServer.
In Windows Server 2008, follow these steps:
- Click Start, click Run, and then type inetmgr.
- Expand the server name, right-click Sites, and then click Add Website.
- Enter a name for the site, and then select a physical path.
- Enter the port number of the report server Web service. For example, enter 8181.
- Click OK.
In Windows Server 2003, follow these steps:
- Click Start, click Run, and then type inetmgr.
- Expand the server name, right-click Web Sites, click New, and then click Web Site.
- Enter a description for the site, and then click Next.
- Enter the port number of the report server Web service. For example, enter 8181, and then click Next.
- Enter a path for the Web site, and then click Next.
- On the Permissions page, click Next.
- Click Finish.