Dynamics Ax 2009 Demo data - SQL error
The program is unable to load and execute the class 'SqlDatabaseInit', which is essential in order to identify the database vendor and load the appropriate SQL system variables.
This can be caused by insufficient access rights to the SQL Database, a missing or corrupted application file, or syntax error(s) within the class itself.
Solution - This error is due insufficient access rights. After restoring standard demo data, AOS service account must be manually assigned following database roles - db_ddladmin, db_datareader and db_datawriter. Additionally execute rights must be granted on the two stored procedures as well (CREATESERVERSESSIONS and CREATEUSERSESSIONS).