web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

SQL server is unavailable error while trying to setup CRM 2016 with SQL AlwaysON

(1) ShareShare
ReportReport
Posted on by

Hi,

I am setting up CRM 2016 with SQL 2014 AlwaysON. Environment is setup on Azure VMs with Load Balance.

SQL 2014 AlwaysON with Azure Load Balance is confirmed working by testing with sqlcmd command from VM which is to install CRM.

However when CRM validate the setting for setup. It throws error 'the sql server is unavailable'. I put 'SQL Availability Group Listener Name' as SQL server

Detail error is 

The SQL Server <SQLAvailableGroupListnerName> is unavailable.

System.ComponentModel.Win32Exception (0x80004005): The network path was not found
at Microsoft.Crm.Setup.Common.Utility.NetworkUtility.GetJoinDomainName(String server)
at Microsoft.Crm.Setup.Server.CrmSqlDomainValidator.InternalCheck(IDictionary parameters)

In CRM Setup log, it shows as below

06:24:40|   Info| Exception thrown when checking SQLSERVERAGENT service: System.InvalidOperationException: Cannot open Service Control Manager on computer 'xxxxxxxx'. This operation might require other privileges. ---> System.ComponentModel.Win32Exception: The RPC server is unavailable

I can telnet with port 1433 to SQL server VM from CRM VM. No firewall is blocking.

Hope anyone can advise ...

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    14,065 on at

    This looks like it might be a permission issue - 0x80004005 is 'Access Denied', and the other message refers to privileges.

    I think the first message relates to when the setup program is checking the AD domain of the SQL Server, so it may be worth checking the permissions your setup account has in AD.

    The 2nd message relates to the setup program attempting to check if the SqlServerAgent service is running on SQL, which it does via the RPC service, rather than port 1433

  • Community Member Profile Picture
    on at

    Try the following steps :-

    Go to Microsoft Dynamics CRM web application.Click on Start and Run, type regedit in the Open box, click on OK.

    Locate the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

    Right-click on configdb, and click on Modify.

    In the Value data box, change the data source to the name of the new virtual SQL Server (or current SQL Server databases were moved to).

    The string value in the Value data box should resemble the following: Data Source=NewSQLServer;Initial Catalog=MSCRM_CONFIG;Integrated Security=SSPI

    start Deployment Manager on the computer, which is running the Microsoft Dynamics CRM Server web application.

    Expand the Deployment Manager node, and click on Organizations.

    Disable the organization,if not

    Ignore the warning

    In the list of organizations, right-click on the organization, and click on Edit.

    In the SQL Server box, type the virtual SQL Server name for the SQL Server cluster which is already created.

    (If not using a SQL Server cluster, just type the SQL Server name or SQL Server name and instance name here).

    click on Next, Apply and Finish

    Right-click on the organization to enable it.

    Don't fprget to reset the IIS services on the computer that is running IIS where the Microsoft Dynamics CRM Server web application is installed.

  • Community Member Profile Picture
    on at

    Hi you found any solution to this issue?

  • Community Member Profile Picture
    on at

    Enable File and Printer sharing (yes really).

  • Suggested answer
    nicoobianco Profile Picture
    on at

    THIS is the solution! Thank you so much!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans