Hello Everyone.
We have an old system AX2009 which has old data of previous years. This system is no longer operational. Its only purpose is to retrive old data when needed during a tax audit.
We had the AOS installation on a machine and the database was residing in the same DB instance of our current AX2012 database machine. We faced a failure in the database machine so we restored latest backups of AX2012 databases and restored the unchanged database of AX2009 too. Ax2012 is worked fine without any issues, however the AX2009 AOS service did not start.
The error code given was code:100 and event viewer showed the following error:
Object Server 02: SQL diagnostics: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Connect information was: Userid = [], Database = [DynAX2009_Wahba_DB], Server = [AX2009_BACKUPSS], DSN = [], Other = []
For the purpose of trouble shooting, we installed SQL2012 on the same machine as AX2009 AOS. Restored the database and we are facing the same issue. We made sure that the server config of Ax2009 AOS is pointing to the correct DB.
Does the AX2009 AOS service require ODBC connection to perform some tasks? We tried setting up ODBC (32bit and 64bit) still no effect.
Can anyone help in what could be the problem.
We found one thread having similar case, but the resolution there was a fresh installation of SQL and AX2009. We cannot perform such a task as our team has no knowledge of AX2009 installation also the previous teams have left no documentation of what version of AX2009 was setup and what customizations were carried out.
Any guidance will be appreciated.
