Working with Entrepreneur Solution

aliennavaliennav Member Posts: 449
edited 2007-12-03 in Entrepreneur Solution
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?

Comments

  • jannestigjannestig Member Posts: 999
    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
  • krikikriki Member, Moderator Posts: 9,086
    [Topic moved from Navision forum to Entrepreneur Solution forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • kauffmannkauffmann Member Posts: 56
    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/
    A good programmer makes al the right mistakes
    My blog
  • aliennavaliennav Member Posts: 449
    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
Sign In or Register to comment.