Microsoft Copilot $21 now $18/user/month + 1 month free

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

Dynamics GP to Business Central: Migration Overview & Considerations

Jennifer Ryan

|

February 12, 2026
Microsoft Dynamics GP support sunsets on December 31, 2029. After that date, product enhancements, tax and security updates, and mainstream support will be discontinued. As a result, many organizations running…

Why Waiting for Perfect Data Means Never Starting with AI

Zoltan Orban

|

February 10, 2026
This post is part of our Microsoft Copilot, Explained series, which starts with everyday productivity tools like email and meetings before expanding into broader workflows and AI agents."Our data isn't…

Just Get Started: How Teams Are Actually Beginning with Microsoft Copilot

Clayton Jones

|

February 5, 2026
Getting started with Microsoft Copilot doesn't require perfect data, months of planning, or enterprise-scale resources. Small and medium-sized businesses running Microsoft 365 and Dynamics 365 Business Central are finding that…

Why Copilot in Outlook Beats Standalone AI Email Tools

Joel Trinidad

|

February 4, 2026
This post is part of our Microsoft Copilot, Explained series, which starts with everyday productivity tools like email and meetings before expanding into broader workflows and AI agents.Tools like ChatGPT…

Microsoft Copilot vs Copilot Chat vs Full Copilot

Joel Trinidad

|

February 3, 2026
This post is part of a series, Microsoft Copilot, Explained, which begins with productivity tools and building toward business workflows and AI agents. If you’ve been hearing more about Microsoft Copilot…

Microsoft Copilot for Operations vs Executives: Same Tool, Different Value

Zoltan Orban

|

January 29, 2026
Most conversations about AI in business stay at a high level: “It will transform how we work.”That might be true, but as someone who spends most days in the details—fixing…