the indicator of follow-up 4616

[Jimmynd]

Hi all,

We’ve installed SQL SERVER 2005. This instalation looks like ok but when I try to conect to the server with finsql.exe the system shows the following message:

“The indicator of follow-up 4616 is not established in the server. You must establish this indicator and restart the server before connecting using Microsoft Dynamics NAV”

However, this indicator is installed in the server.

Does anybody understand what are happening?.

Thanks.

[stryk]

Hi!

With MS Dynamics NAV 5.00 the Trace Flag 4616 needs to be activated:

Makes server-level metadata visible to application roles. In SQL Server 2005, an application role cannot access metadata outside its own database because application roles are not associated with a server-level principal. This is a change of behavior from earlier versions of SQL Server. Setting this global flag disables the new restrictions, and allows for application roles to access server-level metadata.

To activate the Trace Flag, you have to add the /T4616 to the Startup -Parameter of the SQL Server (recommended), or you could enable it using the command DBCC TRACEON (4616, -1), e.g. executed via an auto-start SQL Server Agent job …

To check if the flag is set use DBCC TRACESTATUS (-1)

Best regards,

Jörg

[David_Singleton]

I noticed just recently that when you install NAV 5.00 its sets the flag in the startup paramaters of SQL on that machine, BUT you need to restart SQL for it to take effect.

[modric]

So, free cheese has ended [:D]

With this Trace Flag 4616 off, unlimited number of users could connect… doesn`t matter how many of them in license.

[Jimmynd]

thanks all,

We’ve installed the trace flag 4616 as start up in SQL SERVER 2005, but Dynamics NAV follows showing the same error.

Thanks again.

[DenSter]

You have to restart the SQL Server service for it to take effect.

[Jimmynd]

hi DenSter,

when we re-start SQL SERVER, Dynamics NAV doesnt work and we dont the reason.

Thanks in advance.