dynamics ax 2009 supported sql server versions

Book traversal links for Sincronización de la base de datos de Microsoft Dynamics AX 2009 sobre Sql Server 2008 In another post I hope to discuss what steps to follow when you synchronize a table Ax. This usually happens at a new facility which has not been activated at all (Thanks Alexander for the help! ). The problem is probably that the functionality of hanging this type of field is disabled. If it is something that occurs only in the field, or rather with that type of field (Extended Data Type) database has nothing to do. According to the official document setup Dynamics Ax 2009 AOS user must have the roles db_ddladmin, db_datareader, and db_datawriter on your database-enabled everything work properly.Īx2009 may be that in adding a field on a table can not be reflected in the database but in the AOTĪxapta. This particular case is solved giving db_ddladmin permissions on the database in question. Problems during SQL data dictionary synchronization. 'Cannot execute a data definition language command on ().

Once installed (or during the installation process) the problem with the database that we can find include:Īnother known problem in data synchronization can be caused by the lack of permits. Some requirements to consider for installing Ax2009 are that the user you want access to the system should be user and DOMAIN in sql server role must be a member of securityadmin dbcreator and to create the new database from Ax installer. Sometimes you can point to the database as a source of the problem but not always. ) I leave here a couple of things you should know (or I should say) when we join ax2009 and sql server 2008. For those database administrators who have to deal with such a Dynamics Ax 2009 and his henchmen (developers, consultants, etc.

Dynamics ax 2009 supported sql server versions