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.


 


 



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.

Comments (7)

  1. Anand says:

    Thanks, it solved my problem in no time

  2. rima says:

    When I am trying to add ;-t4616 to the existing parameter,I am getting an error 'the parameter is invalid'..please help

  3. Lohndorf says:

    Looks like a problem with SQL configuration manager. Maybe this link and suggestion to use PowerShell helps:

    social.msdn.microsoft.com/…/cant-change-startup-parameters

    For more recent versions of NAV we don't need this startup parameter anymore, so check if you need it at all? When you start the classic client it will tell you if it's needed.

    Hope that helps,

    Lars

  4. Abinash says:

    What is the effect on other database present on the same server(instance) if I change the trace flag?

  5. Lars Lohndorf-Larsen says:

    Hi Abinash,

    Thanks for your interest. Just FYI this blog was migrated to the NAV blog, and all posts got migrated, this one to here: blogs.msdn.com/…/basic-sql-enable-trace-flag-4616-on-sql-server.aspx.

    And regarding trace flag 4616 then this one as far as I know so will have the same effect on other databases. However you don't need this flag anymore:

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

    I hope this helps,

    Lars

  6. Abinash says:

    lars

    Thanks for your helpful and quick respond,