Sage Construction & Real Estate

We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

When users log in, getting warning about backups not being run in X amount of days. Looked at logs and seeing the following: 2024-03-11 01:00:05 [Company File Name] An error occurred running the nightly maintenance and backup 2024-03-11 01:00:05 …

I'm getting the error that is attached when I run the Sage Payroll Archive for 2022. It seems there's a file already there, however when I checked I don't see it. Any thoughts? Thanks!

History of Question: * The SAGE 100 Con database had over 30 companies in it and performance was "sluggish." * Backups were made of all companies and copied to another server for safekeeping. * A 2nd SQL instance was created and all companies between…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

I want to make a copy of my Sage 100 DB so we can start user acceptance testing. When I copied my LIVE database that contains financials and job, etc, my copy doesn't have any financials. It's like the copy function only selected certain tables (vendor…

Sage 100 Contractor nightly back up has failed every night since we did our archive of prior year general ledger. How do find out what the problem is so that we can get the backups performing successfully again?

Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7): Common Tasks - Tools - File Tools - Backup The "ts.ctl" file is in use when we try to use file tools to backup our data. The knowledgebase leads you to various methods…

Every time I open Sage Contractor 100 (version 21.3.39.0) I get an error saying that the Sage file did not backup. Though when i check the backup schedule it is set to backup every night. And i can see the backup files in the backup folder. Is this…

Sitting down to do all the year end stuff and I updated sage and upgraded my databases before closing the payroll year. Will this mess me up? What if anything should I do?