Clients are not able to connect to the Active Roles Administration Service.
The Active Roles Admin Service event viewer logs show the following error:
Event ID 2501
A time out occurred while waiting to optimize the query. Rerun the query.
SQL Server Management Studio is also not able to connect to the database server which hosts the Active Roles Configuration database, and eventually fails with the same error.
Restart the SQL Server service and ensure that the native Microsoft tools can connect as expected. This should also resolve the issue with the Active Roles Administration Service start up.
If the issue persists or returns, please contact Microsoft for assistance.
For a root cause analysis, please contact Microsoft for assistance.