Developer’s Toolkit for Microsoft Dynamics NAV

Asked By 40 points N/A Posted on -
qa-featured

Hi Friends,

The problem is with my Microsoft Dynamics NAV 2009 SP1. While opening NAV SQL database I received an error message.

Have a look at the screenshot. How can I set the trace flag 4616?

Have you any idea?

Please help me to solve the problem.

Thanks you for solutions.

 

Developer’s Toolkit for Microsoft Dynamics NAV

The trace flag 4616 is not set on the database server ventos. You must set this flag and restart the server before you can connect to the database.

SHARE
Answered By 0 points N/A #131387

Developer’s Toolkit for Microsoft Dynamics NAV

qa-featured

The error message you are getting is because Trace Flag 4616 is not set. Here I am telling you the solution how you can set trace flag 4616 :

Firstly you have to start SQL Server Configuration Manager as :

Start > All Programs > Microsoft SQL Server 2005/2008 > Configuration Tools > SQL Server Configuration Manager.

Now on the left side, Select the <SQL Server Services>, then check for the position of <SQL Server(MSSQLSERVER)> on right side, now right click on it and select Properties. Then Select the Advanced tab.

Now add startup parameter at the end of existing ones (separating existing ones with a semi-colon) : t4616. then press OK.

Now you have to restart SQL Server services, to make these setting effective; then right click <SQL Server (MSSQLSERVER)> again and now select Restart.

Login/Register to Answer

Related Questions