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 :-)

You can leave a response, or trackback from your own site.

2 Responses to “Trace Flag 4616”

  1. marc hasenbeck says:

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

    Also too you :-)

    Marc

  2. Vincent Vancalbergh says:

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

    Thx!

Leave a Reply


+ five = 12