Tuesday, October 30, 2007

Error traceflag 4616 at start NAV in SQL 2005

Thanks to nilsm for post in the Tips dBits forum.

To try execute Dynamics NAV (Navision) in SQL 2005 show the next error:
"The indicator 4616 is not established on the server. This indicator must establish and restart the server before connecting using Microsoft Dynamics NAV."

To correct this situation, proceed as follows:
01.) Open the Start Menu
02.) Go to Microsoft SQL Server 2005 Group
03.) Go to Configuration Tools Group
04.) Click on SQL Server Configuration Manager
05.) Click on SQL Server 2005 Services
06.) Right-click on SQL Server ($INSTANCENAME) and click on Properties
07.) Click on the Advanced tab
08.) Go to Startup Parameters
09.) Enter the string so that it looks as follows (notice the end is the only change):
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T 4616
10.) Click OK
11.) Restart the SQL Server service

No comments: