Return
-
Title
Enterprise Reporter - SQL Discovery Issue -
Description
Error in the SQL discovery. 'No network path available to the SQL server'
-
Resolution
Required ports for the SQL discovery
The following ports need to be open between ER and the target SQL servers:
- 445/TCP - SMB
- 135/UDP - RPC Service & Endpoint Mapper
- 49152-65535 TCP/UDP - DCOM
- 1433/TCP - SQL
- ICMP
Please also ensure the correct firewall rules are in place for these ports to access the target SQL server.