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.
*This post is locked for comments
This issue apeared when we tried to migrate our NAV environment to Windows Server 2008/SQL Server 2008. It turns out that all NAV Windows logins that do not have sysadmin rights on the database server require View Any Definition rights. That is the only solution that we found to this issue.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156