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

What 200% ROI from Business Central Really Looks Like

Jackie Gant

|

April 13, 2026
Where ROI actually shows up from finance efficiency to operational visibility Forrester says Business Central delivers 200% ROI. But what does that actually look like in practice? A recent Total Economic…

Do You Need Avalara for Business Central? A Practical Guide

Clayton Jones

|

April 10, 2026
Webinar: Sales Tax Works…Until It Doesn’t: Tax Complexity at Scale for Product CompaniesMay 5 @ 10:00 AM PT/1:00 PM ETRegister Now!Most companies focused on making, distributing, or selling products manage…

What Is Work IQ? How Microsoft Copilot Moves from Data to Context

Zoltan Orban

|

April 9, 2026
Work IQ is one of those terms that can sound more complex than it really is. Most AI tools today work by pulling from available data. They can read records, summarize…

What’s Rolling Out in Business Central 2026 Release Wave 1

Lupe Haro

|

April 7, 2026
The latest release of Microsoft Dynamics 365 Business Central is now rolling out, with updates scheduled between April and September 2026. When Microsoft first introduced this wave, the themes were clear:…

Where Microsoft Copilot Fits into the Workday

Zoltan Orban

|

March 31, 2026
There is a lot of marketing around Copilot, but in practice, its value often shows up in small, everyday tasks. It is not a replacement for expertise, but it can…

What Copilot “Cowork” Means for Business Users

Zoltan Orban

|

March 26, 2026
Microsoft recently introduced Copilot Cowork, and I wanted to take a closer look at what it represents in practical terms, especially for business users working across Microsoft 365 and related…