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