Centrify

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.

Related Articles

 articleKB-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit installation from one database server to another articleKB-2109: Are there any sizing guides to help plan for scalability and storage requirements for DirectAudit? article[HOW TO]Install and setup the Centrify Licensing Service articlehow to migrate databases associated with a Centrify DirectManage Audit 3.x installation articleKB-6304: Direct Audit Manager Cannot See Collector or Audit Store Databases articleKB-6863: Failed to add Master Auditor (RPC server unavailable) articleCentrify 18.3 Release Notes articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role? articleKB-4371: “A database operation error occurred” & “Invalid database” error when opening Audit Manager