You need to add one of the kernel rollups because sp5 isn't sql2005 compatible
Med venlig hilsen Kim Truelsen +4529499958 -----Oprindelig meddelelse----- Fra: "Abdul Kadar" <[EMAIL PROTECTED]> Til: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; "development-axapta@yahoogroups.com" <development-axapta@yahoogroups.com> Sendt: 21-06-2007 02:02 Emne: [development-axapta] SQL error when linking SQL 2005 database with Ax 3.0 SP5 Hi, I have installed Ax 3.0 SP5 in a Win XP operating with SQL server 2005. This was a fresh installation. After the database been created in SQL server 2005, the very first time, when opening Axapta, the system gives the following error message: --------------------------- SQL error --------------------------- Microsoft SQL Server has reported the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. You may refer to the error log file for further details. Retry the operation? --------------------------- Yes No --------------------------- This error appears after the logon screen of Ax 3.0. Once we say yes/no, it keeps on giving different errors. I guess, this would be possible to use SQL server 2005 with Ax 3.0. Please help me to get rid of this error. Thanks in advance. Abdul --------------------------------- Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. [Non-text portions of this message have been removed]
