Database and AD Connections are failing in Production

[Vidhya]

Hi Team,

We noticed the connections are failing for DB and AD connection in Production. 

For DB we get below error 

ERROR saviynt.ImportExternalDbService  - Error while saving the Connection: Target Error Message: [com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host xyz, port 1433 has failed. Error: "null. Verify the connection properties. Make sure th]"

"2024-07-12T02:56:28.243+00:00","ecm","","null-6fzgr","","2024-07-12T02:56:27.834527286Z stdout F 2024-07-12 02:56:27,834 [http-nio-8080-exec-122] ERROR domain.EcmConfigController  - The TCP/IP connection to the host xyz, port 1433 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."."

For AD we get below error

ERROR ldap.SaviyntGroovyLdapService  - Exception.. try next url"

"2024-07-12T02:50:06.252+00:00","ecm-worker","","null-8w2fv","","2024-07-12T02:50:06.131371924Z stdout F javax.naming.CommunicationException: xyz:636 [Root exception is java.net.UnknownHostException: xyz]"

Attaching the log files below

Please find the below connection names: 

DB: COB_PAY_GLOBAL_DB

AD: COB_AD

Thanks,

Vidhya

[rushikeshvartak]

Check if dns resolver in place or not ?

[Vidhya]

Hi @rushikeshvartak ,

DNS resolver i in place and functioning correctly 

Thanks,

Vidhya

[rushikeshvartak]

This issue with port opening check with sc2 / network team