Set the trace flag 4616

ricky76

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.

kriki

Look in this topic. There someone describes what to do.
http://www.mibuso.com/forum/viewtopic.php?t=15741

ricky76

Many thanks.

pdj

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?

colin_leversuch-roberts

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

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.

DenSter

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

colin_leversuch-roberts

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

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)

Waldo

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

pdj

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:

Waldo

Indeed ... 8)
"Search" is your friend

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

DenSter

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