Nav developer: Basic SQL - Enable trace flag 4616 on SQL Server

[Blog bot]

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.


===






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:





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.









Lars Lohndorf-Larsen


Microsoft Dynamics UK



Microsoft Customer Service and Support (CSS) EMEA


These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.




Читать дальше