Set the trace flag 4616

ricky76
ricky76 Member Posts: 204
edited 2007-08-16 in NAV/Navision Classic Client
Hi, i am having trouble with opening a SQL database locally as it is coming up with the error 'the trace flag 4616 is not set'. Can anyone help me in reslolving this issue? I would appreciate any help.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,127
    Look in this topic. There someone describes what to do.
    http://www.mibuso.com/forum/viewtopic.php?t=15741
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • ricky76
    ricky76 Member Posts: 204
    Many thanks.
  • pdj
    pdj Member Posts: 643
    I know how to set the traceflag, but I haven't been able to find any official MS documentation about it in neither the w1w1ism.pdf nor the w1w1isql.pdf.

    Where does MS describe the need for this flag?
    Regards
    Peter
  • colin_leversuch-roberts
    colin_leversuch-roberts Member Posts: 113
    http://support.microsoft.com/kb/906549
    http://msdn2.microsoft.com/en-us/library/ms188396.aspx

    Like many applications navision does all sorts of stuff it shouldn't with system tables and such. The security model of 2005 stops this so the trace flag essentially weakens security to make it like sql2000
  • pdj
    pdj Member Posts: 643
    Thanks, but where does MS mention it during the NAV-installation or NAV-migration? There should even be a section about what to do when upgrading an existing NAV-SQL from SQL2000 to SQL2005.

    I have only seen it it newsgroups, and by the fact that you get the errormsg if you don't set it.
    Regards
    Peter
  • DenSter
    DenSter Member Posts: 8,307
    You must have missed it when you read those documents :-k

    Section 1.7 of w1w1isql.pdf:
    Before you can access SQL Server 2005 from Microsoft Dynamics NAV, you must set
    trace flag 4616 on SQL Server 2005.
    and it then shows screenshots of how to do it
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • colin_leversuch-roberts
    colin_leversuch-roberts Member Posts: 113
    just out of interest is this just 4.0 sp3 or should this trace flag be set with any nav 4.0 to sql 2005
  • pdj
    pdj Member Posts: 643
    DenSter wrote:
    You must have missed it when you read those documents :-k
    Ahh, I only checked the NAV4SP3 docs and not NAV5. My mistake. :oops:
    How could I expect MS to update the docs on the NAV4SP3 cd just because they changed the requirements 8)
    Regards
    Peter
  • Waldo
    Waldo Member Posts: 3,412
    colin leversuch-roberts wrote:
    just out of interest is this just 4.0 sp3 or should this trace flag be set with any nav 4.0 to sql 2005

    This thread could be helpful for you:
    http://www.mibuso.com/forum/viewtopic.php?t=18571

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • pdj
    pdj Member Posts: 643
    Waldo wrote:
    http://www.mibuso.com/forum/viewtopic.php?t=18571
    Which also explains why I didn't find it mentioned on the SP3 cd... :oops:
    Regards
    Peter
  • Waldo
    Waldo Member Posts: 3,412
    Indeed ... 8)
    "Search" is your friend :wink:

    Now, for me, the only question is "why" :|

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • DenSter
    DenSter Member Posts: 8,307
    pdj wrote:
    DenSter wrote:
    You must have missed it when you read those documents :-k
    Ahh, I only checked the NAV4SP3 docs and not NAV5. My mistake. :oops:
    How could I expect MS to update the docs on the NAV4SP3 cd just because they changed the requirements 8)
    I didn't know it was not in the SP3 documentation, but I'm not surprised that stuff like that was overlooked :mrgreen:
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories