When you install Microsoft Dynamic CRM with SQL Server you may come across this error
The SQL Server ‘SQLServerUsedforCRM’ 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)
On the CRM server unblock these ports 80,135,136,139,443,445,123,137,138,445,1025
On the SQL Server unblock these ports 80,135,139,445,1433,123,137,138,445,1025
Network ports for the Microsoft Dynamics CRM Web application
The following table lists the ports used for a server that is running a Full Server installation of Microsoft Dynamics CRM. Moreover, except for the Microsoft SQL Server role, and the Microsoft Dynamics CRM Connector for SQL Server Reporting Services server role, all server roles are installed on the same computer.
Protocol | Port | Description | Explanation |
TCP | 80 | HTTP | Default Web application port. This port may be different as it can be changed during Microsoft Dynamics CRM Server Setup. For new Web sites, the default port number is 5555. |
TCP | 135 | MSRPC | RPC endpoint resolution. |
TCP | 139 | NETBIOS-SSN | NETBIOS session service. |
TCP | 443 | HTTPS | Default secure HTTP port. The port number may differ from the default port. This secure network transport must be manually configured. Although this port is not required to run Microsoft Dynamics CRM, we strongly recommend it. For information about how to configure HTTPS for Microsoft Dynamics CRM, see “Make Microsoft Dynamics CRM 4.0 client-to-server network communications more secure” in the Microsoft Dynamics CRM Installing GuideMake Microsoft Dynamics CRM client-to-server network communications more secure . |
TCP | 445 | Microsoft-DS | Active Directory directory service required for Active Directory access and authentication. |
UDP | 123 | NTP | Network Time Protocol. |
UDP | 137 | NETBIOS-NS | NETBIOS name service. |
UDP | 138 | NETBIOS-dgm | NETBIOS datagram service. |
UDP | 445 | Microsoft-DS | Active Directory service required for Active Directory access and authentication. |
UDP | 1025 | Blackjack | DCOM, used as an RPC listener. |
Network ports that are used by the SQL Server that runs the Microsoft Dynamics CRM Connector for SQL Server Reporting Services server roles
The following table lists the ports that are used for a computer that is running SQL Server and has only SQL Server and the Microsoft Dynamics CRM Connector for SQL Server Reporting Services server roles installed.
Protocol | Port | Description | Explanation |
TCP | 135 | MSRPC | RPC endpoint resolution. |
TCP | 139 | NETBIOS-SSN | NETBIOS session service. |
TCP | 445 | Microsoft-DS | Active Directory required for Active Directory access and authentication. |
TCP | 1433 | ms-sql-s | SQL Server sockets service. This port is required for access to SQL Server.This number may be different if you have configured your default instance of SQL Server to use a different port number or you are using a named instance. |
UDP | 123 | NTP | Network Time Protocol. |
UDP | 137 | NETBIOS-NS | NETBIOS name service. |
UDP | 138 | NETBIOS-dgm | NETBIOS datagram service. |
UDP | 445 | Microsoft-DS | Active Directory service required for Active Directory access and authentication. |
UDP | 1025 | Blackjack | DCOM, used as an RPC listener. |