Fixing 'Failed to Create Address Book Database' Error in SQL Database

Fixing 'Failed to Create Address Book Database' Error in SQL Database

Background

When utilizing Sage Estimating, users might occasionally encounter an error message that reads, "Failed to Create Address Book Database (SQL Database Pending Recovery)." This problem can manifest unexpectedly, even if the software was previously operating without any issues.

Cause

After examining the issue with SQL Server Management Studio (SSMS), it was found that the address book database was in a 'Pending Recovery' state. This happened as a result of a recent Windows update on the server, which unintentionally caused the estimating database to go offline.

Solution

1. Taking the Database Offline
  1. In SSMS, locate the database experiencing the issue.
  2. Right-click on the database.
  3. Navigate to 'Tasks' and select 'Take Offline'. Wait a few seconds for this process to complete.
2. Bringing the Database Online
  1. Right-click on the same database.
  2. Go to 'Tasks' and choose 'Bring Online'.
3. Verification
  1. After completing these steps, the database should return to normal functioning.
  2. All users should regain access to the estimating software.

Conclusion

This approach successfully addresses the 'Failed to Create Address Book Database' error. It involves manually setting the database to offline and then reactivating it online. This step is crucial for recovering the database from its 'Pending Recovery' state, which is likely a consequence of the recent Windows updates on the server.


    • Related Articles

    • Resolving 'Open Estimate Failed - Server Offline' Error in Sage Estimating

      Issue: See the screenshot below of the 'Open Estimate Failed - Server Does Not Exist or is Offline' error message. Resolution 1. From the workstation/server where Sage Estimating is installed, open ODBC 64-bit by typing ODBC from the start menu and ...

    • Failed to Post Checks Due to Inactive Entity Record

      While in the Check screen in Payroll, the user received the following error when clicking on the Actions - Post option for payroll checks: Sage Intacct Payroll Posting Error: "Failed to post checks - Entity Top Level did not have an Active Record" ...

    • Unable to Connect to SQL Instance

      Sage Estimating SQL relies on SQL Server connections to facilitate communication between the server and the client. However, when a firewall exists between the client and the server, the firewall must allow incoming traffic to the server on UDP Port ...

    • Resolving Aatrix Error When Generating Certified Payroll Report in Sage 300 CRE

      Issue Users of Sage 300 CRE version 23.1 may encounter a termination error message when attempting to generate any certified payroll report in Sage 300 CRE Payroll, under Tasks, Federal eFile and Reporting, or State eFile and Reporting. The error ...

    • How to Create a Business User in Sage Intacct

      Creating a business user in Sage Intacct is a straightforward process, essential for managing your team's access to various functionalities within the system. This process is slightly different from creating an admin user, focusing more on ...