ARS Collector stopped working after SQL update to 2012. When you try to run the ARS Collector manually you get the following error:
Revision of the ARS Collector log reveals the following error:
Could not find stored procedure 'sp_dboption'.
The sp_dboption stored procedure was deprecated and removed in SQL Server 2012, therefore the ARS 6.7 Collector is unable to perform its function. ARS 6.7 does not support SQL Server 2012 (see enclosed: ActiveRolesServer_6.7_ReleaseNotes).
Upgrade ARS or downgrade SQL Server to a supported version.