CRM SBE on SBS 2003 SP1 Resolution

The problems with installing CRM 3.0 Small Business Edition on SBS 2003 with SP1 have been identified around ISA 2004 and the SP1 change to prevent reflection attacks on the server. Microsoft have made available instructions which Ihave copied below. A KnowledgeBase article is being prepared and I suspect this will find its way into the Readme available from the Microsoft downloads page.

Issue
The following error appears in the Microsoft CRM V3.0 Environment Diagnostic Wizard:
 
“The Web site for installing SQL Reporting Services was not found.  Setup requires the presence of the Web site configured to run at port 80 with an empty Host Header.”

Cause

There are multiple identities that exist on the Default Web site.  This can be the result of installing Microsoft ISA Server on the Windows Small Business Server 2003 computer. 

Resolution
Complete the following steps on the Windows Small Business Server 2003 computer:
 
1. Click Start, point to Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. Expand the <server name> node and then expand the Web Sites node.
3. Right-click on the Default Web site and select Properties.
4. Click the Advanced button on the Web Site tab.
5. Select the Identity with 127.0.0.1 as the IP address and then click Remove. 
6. Select the SSL identity with 127.0.0.1 as the IP address and then click Remove.  There should be one identity and one SSL identity remaining.
7. Click OK on the Advanced Web Site Configuration dialog box and then click OK on the Default Web site’s Properties dialog box.
Note:  If you encounter the error in the V3.0 Environment Diagnostic Wizard before completing these steps, you must close the installation wizard and restart the install.
8. Complete the steps in the following Microsoft Knowledge Base article:
 
http://support.microsoft.com/default.aspx?scid=kb;en-us;896861

9. After setup installs Microsoft CRM successfully you can add back the loopback identities to the Default Web site by completing the following steps:
a. Follow steps 1-4 to open the Advanced Web Site Identification dialog box on the Default Web site.
b. Click the Add button under the Multiple identities for this Web site area.
c. Enter 127.0.0.1 for the IP address and 80 for the TCP port and then click OK.
d. Click the Add button under the Multiple SSL identities for this Web site area.
e. Enter 127.0.0.1 for the IP address and 443 for the TCP port and then click OK.
f. Click OK on the Advanced Web Site Configuration dialog box and then click OK on the Default Web site’s Properties dialog box.

More Information:

The following error may appear if the installation of ISA Server creates a certificate on the Default Web site named publishing.<your domain>.<your domain suffix>:

“Activating SQL Server Reporting Services failed.  Setup failed to validate specified Reporting Services Report Server https://publishing.<your domain>.<your domain suffix>/ReportServer.
Error:  The request failed with HTTP status 401: Unauthorized”

Windows Server 2003 SP1 includes a loopback check security feature that is designed to help prevent reflection attacks on your computer.  The 401 error occurs because the name of the certificate does not match the name of the local computer.  For example:  The name of the Windows Small Business Server 2003 computer might be named MySBSServer.domain.local.  The certificate created on the Default Web site during the installation of Microsoft ISA Server will be named publishing.domail.local.  Following the Knowledge Base article in step 8 will resolve this issue.

 

Advertisements

About Julian Sharp

I have worked with Dynamics CRM since 2004 and have been involved in over 100 CRM projects. I am a Dynamics MCT and teach Dynamics 365 and Azure in the UK and across Europe
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.