Configuration

Error - IP Address Mismatch

Log on to the server and open regedit and the CRM settings

Change the key value "IPAddressChecking" to be N

IIS needs to be reset for the change to take effect

---

If you install SQL Express the system will setup a default sa password as

 SageCRMv71

Ref: https://community.sagecrm.com/user_community/f/84/p/6017/22204.aspx#22204

---

To expose emailtemplates to CRM run the following update in SQL

 update Custom_Tables
   set Bord_Hidden=null
   where Bord_Name='EmailTemplates'

and then reload metadata (or restart IIS)

---

HTTP 403.14 Forbidden Error

This can happen in CRM with development of custom pages especially when changing from admin mode to Normal user mode

A work around to top this happening is to create a default page in the "CRM/custompages" folder

This page redirects the user to some location (our example goes to action 183.

 var newUrl=CRM.Url(183);
 Response.Redirect(newUrl);

Within IIS you have to add your file name as a default document at the custompages folder level

---

Ref: https://support.na.sage.com/selfservice/viewContent.do?externalId=39716&sliceId=1

Description

How to configure CRM 7.2 for IIS Auto Login Resolution

   Open the IIS Manager
   Click on the CRM site
   Click Basic Settings
   Set the Connect As setting to 'Application User (Pass-through Authentication)'
   Click on the CRM site
   Open the Authentication inteface
   Enable Anonymous and Windows Authentication
   Select Anonymous Authentication and click Edit
   Set the Anonymous Authentication to use the Application Pool Identity
   Open Internet Explorer and log in to CRM
   Setup all your user accounts so that the usernames matches the usernames Active Directory
   Click Administration, Users, User Configuration
   Click Change
   Set IIS Auto Login to Yes
   Set the Default Domain for IIS Auto Login to match your Windows Domain
   Open SQL Management Studio
   Click New Query
   use [CRM Databasename]
   go
   update users set user_password = NULL
   Do an IISReset
   Open Internet Explorer
   Go to Internet Options
   Add the CRM site to Trusted Sites
   Click the Custom Level option under Security
   Under User Authentication, set the option to 'Automatic Logon with Current Username and Password'
   Repeat step 19-23 on all workstations