Working with Entrepreneur Solution

aliennav

Has anyone worked with Entrepreneure Solution.
I have installed it and while creating new DB mess. is coming to set the FLAG 4616 in SQL server.
What to do to remove the error?

jannestig

There are 2 solution for that

1) Run this script on server

DBCC TRACEON(4616,-1)
GO

The problem is that every server restart you need to again


2) Second solution (permanent)

01.) Open the Start Menu
02.) Go to Microsoft SQL Server 2005 Group
03.) Go to Configuration Tools Group
04.) Click on SQL Server Configuration Manager
05.) Click on SQL Server 2005 Services
06.) Right-click on SQL Server ($INSTANCENAME) and click on Properties
07.) Click on the Advanced tab
08.) Go to Startup Parameters
09.) Enter the string so that it looks as follows (notice the end is the only change):
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T 4616
10.) Click OK
11.) Restart the SQL Server service

kriki

[Topic moved from Navision forum to Entrepreneur Solution forum]

kauffmann

aliennav wrote:

Has anyone worked with Entrepreneure Solution.
I have installed it and while creating new DB mess. is coming to set the FLAG 4616 in SQL server.
What to do to remove the error?

The installer of Entrepreneur sets the traceflag (as does the installer of NAV) but you have to restart the SQL service afterwards. This is also described in the 'Quick Installation Guide' that is found in the Doc folder on the dvd.
Future version of the installer of Entrepreneur will also restart the service for you. \:D/

aliennav

jannestig wrote:

There are 2 solution for that

1) Run this script on server

DBCC TRACEON(4616,-1)
GO

The problem is that every server restart you need to again


2) Second solution (permanent)

01.) Open the Start Menu
02.) Go to Microsoft SQL Server 2005 Group
03.) Go to Configuration Tools Group
04.) Click on SQL Server Configuration Manager
05.) Click on SQL Server 2005 Services
06.) Right-click on SQL Server ($INSTANCENAME) and click on Properties
07.) Click on the Advanced tab
08.) Go to Startup Parameters
09.) Enter the string so that it looks as follows (notice the end is the only change):
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T 4616
10.) Click OK
11.) Restart the SQL Server service

Thanx ma'an