SQL Server Trace Flag 4616 is no longer required for Microsoft Dynamics NAV 2009 SP1. After upgrading to Microsoft Dynamics NAV 2009 SP1 system administrators should consider turning off SQL Server Trace Flag 4616.
SQL Server Trace Flag 4616 is no longer required for Microsoft Dynamics NAV 2009 SP1. After upgrading to Microsoft Dynamics NAV 2009 SP1, system administrators should consider turning off SQL Server Trace Flag 4616.
Starting with Microsoft Dynamics NAV 4.0 SP3 build 24080, the SQL Server trace flag 4616 had to be turned on for Microsoft Dynamics NAV with SQL Server. This was initially required when running Microsoft Dynamics NAV with Microsoft SQL Server 2005 but subsequently was also required for Microsoft SQL Server 2008.
Why did we need trace flag 4616?
SQL Server 2005 introduced increased security protection for database metadata, which meant that visibility was restricted by default for users in such a way that they could no longer see connection details for other logins unless they were granted “VIEW SERVER STATE” permissions. However, Microsoft Dynamics NAV licensing functionality and the client feature for displaying database sessions both require that users must have visibility to all active connection details. SQL Server trace flag 4616 causes SQL Server 2005 and SQL Server 2008 to behave in the same way as SQL Server 2000 with respect to metadata visibility. Therefore, when support for SQL Server 2005 was added for Microsoft Dynamics NAV, the requirement to turn on trace flag 4616 was also introduced.
Why do we no longer need trace flag 4616?
With the release of Microsoft Dynamics NAV 2009 SP1, trace flag 4616 is no longer required. The product now uses “VIEW SERVER STATE” permissions to enable visibility to the required connection information for each user.
For customers who have been using SQL Server trace flag 4616 for older versions of Microsoft Dynamics NAV, Microsoft recommends disabling this trace flag after upgrading to Microsoft Dynamics NAV 2009 SP1, if there are no other applications which require this trace flag. Most environments will have trace flag 4616 added to the startup parameters for the SQL Server Service. Follow these steps to remove the trace flag:
- Go to Start, All Programs
- Select Microsoft SQL Server 2005/2008, Configuration Tools, SQL Server Configuration Manager.
- In SQL Server Configuration Manager select SQL Server 2005/2008 Services and then select SQL Server (MSSQLSERVER) under Name.
- Right-click SQL Server (MSSQLSERVER) and select Properties.
- In SQL Server (MSSQLSERVER) Properties, select the Advanced tab.
- In the list of values double-click Startup Parameters.
- In the list of values for Startup Parameters (normally near the end), remove the following: ;-T4616
- Click OK to save the change.
- Right-click SQL Server (MSSQLSERVER) and select Restart.
In some rare cases the trace flag may be enabled on SQL Server using some other means (e.g. DBCC TRACEON command). Consult your SQL Server database administrator for advice in these scenarios.