Analysis, Reporting and Integration Services were missing from the Features page while installing SQL Server. The cause was missing MSI files in my setup media.
SQL SERVER – Installation Error – Unable to Open Windows Installer File – 2147286960
Installing SQL Server 2016 failed with “Unable to open Windows Installer file” and error -2147286960. Here is what caused it and how I fixed the setup.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing
A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.
SQL SERVER – Error 1324. The folder path ‘Program Files’ contains an invalid character.
Error 1324. The folder path ‘Program Files’ contains an invalid character. Let us fix the error with the help of the solution in the blog.
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Adding Analysis Services to SQL Server 2014, the Installation Wizard hung on “Please Wait” at feature selection, even after my lunch. Here is what fixed it.
SQL SERVER – Installation Error: The Cluster Resource is Not Available. (Exception from HRESULT: 0x8007138E)
Patching SQL Server on a cluster failed with: The cluster resource is not available (HRESULT 0x8007138E). Here is how the Summary.txt file led to the fix.
SQL SERVER Data Tools – SSDT for Visual Studio 2017 Installation Error 0x80070002: Error 0x80070002: Failed to Acquire Payload
SSDT for Visual Studio 2017 would not install on my new demo machine. Here is the Installation Error 0x80070002 I found in the setup log in the TEMP folder.