Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-10646: “You cannot connect to the SQL Server” when opening Audit Manager / Audit Analyzer

7 March,19 at 09:05 AM

Applies to: Centrify Auditing Services

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.”
The error when opening Audit Manager / Audit Analyzer

 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
 
Solution:
Open UDP 1434 port on the SQL server.

 

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.