·
1 min read

Basic SQL – Enable trace flag 4616 on SQL Server

This post is part of “Overview of NAV-specific SQL features for application consultants”.

The newest versions of Microsoft Dynamics NAV require trace flag 4616 to be enabled on SQL Server. If not, then you will get this error message when you try to connect:

===
The trace flag 4616 is not set on the server (local). You must set this flag and restart the server before you can connect using Microsoft Dynamics NAV.

===

Error4616

How to set trace flag 4616:

Start SQL Server Configuration Manager:
Start -> All Programs -> Microsoft SQL Server 2005/8 -> Configuration Tools -> SQL Server Configuration Manager
On the left side, select “SQL Server Services”, then Locate” SQL Server (MSSQLSERVER)” on the right side. Right click it and select Properties. Then select the Advanced tab:

SQLConfigManager

Then add the startup parameter at the end of the existing ones (separating the existing ones with a semi-colon):
;-t4616

Then click OK.
You must restart the SQL Server service before this setting takes effect: Right click on “SQL Server (MSSQLSERVER)” again, and this time select Restart.