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.