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  >

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

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
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.