File Repair

The SQL Server service was not running on the local server, so it was started for you. Try connecting again

Resolution:

Try Connecting again.  Database Administration started the service for you.  If you still can’t connect, check the “services.msc” control panel to see if the service is running.  Try to start the service manually in the services control panel.  If it fails to start, check the event log and escalate

By |October 15th, 2017|File Repair|0 Comments

How do I migrate my custom reports to Sage 100 Contractor 2016 v20?

Resolution:

Open Database Administration> Migrate Custom Reports
Click Migrate from Version 19> Migrate Custom Reports.
On the Migrate Custom Report tab:
Click Browse , and then navigate to and select the folder where your version 19.6 custom reports are stored.
Click Migrate Reports.

By |October 15th, 2017|File Repair|0 Comments

Error: “C:WINDOWSMICROSOFT.NETFRAMEWORKV2.0.50727CULTURE.DLL is either not designed to run on windows or it contains an error. Try installing the program again using the original installation

Resolution:

Please contact network administrator or Microsoft support for assistance with this matter.

By |October 15th, 2017|File Repair|0 Comments

None of my companies show up in the company list V20 and later

Resolution:

On the Company List screen, Hold down shift and click Help

this will open the database connection status window

Look at the status explanation on the Database Connection Status window
The status explanation  will tell you if your sign is not a  user or if the database needs to be upgraded

By |October 15th, 2017|File Repair|0 Comments

SQL Server Express 2014 maximum number of connections

Resolution:

The number of connections to SQL Server Express is not related to the edition; it is related to the operating system. For example, Windows XP (no longer a supported operating system for Sage 100 Contractor) allowed for 10 concurrent connections, while Windows 7 allows for 20. The number of connections for Windows Server operating systems […]

By |October 15th, 2017|File Repair|0 Comments

Error: UPDATE statement conflicted with the CHECK constraint “ck:lgract. nxtchk”. The confliction occurred in the database table “dbo.lgract, column nxtchk. The statement has been terminated when paying credit card

Resolution:

The check number field only has a 12-character limit. Remove some to have that amount, and it will save.

Resolution for Issue ‘Error: UPDATE statement conflicted with the CHECK constraint “ck:lgract. nxtchk”. The confliction occurred in the database table “dbo.lgract, column

By |October 15th, 2017|File Repair|0 Comments

How can I tell which Sage 100 Contractor databases are available on the server?

Resolution:

The Database Connections Status window shows you which databases you can use with SQL Server.  Moreover, it explains why you cannot use certain databases, and suggests possible remedies.

To use the Database connections Status window:

Start Sage 100 Contractor (SQL)
In the Connect to SQL Server dialog, hold down the Shift key and click the [Connect] […]

By |October 15th, 2017|File Repair|0 Comments

Does Sage 50 have any form of notification for employee age in regards to tax exemptions?

Resolution:

While employee date of birth information can be maintained on the employee record, currently there is no notification system in the program to perform this function

By |October 15th, 2017|File Repair|0 Comments

The SQL Server instance you are trying to connect to is not running on this computer. You must enter the name of a local SQL Server Instance

Resolution:

Can they use RDP session?  Database Administration must connect to a local SQL Server Instance.

By |October 15th, 2017|File Repair|0 Comments