Key Enhancements and Upgrade Guide
The latest Sage 100 Contractor update, version 26.2.241, brings essential improvements designed to streamline project management and enhance overall performance. If you’re running this software, it’s crucial to keep your system updated to benefit from the newest features and to maintain compliance with software security requirements. One of the most significant changes in this version is the requirement to upgrade Microsoft SQL Server to version 2019.
Why Upgrade to Microsoft SQL Server 2019?
Microsoft SQL Server 2014 reached its end of life in July 2024, meaning that it no longer receives security updates or technical support from Microsoft. This exposes your business to potential security vulnerabilities and compliance risks. Sage 100 Contractor version 26.2.241 requires SQL Server 2019 to ensure continued security, performance, and support. SQL Server 2019 offers enhanced data security features, better performance, and modern analytics capabilities that are vital for efficient project management.
If you’re still using SQL Server 2014, the upgrade to SQL Server 2019 isn’t optional—it’s necessary for continued Sage 100 Contractor support. Failing to upgrade will not only leave your database unprotected but could also result in unexpected downtime and performance issues.
Sage 100 Contractor 26.2.241: Key Features and Improvements
Sage 100 Contractor version 26.2.241 introduces several improvements designed to optimize your construction business workflows:
- Improved Performance: Enhancements in database interaction speed up project data retrieval and report generation.
- Enhanced Security Features: Integration with SQL Server 2019 provides more robust security protocols, ensuring better protection for sensitive financial and project data.
- Bug Fixes and Usability Enhancements: Several minor issues have been addressed to provide a more seamless user experience.
These updates make version 26.2.241 a vital upgrade for construction companies relying on Sage 100 Contractor for their operations.
Step-by-Step Guide to Updating Sage 100 Contractor to Version 26.2.241
To help you stay compliant and take advantage of the latest features, here’s a simplified guide to updating your Sage 100 Contractor to version 26.2.241.
1. Install Sage 100 Contractor Version 26.2.241 on Your Server
- First, download the latest version of Sage 100 Contractor from the Sage support portal.
- Run the installation package on your server and follow the on-screen prompts to complete the process. Ensure all Sage-related services are stopped during the installation.
2. Upgrade Microsoft SQL Server to Version 2019
- Since this update requires SQL Server 2019, make sure to first back up all your databases.
- Uninstall SQL Server 2014 or install SQL Server 2019 alongside it, depending on your preference.
- Restore your databases to SQL Server 2019 and verify that everything is working correctly before proceeding.
3. Update Companies in Database Administration
- After installing Sage 100 Contractor and upgrading SQL Server, open the Sage Database Administration tool.
- Run the “Update Companies” option to ensure all your databases are updated to work with the latest version of Sage and SQL Server.
4. Update Workstations
- Finally, update the Sage 100 Contractor client on each workstation connected to the server.
- This can be done by navigating to the Sage 100 Contractor installation file stored on the server and running it on each workstation to ensure compatibility with the new version.
Conclusion
Sage 100 Contractor version 26.2.241 is a critical update for construction companies looking to enhance their project management and financial processes. The requirement to upgrade Microsoft SQL Server to version 2019 is a significant shift, but it provides long-term benefits in terms of performance, security, and compliance. By following the outlined steps, you can smoothly upgrade your system and continue operating without disruption.
For more detailed instructions or support, always refer to Sage’s official documentation or contact your Sage Implementation Consultant.