Dynamics Community Forum Thread Details

Import Organization with with Cluster alias failing with Access Denied

Hello experts,

I installed Dynamics 365 version 9.0.69 in our new environment and SQL is clustered with an Cluster alas. I can connect to this customer elias from SSMS but when I give the Cluster alas name in the Import organization or New organization, the Environment Diagnosis Wizard fails with the SQL Server Not available

The SQL Server 'clusterAliasName' is unavailable.

System.ComponentModel.Win32Exception (0x80004005): Access is denied
at Microsoft.Crm.Setup.Common.Utility.NetworkUtility.GetJoinDomainName(String server)
at Microsoft.Crm.Setup.Server.CrmSqlDomainValidator.InternalCheck(IDictionary parameters)

If I give one of the SQL Server names that workes fine.

Checked the following post

https://blogs.msdn.microsoft.com/darrenliu/2012/04/09/installing-crm-using-sql-server-dns-alias/

and given IgnoreChecks registry entry and tried but still, the EDW give me Access Denied Error.

May I know where else we need permissions to the deployment administrator account?

And what this - GetJoinDomainName(String server) function doing and where does it need access?

The account is in the Local Administrators group and Sysadmin on SQL Server and has SPNs setup.

version details

Dynamics 365 9.0.6.9

SQL Server 2017.

Regards,

Daniel.