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

Microsoft 365 Copilot for Outlook | Manage Email Smarter

Joel Trinidad

|

November 7, 2025
The Email Overload Holding Teams BackFor most of us, email isn’t just communication—it’s command central. But the volume is relentless. Between updates, requests, and follow-ups, your inbox can feel like its own full-time…

Copilot for Power BI: Your Personal Data Assistant

Joel Trinidad

|

October 30, 2025
Microsoft has been steadily adding AI features to their broad range of business products, and Power BI is no exception. Copilot can be utilized to take full advantage of your…

How to Migrate Fixed Assets from Dynamics GP to Business Central Smoothly

George Rios

|

October 28, 2025
PlanningWhen working on a migration of Dynamics GP fixed assets to Business Central, you will want to identify which fields you want to transfer from one system to another. It…

Introducing the BCS Support Portal

TJ Sedarski

|

October 23, 2025
At Bond Consulting Services, we know how important it is to get help when you need it, and to know where things stand once you’ve asked. That’s why we are…

Announcing Unlimited Support for Dynamics 365

TJ Sedarski

|

October 17, 2025
It's like having an in-house Dynamics team - without the overhead A Smarter Way to Get Support for Microsoft DynamicsWe've listened to your feedback and we're making support simpler, faster, and…

Meet Bond Consulting at Community Summit NA 2025

TJ Sedarski

|

October 9, 2025
Discover how we’re helping growing companies streamline operations and accelerate ROI with Microsoft Dynamics 365.Community Summit North America is right around the corner! From October 19–23 in Orlando, FL, business…