Hi All,
Currently, we are in the process to set AD synchronization.
The job server is on-premise and the AD domain controller is in the Azure cloud.
Connectivity is open and when I try to create a synchronization project I am able to connect the domain controller but while loading schema I get an error.
When I checked I can not telnet to port 445 from the job server.
Is it mandatory to open port 445?
I get the below error in a log file.
***********Error*******************
as AccessLevels
2021-02-12 11:57:26.5871 TRACE (SqlLog ) : -- Connection 1 switched from Working to Available
2021-02-12 11:57:26.5871 DEBUG (SqlLog 5d289b72-c04d-401a-b799-ba94c85065aa) : Closing database session.
2021-02-12 11:57:26.6183 DEBUG (SystemConnection ee5e834a-490f-45b8-9a6e-1b80fe0652b9) : Connecting to Root DN dc=internal-test,dc=hcob-bank,dc=com, Server dev-infraaddc01.internal-test.hcob-bank.com...
2021-02-12 11:57:26.6339 DEBUG (SystemConnector cce06689-f468-4996-883f-04899147ebdc) : Connecting target system...
2021-02-12 11:57:27.3359 DEBUG (SystemConnection ee5e834a-490f-45b8-9a6e-1b80fe0652b9) : Connected: Yes
2021-02-12 11:57:27.3359 DEBUG (SystemConnection ee5e834a-490f-45b8-9a6e-1b80fe0652b9) : Getting schema from connector (Root DN dc=internal-test,dc=hcob-bank,dc=com, Server dev-infraaddc01.internal-test.hcob-bank.com).
2021-02-12 11:57:27.3359 DEBUG (SystemConnector cce06689-f468-4996-883f-04899147ebdc) : Getting schema...
2021-02-12 11:57:27.3515 DEBUG (SystemConnector cce06689-f468-4996-883f-04899147ebdc) : Got schema object via server context.
2021-02-12 11:57:30.6588 TRACE (SqlLog Database Session GC) : Cleanup physical connection pool
2021-02-12 11:57:30.6588 TRACE (SqlLog Database Session GC) : 0 connections disposed.
2021-02-12 11:57:30.6588 TRACE (SqlLog Database Session GC) : Available = 1
2021-02-12 11:57:40.6586 TRACE (SqlLog Database Session GC) : Cleanup physical connection pool
2021-02-12 11:57:40.6586 TRACE (SqlLog Database Session GC) : 0 connections disposed.
2021-02-12 11:57:40.6586 TRACE (SqlLog Database Session GC) : Available = 1
2021-02-12 11:57:48.5212 TRACE (SqlLog ) : -- Connection 1 switched from Available to Working after comparison
2021-02-12 11:57:48.5212 TRACE (SqlLog ) : --> existing connection 1
2021-02-12 11:57:48.5212 DEBUG (SqlLog f96cace8-6cec-4f9c-972c-9d645b4131c0) : (6 ms) - select top 1 IsDBSchedulerDisabled, IsJobServiceDisabled,
case
when exists (select top 1 1
from QBM_VDBQueueContent
where UID_Task = 'QBM-K-COMMONWAITFORCOMPILER'
) then 1
else 0
end as DbQueueWaitForCompiler,
len(dbo.QBM_FGIMaintenanceRunning()) as Maintenance
from DialogDatabase with (nolock)
where IsMainDatabase = 1
2021-02-12 11:57:48.5212 TRACE (SqlLog ) : -- Connection 1 switched from Working to Available
2021-02-12 11:57:49.5509 DEBUG (SystemConnector cce06689-f468-4996-883f-04899147ebdc) : Error accessing schema: Directory server "dev-infraaddc01.internal-test.hcob-bank.com" does not exist or cannot be contacted.
2021-02-12 11:57:49.5509 DEBUG (SystemConnector cce06689-f468-4996-883f-04899147ebdc) : ActiveDirectorySchema not loaded.
2021-02-12 11:57:50.6741 TRACE (SqlLog Database Session GC) : Cleanup physical connection pool
2021-02-12 11:57:50.6741 TRACE (SqlLog Database Session GC) : 0 connections disposed.
2021-02-12 11:57:50.6741 TRACE (SqlLog Database Session GC) : Available = 1
