Error = -2146824582. Connection String: Provider=SQL01;Server=Quest01;Database=ActiveAdministrator;Trusted_Connection=yes;
The domain controllers are coming up before the Active Administrator server and SQL server or there is a SQL server client provider TLS connection compatibility issue between servers.
Within the Active Administrator console | Auditing & Alerting | Agents, highlight all of the agents and select "Stop" and then "Start".
If restarting the agents does not resolve the problem, try testing the connect to the SQL database from the DCs:
Note: If SQL is installed on the Active Administrator server, make sure the SQL Browser Service is started. Also verify that the default port (1433) appears in the SQL Configuration TCP/IP properties.
For TLS 1.2 connection support, first make sure that the installed SQL Server version supports it. This can be verified with the help of the following link:
The AA agent installed in a DC first looks for the 2012 SQL native client (11.x) .dlls if they exist, and fall back to the older drivers otherwise which will only support a TLS 1.0 connection. To install the SQL 2012 native client on the DCs with agent, download it from here:
Finally, try testing the 2012 SQL native client (11.x) connection from the DCs:
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center