Attempting to migrate ayanova from firebird to SQL Server Express 2008. Firebird to MSSQL says connections are ok, then I run the migration. Both bars get to 100%, I then modify the ayanova express sql config.txt to reflect the correct settings. Then, when attempting to run Ayanova, I get this error in ayalog.txt:
[Header] 2010-03-25 13:36:58,046  INFO AyaNova.clsMain - AyaNova start - brief environment: Machine name: xxxxx AyaNova Connection: DataBase - Server=xxxx\xxxxxxxx;initial catalog=AyaNova;User Id=sa; Password=password; OS version: Microsoft Windows NT 5.1.2600 Service Pack 3 CLR version: 2.0.50727.3607 Primary assembly: AyaNova 126.96.36.199 Primary assembly location: file:///C:/Program Files/Ground Zero Tech-Works Inc/AyaNova/AyaNova.exe 2010-03-25 13:36:58,156  FATAL AyaNova.clsMain - First initialization and connect attempt System.Security.SecurityException: This AyaNova database appears to have been modified outside of the AyaNova program or is damaged in some way. This may very rarely be caused by corruption but is more likely a result of someone tampering with the database and making changes outside the AyaNova program. (In some cases you may get this error when attempting to use AyaNova 5.x or newer with Microsoft SQL server 2000 which is not supported, only version 2005 or newer.) Your data is probably ok, but the database is not in a supportable state and will need to be returned to it's proper state. Please provide the following information to AyaNova technical support for assistance: Schema Count: 0 Schema: at GZTW.AyaNova.BLL.AyaBizUtils.1() at GZTW.AyaNova.BLL.AyaBizUtils.Initialize() at AyaNova.clsMain.MyApp.OnCreateMainForm() The Zone of the assembly that failed was: MyComputer
Other thread said to check windows update and make sure all .net patches are installed, which they are. Please advise on how to correct this problem and get Ayanova working properly with MSSQL Express 2008. I have ran the migration tool twice, with the same outcome both times.