SQL installation and parching are the processes which every DBA has to do. Some smart DBAs do this via script and some go with a manual approach. When it fails, it is fun to debug it because you have to take help from internet to find possible causes and solution. In this blog, we would learn about how to fix error Unable to open Windows Installer file -2147286960.
One of my blog readers contacted me and informed that he is getting the same error as mentioned in below blog SQL SERVER – Service Pack Failure: MissingRegistryKeyException. Note that it had the same error message, but that did not help him here. In this blog, we would learn how to fix MissingRegistryKeyException while installing SQL Server service pack. Let us fix the error registry key is missing.
Some error messages are so interesting that it takes a lot of time to get the right solution. One of the errors which I faced during SQL Cluster installation is so common that my search was showing various solutions which were not applicable to me. After spending a lot of time, I was able to find the real cause. In this blog, we would learn about SQL Cluster installation error “The folder path ‘Program Files’ contains an invalid character.”
Here is one of the situations which I encountered with SQL Server 2014 on Windows Server 2012 R2. I wanted to add “Analysis Services” features to an existing installation. I came up with the feature selection screen on SQL setup and pressed next it hangs with “Please Wait”. I click on it and went for lunch, when I came back, it was still in the same state. Let us learn how to fix the issue related to Installation Wizard Hang Forever.
SQL SERVER – Installation Error: The Cluster Resource is Not Available. (Exception from HRESULT: 0x8007138E)
Sometimes DBAs get into a situation where they don’t know what the next steps is to fix the issue. Here is one of the situation where DBA contacted me with below error in installing a patch for SQL Server in clustered environment. If you don’t know then I can tell you that I do provide quick consultancy. You can read more here On Demand (55 minutes). In this blog post we will learn about how to fix an installation error.
SQL SERVER Data Tools – SSDT for Visual Studio 2017 Installation Error 0x80070002: Error 0x80070002: Failed to Acquire Payload
I was trying to build a new machine for my demo purposes and wanted to install everything possible related to Data. SQL Server Data Tools (SSDT) is also needed to complete the package. I downloaded it from here.
I have said this many time earlier at various forums and I can still say that – “with my current consulting work, I am learning at least one new thing every day.” This is one of the reason why I love my work! In this blog I am going to share an interesting fact which was shared with me by my customer – how to restart SQL Azure database?