Console is not accessible and database is marked as "Suspicious" (4287033)

When accessing the Desktop Authority Console a critical error message is received, the Desktop Authority services are running, but the DAConfiguration database is marked as "Suspicious" in SQL Server.

• Corrupted database.
• SQL Server ran out of space or there is not enough space available to recover the database during startup.
• The database cannot be opened due to inaccessible files or insufficient memory or disk space.
• Unexpected SQL Server Shutdown, power failure or a hardware failure.

These steps require to have Microsoft SQL Server Management Studio installed.  If it is not installed it can be downloaded from this Microsoft link

After Microsoft SQL Server Management Studio is installed,

1. Open Microsoft SQL Server Management Studio and connect to SQL Server proper instance.
2. Create a new query clicking the New Query button or hit Ctrl+N.
3. the following SQL script must be pasted into the New Query page.
   EXEC sp_resetstatus DAConfiguration;
   ALTER DATABASE DAConfiguration SET EMERGENCY
   DBCC checkdb(DAConfiguration)
   ALTER DATABASE DAConfiguration SET SINGLE_USER WITH ROLLBACK IMMEDIATE
   DBCC CheckDB (DAConfiguration, REPAIR_ALLOW_DATA_LOSS)
   ALTER DATABASE DAConfiguration SET MULTI_USER
4. Click Execute.

This should remove the Suspicious status on DAConfiguration database.

DISCLAIMER: The information in the script(s) provided is known to work successfully; however, they have not been officially tested by our Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by our Support and Development. Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it. For customization of the Desktop Authority, please contact our Professional Services Organization.