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

Procedure:

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



Resolution

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

https://www.microsoft.com/en-us/download/details.aspx?id=50402

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