
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.
Hi,
I believe the account needs to be a domain account, so it has permissions on the domain, all servers and be able to write whatever is needed.