When starting up a Spotlight monitoring session, the UNIX user can't connect to the database server because Spotlight can't negotiate the two-factor authentication process. UNIX user can’t establish a successful connection. It hangs with the ‘Connecting…’ status. The UNIX user’s password authentication is successful but the two-factor authentication process is waiting for a response back from Spotlight.
The workaround is to ask the network administrator to add an exception IP for the host which is running Spotlight.