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.
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 (Lohndorf)
Microsoft Dynamics UK
Microsoft Customer Service and Support (CSS) EMEA
Great article, you can also consider checking this list of the most important trace flags for SQL Server, I personally have this in my bookmarks as reference sqlturbo.com/the-most-important-trace-flags-for-sql-server