Cannot connect to the ChangeAuditor Client. "Database access error, please verify the ChangeAuditor database connection (4235678)

The following error is returned when attempting to connect to the Change Auditor client:

Cannot connect to the ChangeAuditor Client.  "Database access error, please verify the ChangeAuditor database connection

The following messages are found the ChangeAuditor.Service.exe.nptlog (Coordinator log) :

2012-08-13 13:23:58.430 [34][INFO][OnExceptionSqlEvent(0)] SQL error(-2146232060): The transaction log for database 'ChangeAuditor' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases; command: dbo.usp_Repository_Write
2012-08-13 13:23:58.430 [34][ERROR][ExceptionSql_ExceptionSqlEvent(0)] SQL connection lost. Connections will be dropped and coordinator will attempt to reconnect
2012-08-13 13:23:58.539 [34][INFO][ScheduleTask(0)] Scheduling SqlReconnectTask, first run: 00:00:10, period: 00:00:30
2012-08-13 13:24:05.525 [34][ERROR][DataSetWrapper(0)] Database inactive
2012-08-13 13:24:05.525 [34][WARN][_Run(0)] Task AlertProcessorSmtpTask has not completed successfully due to error: Database inactive
2012-08-13 13:24:08.529 [34][INFO][Run(0)] Retrying SQL connection
2012-08-13 13:24:08.529 [34][INFO][Connect(0)] Opening ChangeAuditor database: Data Source=ServerName;Initial Catalog=ChangeAuditor;Integrated Security=True;User ID=Domain\SQLAccount;Application Name="ChangeAuditor Coordinator on ServerName"
2012-08-13 13:24:08.529 [34][INFO][Run(0)] SQL connection re-established successfully

These messages then repeat.

These message occur when the Transaction log for the ChangeAuditor database cannot grow because the disk drive is full or the log reached it's set limits.

This issue is usually due to there not being enough disk space for the transaction log and the specified Recovery mode setting.

1. Set the SQL Database recovery model to Simple or perform backups to backup and clear the transactions logs
2. The recovery model can be changed by opening Microsoft SQL Server Management Studio | right-click the "ChangeAuditor" database | select "Properties" | choose the "Options" page | set "Recovery model:" to "Simple"
   Note: this change has an impact on how the database can be restored. Please review the recovery models to ensure you are performing the necessary actions when set to Simple
3. Shrink the ChangeAuditor database using SQL best practices.

Sometimes, if SQL server is patched and server reboot is pending, this error will show. So restart SQL server once and this may resolve the issue.