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?
Axapta v3.0 with SQL 2005?
666 views Asked by Ufuk Hacıoğulları At
2
There are 2 answers
0
holz
On
For Axapta v3.0 to work with SQL Server 2005, you will need to apply the Kernel Rollups (KR), which you can't on SP1. I believe SP2 is a minimum for KR2 which will you get you working on SQL Server 2005.
If you are only going to have a small database to learn Axapta, instead of SQL Server 2005 you can use MSDE with SP4. You can get it from here.
I have not tried Axapta v3 with KR2 or KR3 running on SQL Server 2005 Express, so I don't know if this even works. Looking at the KR2/3 documentation it does not look like it is supported.
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in COMPATIBILITY
- Which Rstudio, R and R Graphics Engine combinations are compatible?
- Migration From Vue2 to Vue Compact: Build is stuck in the loop
- Change an exe file's compatibility settings with C#
- GNU libc on windows and MINGW
- SVN dump file compatibility with higher version (eg. 1.14.x)
- How to turn off "Use Legacy display ICC color management"?
- Why does the Haskell PVP describe new functions as non-breaking?
- The Microsoft.Adapters.Sql.BizTalk.WcfBtsSqlReceiver assembly (version 3.5.0.0) compatibility issue with 64-bit Office 365
- Airflow PostgreSQL sqlalchemy
- Angular 17.2.0 does not support ConnectionServiceModule?
- Which php version is codeigniter 3.1.11 compatible with?
- Fill PDF fields using iTex -:compatibilities of the versions phone's Android OS, Android Studio, Adobe Acrobat
- .NET Framework 4.5.2-based Console application compatibility problems with .NET 6-based Class Library project
- xcode mac designed for iphone app run in wrong window size
- Unable to Connect Logitech MX Keys Mini to Ubuntu 22.04. Works in Try Ubuntu but Not in Installed Version
Related Questions in AXAPTA
- Nested Json using Data Contract Class in AX 2012 R3
- Pass parameter to validateWrite method in table
- Is there a way to extend a table to be a valid time state table
- How to add OffsetLedgerDimension to Fixed Asset Journal by x++?
- Convert 'Container' type data into serialization without X++ Conpeek
- How to manage dual-sync when single table data is saved to multiples tables from staging table in F&O?
- Join expected in select statement on X++
- SQL filter from range expression like used in Dynamics Ax 2012
- Change checkbox value without datasource and other than the current one AX2012
- Export all records from grid in ax 2012 r2
- export more than 1 million records from dynamics-365-operations (AX 365)
- CODA format d365 fin and ops automate bank statement import
- Declaration class as array in AX 2012
- Labels in Dynamics AX V4
- Resource not opening Excel file in ax 2012
Related Questions in SQL-SERVER-2005-EXPRESS
- cannot connect to SQLExpress usign node.js
- fetch score from previous rank belonging to another student
- An error occurred during local report processing - SSDT
- Windows async batch cannot open database requested by the login
- how to resolve this error "Use of getPreventDefault() is deprecated. Use defaultPrevented instead."
- How to get alone time 11:21 (highlighted in red) with SQL Server database?
- My application cannot connect with my database on MsSql express 2005
- Pass value in a Variable
- sql query to get the column value again in case statement
- SQL Server Express installation required for clients connecting to a server?
- What's the sql exception error number if the maximum limit of the database has been reached
- How to connect VB.net to SQL Server 2005 Express using Windows Authentication?
- how to connect SQL Server 2005 express database to java
- This server supports version 611 and earlier. a downgrade path is not supported
- How to export SQL Server database into Microsoft Access (2007)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
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.