Client unable to establish connection.. error when you configure ‘max server memory’ to a low value

  When you inadvertently set SQL Server’s ‘max server memory’ to a very low value, you may experience one or more of the following symptoms: SQL Server cannot be started (from a tool like configuration manager) and the following message is logged in the SQL error log:”An internal query can’t be executed due to inefficient…


Excel 2016 PivotTable timeout error on SSAS data source after 1 minute

Excel 2016 PivotTable report may generate an error message after running the report for 1 minute. The connection timeout was exceeded. This problem only happens if you have the build number 11.0.9167.412 of the SSAS OLE DB Provider shipped in Excel 2016 update. You can check the following files and see if the version is…

0

Excel 2016 PivotTable timeout error on SSAS data source after 1 minute

Excel 2016 PivotTable report may generate an error message after running the report for 1 minute. The connection timeout was exceeded. This problem only happens if you have the build number 11.0.9167.412 of the SSAS OLE DB Provider shipped in Excel 2016 update. You can check the following files and see if the version is…

2