We have NAV 2009 Classic Client installed in a Citrix environment. We created a new NAV database on a Windows Server 2008/SQL Server 2008 server. We set our collation to SQL Collation “Western-European dictionary sort order, code page 1252, case-insensitive, accent-sensitive (52)” which equates to “SQL_Latin1_General_CP1_CI_AS” in SQL Server terminology. Using the NAV backup/restore, we restored a company from a database that is set to Windows collation, Latin1_General_CI_AS. We verified that all columns in the new database are set to SQL_Latin1_General_CP1_CI_AS.
When NAV users that have sysadmin rights on the server open the database, everything works fine. When users who don’t have sysadmin rights open the database they receive the following error.
The ? collation is not supported by Microsoft Dynamics NAV Classic
We created a new database on a Windows Server 2003 R2/SQL Server 2005 server with the same collation. The issue is not reproduced in this environment.
We also installed NAV 2009 on a workstation to eliminate the Citrix variable, but the issue still exists, so it seems to be related somehow to the Windows Server 2008/SQL Server 2008 server.
If anyone has any ideas about what may be causing this, we’d like to hear from you.