AI vs Automation for Manufacturers | June 16

March 8, 2024

Why are my Dynamics GP database backups failing?

After the “sa” login has been reset, there is important Dynamics GP information that needs to be validated to prevent the Dynamics GP SQL Server database backups or other SQL Server jobs from failing.

Within SQL Server Management Studio, you will want to expand the Management folder, then expand the Maintenance Plans folder; within the Maintenance Plans folder you will see the current plans listed. If you double-click the plan, you will see the plan properties similar to the one captured below. 

Click on the Manage Connections option and then select Local Server Connection to display the Connection Properties window.

If you are using the ‘sa’ login to establish the connection to the SQL Server, you will need to update the ‘sa’ password.

If you use the Windows NT Integrated Security option, you do not need to change anything.

Click the OK button after updating the ‘sa’ password.

Close the Maintenance Plan by clicking the X next to the plan name (circled below) and save the changes that have been applied.

This process will need to be repeated for any other SQL Server jobs that are listed within the Maintenance Plans folder.

For any clarification on this process, or questions about Dynamics GP in general, please reach out to us at Sales@BondConsultingServices.com or visit our YouTube channel for helpful recorded walkthroughs and product tutorials. Alternatively, you can click here to schedule a free consultation with one of our Dynamics expert consultants.

Other articles

Microsoft’s New Expense Agent Simplifies Business Central Expense Reports

Clayton Jones

|

May 28, 2026
Most expense management improvements over the years have been incremental. Better OCR. Faster receipt capture. A mobile app instead of a desktop form. The underlying workflow stayed the same: employee…

When Does Dynamics 365 Business Central Need Power BI?

Clayton Jones

|

May 20, 2026
Thanks to Dynamics 365 Business Central, your processes have been streamlined, your finances smartly managed, and your sales cycle enhanced. Your business has been running so smoothly that you’ve finally…

From Power Automate to Microsoft Copilot: Where Workflow Automation Ends and AI Assistance Begins

Zoltan Orban

|

May 19, 2026
Webinar: AI or Automation? How to Know What Your Manufacturing Business Actually NeedsJune 16 @ 11:00 AM PT/2:00 PM ETRegister Now!Most operational problems are not as simple as “add AI.”…

Project Online Retirement: What Businesses Need to Do Before September 2026

Daniel Dix

|

May 7, 2026
For years, Project Online, Microsoft’s cloud-hosted project and portfolio management (PPM) solution, built on SharePoint Online has played a central role in enterprise environments, supporting everything from detailed scheduling to…

Microsoft Dynamics 365 Business Central Implementation Packages

Clayton Jones

|

April 29, 2026
If you’re like 99% of our clients, you’re trying to rein in the soaring costs of technology. It’s a delicate balancing act. On the one hand, you understand that you…

Doing More With the Team You Have: What BCS is Changing with AI

Jackie Gant

|

April 29, 2026
AI is everywhere right now, but what feels different is the pace. For the first time in a long time, small and mid-sized businesses are adopting new technology just as quickly…