Problem: 1. On the server where the SQL server is installed, the user is able to open Audit Manager / Audit Analyzer & connect to the SQL Server successfully.
2. But on a remote server, the same user encountered below error when opening Audit Manager / Audit Analyzer: “You cannot connect to the SQL Server. Please make sure the SQL Server is running and allows remote connection.”
Below prerequisites are checked: >The ports required in KB-4375 are opened. >SQL Server is running well, where Remote connection is allowed
Root cause: UDP port 1434 is not opened on the SQL Server. The SQL Server Browser service listens this port for incoming connections to a named instance and provides the client like Audit Manager / Audit Anaylzer the TCP port number that corresponds to that named instance.
Ports Used By SQL Server https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-2017