NAS Collation error

Hi, When i try to start the NAS it gives the following warning message in the event viewer. “You can only use SQL Collations or Binary Windows Collations with the current version of Microsoft Navision Attain.” Collration name on Database is “Latin1_General_CS_AS”. Any idea? Thanks

Have you checked the application you want to execute with the application server? The error may be there?! Good luck! Andreas

Since you could not have created a database from Attain with that collation (as the message says only binary windows collations are possible which would be Latin1_BIN …, or SQL collations which begin SQL_ …) someone must have altered the collation externally. This can be done with an ALTER DATABASE x COLLATE y statement. I think you should create the database again from an Attain client, and ensure you choose a SQL collation in the collation tab, that matches your language requirements. Windows collations are really not usable until version 3.70 (where they are preferable). Then NAS will be happy.