problem connecting to SQL / logging to Axapta 3.0


I’m new to sql so please forgive me if the question i’m asking is possibly stupid.

I have this message popping up when i try to connect to Dyamics Axapta - prior to seeing the login/password window:

[microsoft][ODBC SQL SERVER DRIVER][SQL SERVER]Icorrect syntax near “Idex”.If this is intended as a part of a table hint, A WITH keyboard and parenhesis are now required.

I have SQL Server 2005 Developer Edition installed, and also separately an SQL 2005 Service Manager.

I can connect to SQL Manager ect if thats any helpfull.

Aslo when installing 2 tier Axapta I created a database using a Database Wizard option but never got an option of choosing a collation during the process. Dont know if thats inportant or not …

Many thanks for any help in advance.