I managed to find an old Axapta version to practice some programming and learn Axapta a little. The problem is I can't get it started. I had installed SP1-2-3 and started it, it is supposed to create the database. Well it creates some tables then I get a syntax error from SQL Server. I am told even SP1 was enough for SQL 2005. The error is 'Incorrect syntax near INDEX'. I don't know what to do at the moment. I am waiting for a friend to dl SQL 2000 from MSDNAA. If there are any Axapta experts here, any suggestions?
Narsil, there is another option to make Axapta sp1 work with SQL Server 2005. Just open properties of your database in Management studio, go to 'options' tab and set compatibility mode to SQL Server 2000 - (80). Afterwards run Axapta synchronization again. This should work.