When attempting to open an estimate, the following error message is presented.

Message Window Title: Open Estimate Failed

Message: This server does not exist or is offline.

Message Body:

The estimate '%name of estimate%' cannot be opened because a failure occurred establishing an initial connection with the '%name of estimate%' server. Verify that all connection properties were entered correctly.

Click [Show Details] for more information.

SQL State: 08001

Native Error: 10054


Line: 0

Source: Microsoft SQL Server Native Client 11.0

Error message record 1: TCP Provider: An existing connection was forcibly closed by the remote host.

SQL State: 08001

Native Error: 10054

Source: Microsoft SQL Server Native Client 11.0

Error message record 0: Client unable to establish connection

Connection failures can range from the SQL service being shutdown, the network, or Windows/SQL permissions. See the SQL Server Guide documentation for more information.

Press CTRL+C to copy the content of this window.

Screenshot of the error message

Another example


From the workstation/server where Sage Estimating is installed, open ODBC 64-bit by typing ODBC from the start menu and selecting ODBC Data Sources (64-bit).

Select the Drivers tab, and note the version of the SQL Server Native Client 11.0 driver. {v2011.110.5058.00 - 05/15/2014} 

With a browser, navigate to the Microsoft download page for the latest Native Client.

Download link: Microsoft SQL Server 2012 Native Client - QFE


Complete the installation wizard to install latest Native Client driver.

With the Native Client driver updated, open ODBC Data Sources (64-bit) and confirm the updated driver version. {v2011.110.7001.00 - 08/15/2017}

The Sage Estimate should now open properly.

See also article Install Error for Sage Estimating 21.1 SQL Server Native Client