Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Non-Sysadmin Users Cannot Open NAV 2009 Database

Posted on by 10

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

  • Chuck Hottle Profile Picture
    Chuck Hottle 10 on at
    Re: Non-Sysadmin Users Cannot Open NAV 2009 Database

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans