Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Issue with Installation of Dynamics CRM 365 OnPremise on SQl Server Cluster

Posted on by 5

We are installing Dynamics CRM 365 on Premise on SQl server Cluster (with 2 nodes). During instlallation when we put Cluster name at the step of Database server location, at the end its not able to identify the cluster name and hits error with (SQl server not available and networkpath not found) and below is the screenshot, though able to connect with ODBC connection from the same Application server(CRM hosting server).

How do we solve this issue with installation on SQl server cluster?

pastedimage1682954716863v1.png

thanks

Kishore

  • RE: Issue with Installation of Dynamics CRM 365 OnPremise on SQl Server Cluster

    Hello, 

    generally it is not recommended to use the IgnoreChecks Registry Key as it may leave risks open that other warnings / errors are suppressed which may leave your CRM system in an corrupted / unstable state. 

    Dynamics CRM On Premise expects a SQL Server Name (Node) to be configured with. (SQL Server Name it is as not the Node Alias / Listener!)

    If everything is correct meaning you point to SQLServerName please ensure that the privileges are in place for your User Account which deploying CRM as well the CRM Service Accounts must receive the proper privileges (especially on the CRM Server and  SQL Servers) 

    When permissions are missing you also face such issues that specific values are unavailable. We speak about "minimum required privileges" Security considerations for Dynamics 365 Customer Engagement (on-premises) | Microsoft Learn

    The Cluster / High availability config is a post installation step described here: Post-installation and configuration guidelines for Dynamics 365 Customer Engagement (on-premises) | Microsoft Learn

  • Suggested answer
    Sayen Zhang Profile Picture
    Sayen Zhang on at
    RE: Issue with Installation of Dynamics CRM 365 OnPremise on SQl Server Cluster

    Hi Kishore,

    Please check the network connectivity issues between both servers (CRM & SQL).

    If there were no network problems, 1. added the IgnoreChecks subkey on CRM registry, to allow to proceed after verifying the issue on the system checks wizard:

    1)  In the registry, locate the following subkey: “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM”.

    2)  Right-click MSCRM, point to New, click DWORD Value, and then type IgnoreChecks. Double-click IgnoreChecks, and then type 1 in the Value data field.

    2. After while proceeding with the configuration we have faced the following error:

    Error message:
    microsoft.crm.setup.server.grantaspnetserviceaccountaccessaction failed the parameter is incorrect.

    It was solved by removing a unknown account from the AD’s OU.

    3. In the end the CRM was able to install although without creating an organization. It was providing the following error:

    11:05:40| Info| Attempting to copy database file:PathSource=C:\Program Files\Dynamics 365\LangPacks\1033\Xrm\sql\9,DbFileName=msxrm9.mdf,m_isBuildDb=False,m_sqlServerName=V-HO-CRMRDBU-01,DbFilesPath=D:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\,DBName=AAIBDev_MSCRM.mdf
    11:05:40| Info| CrmAction execution time; CreateDatabaseAction; 00:00:00.3269529
    11:05:40| Error| Installer Complete: OrganizationCreator - Error encountered
    11:05:41| Error| Exception occurred during Microsoft.Crm.Tools.Admin.OrganizationCreator: Error.ActionFailed Microsoft.Crm.Tools.Admin.CreateDatabaseAction
    InnerException:
    System.IO.IOException: The specified network name is no longer available.

    We fixed this issue by enabling SMBv2 on the database by performing the following command on Powershell with elevated permissions: Set-SmbServerConfiguration -EnableSMB2Protocol $true

    Best Regards,

    Sayen Zhang

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans