web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Is NAV 5.0 sp1 compati...
Microsoft Dynamics NAV (Archived)

Is NAV 5.0 sp1 compatible with SQL Server 2012 ?

(0) ShareShare
ReportReport
Posted on by Murugan 140

We are currently using NAV 5.0 sp1 on SQL Server 2005 and planning to upgrade SQL Server 2005 to SQL Server 2012.

In one of the PC I installed SQL Server 2012 and I made a copy of NAV 5.0 SP1 databse in SQL Server 2012. When I try to access I get the following error :

"The trace flag 4616 is not set on the server ASW-TDB01. You must set this flag and restart the server before you can connect using Microsoft Dynamics NAV."

As per my inderstanding setting trace flag is not a requirement in newer versions of SQL Server.

Can anyone confirm that NAV 5.0 sp1 is compatiable with SQL Server 2012?

Thanks

Murugan

*This post is locked for comments

I have the same question (0)
  • Mohana Yadav Profile Picture
    Mohana Yadav 61,005 Super User 2025 Season 2 on at

    Microsoft has Announced that Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2 are compatible with Microsoft SQL Server 2012!

    Not sure of NAV5.0SP1.

  • Murugan Profile Picture
    Murugan 140 on at

    Thanks Mohana.

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,005 Super User 2025 Season 2 on at

    Welcome

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at

    Hi

    The trace flag requirement is not a SQL thing but rather a NAV client version thing, you can find the info on how it all works here,

    blogs.msdn.com/.../sql-server-trace-flag-4616-no-longer-required-for-dynamics-nav-2009-sp1.aspx

    My suggestion would be to also do a client only upgrade of their system to NAV 2009 R2 client (So updated the client but not the database functionality) as their are a lot of performance and other benefits of upgrading the client software

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans