Armanino Blog
Article

Dynamics CRM On-Premises "Pre-Login Handshake" Installation Error

May 05, 2015

Recently, we encountered a roadblock when doing a fresh install of Dynamics CRM On-Premises (2015). Everything looked good until the point when the installation process attempted to create the configuration database (MSCRM_CONFIG). The progress bar stopped, and after two minutes this error appeared:

System.Exception: Action Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction failed. —> System.Data.SqlClient.SqlException: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

Our first thought was to check the SQL timeout. It was already set to 10 minutes. Because this error occurred much sooner than that, we knew the issue must lay elsewhere. Perhaps the Windows firewall? We were not at liberty to completely disable it, so we carefully re-reviewed the list of necessary ports for CRM 2015 and cross-referenced them against the current firewall exceptions. One of these ports caught our eye:

On-Premises Screenshot

Clearly, the installation process was having difficulty accessing SQL Server to create the MSCRM_CONFIG database, so this made sense. Plus, it was not in the list of firewall exceptions! We created a new rule to allow inbound TCP traffic for Port 1433 and tried again. First, we had to uninstall because there were still traces remaining from the previous failed installation. Then we gave it another shot. SUCCESS!

Moral of the story: Make sure that all of the required ports are indeed open and available for CRM! Look for more troubleshooting and fixes for Dynamics CRM On-Premises in other Tales from the Trenches posts.

By Josh Briggs, Senior Consultant, Armanino's Dynamics CRM Practice

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
IPO Prep & SOX Compliance: Instacart & Armanino Share Hard-Earned Knowledge
Webinar
Know your compliance requirements today to avoid obstacles tomorrow.

December 16, 2021 | 11:00 AM - 12:00 PM PT
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Why COP26 Matters for Your Business Webinar
Webinar
Get informed of COP26 developments and how you can act now.

December 15, 2021 | 10:30 AM - 11:00 AM PT