Trace Flag 4616

When using Navision (Dynamics NAV 5.0 or higher) with SQL 2005 (express or full) – you will receive a trace flag error, when trying to create a new database, unless you already has changed your SQL Server configuration.

So what to do when receiving this error? That’s simple – add the trace flag 😉

First go into your configuration manager. Usually it is located here:

Start
-> Programs
-> Microsoft SQL Server 2005
-> Configuration Tools
-> SQL Server Configuration Manager

Next go into properties for your SQL Server Instance:

  • Select SQL Server 2005 Services
  • In the right window, you will now see your SQL Server
  • Right click on your server on select properties

Now all that is to do – is adding the trace flag

  • In the open window select Advanced
  • Find Startup Parameters
  • Add -T 4616 to the end

Example:
-dc:\Programmer\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-ec:\Programmer\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lc:\Programmer\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T 4616

Now select OK – restart you SQL Server Service, hereafter you will be able to create/use databases with Navision 🙂

2 Comments

  1. Thanks a lot for this tipp – so i can finish my work and have an nice weekend.

    Also too you 🙂

    Marc

  2. Same here, first decent result in Google. Saved me from annoying our SQL-Pro guy.

    Thx!

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.