Developer’s Toolkit for Microsoft Dynamics NAV

Asked By Greg Lewis 40 points N/A Posted on - 11/28/2012

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.

• Status: Open
• Question Views: 1343
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Others

Answered By Larson Glenda 0 points N/A #131387

Developer’s Toolkit for Microsoft Dynamics NAV

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.

About Larson Glenda

Questions
6

Answers
17

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: Microsoft Others