Few days back, one of my AOS Services won't start. In the Event Viewer, I found this error message:
Error 1 - Object Server 01 The database reported session 1 AOS [Microsoft][ODBC SQL Server Driver][SQL Server]The specified schema name DBO either does not exist
Solution - After some troubleshooting, Found that this was due to the Collation change at SQL Server level which was made sometime back for testing Chinese characters.
Changed the Collation back to the default collation of SQL Server and now AOS Service started.
SQL Collations is a whole new world which I explored a while ago. Will be writing a detailed post soon on that. Watch out this space!