The SQL Server Startup Parameter -T4616 is missing

Hi,

I'm one of the admins to support Sage 500 on the back-end side for our Accounting Department, one of our accounting guys has Sage 500 on both the Virtual Machine and a regular desktop, he kept getting the error attached. 

How error was replicated:

  1. Once the user tried to launch the application, he receives the attached error.

Environment:

  • Sage version 7.4
  • SQL Server 2008 R2
  • Windows 7 32-bit

How issue was resolved:

I would like to find the root cause of this as I have already resolved the issue by doing the following:

  1. Had IT helpdesk reimaged the vm profile with Sage 500 included
  2. Dropped the existing user account in Sage application and recreated it
  3. From SQL Server under 'Logins', deleted the user and recreated it
    1. Checked the database for Sage with user and default schema as that user (e.g. CSmith)
    2. 'ApplicationDBRole' and 'Public' checked

-T4616 is a trace flag that can be enabled which Sage 500 does not set, see below:

http://blogs.msdn.com/b/nav_developer/archive/2008/11/05/basic-sql-enable-trace-flag-4616-on-sql-server.aspx

I would like to know the following:

  1. What caused the error?
  2. If -T4616 is not relevant, why did it throw this error?  

Dennis