New Year, Smarter Work: Get 1 Month Free Copilot | Now $21/User.

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.

Share On: 

Other articles

From Frustration to Future-Ready: What Growing Distributors Need to Know About Their Systems

Jennifer Ryan

|

January 8, 2026
I spent years on the other side of the table — inside distribution businesses, closing books at midnight, trying to reconcile inventory that never quite matched, and juggling spreadsheets that…

How Miron Violetglass Scaled 40% Without Adding Headcount

Jennifer Ryan

|

January 6, 2026
Every distributor reaches a point where growth exposes the cracks: too many spreadsheets, too much manual work, and not enough visibility. Miron Violetglass hit that moment and what happened next…

Why Distribution Hand-Offs Break (and How Connected Operations Fix Them)

Jennifer Ryan

|

December 18, 2025
Inside distribution companies, most problems don’t come from bad people or broken intentions. They come from gaps in the hand-offs between teams.As a Controller, I used to think our issues…

Unlocking Insights: Power BI Integration with Dynamics 365 Business Central

Joel Trinidad

|

December 16, 2025
As businesses increasingly rely on data to drive decisions, Microsoft continues to enhance the synergy between Dynamics 365 Business Central (BC) and Power BI. With the release of Business Central Version 26, users now…

The Spreadsheet Trap in Distribution: Why You Lose Control Without Realizing It

Jennifer Ryan

|

December 11, 2025
Let me start with a confession: I love a good spreadsheet. They’re flexible. Fast. Familiar. Elegant.But here’s the problem no one talks about: Spreadsheets eventually become the system. And that’s…

How to Connect Power Pages & D365 Customer Engagement for a Seamless Self-Service Experience

Marisa Mini

|

December 4, 2025
Power Pages for Customer Service, Field Service, and Sales PortalsCreating a seamless, modern customer experience starts with reducing the back-and-forth. If your customers (or vendors, partners, applicants, members, etc.) still…