I would share my experience with SQL Server Management Studio (SSMS) install error – Setup is blocked due to another install currently running.
Recently, I was trying to uninstall SQL Server via command prompt and faced an interesting situation. In this blog, we would learn about the error “The syntax of argument “/ACTION” is incorrect” and how to fix it.
SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations
During one of my consultancy related to Always On availability group deployment, I faced an interesting issue. They wanted to install two standalone SQL Server instances on both nodes of the Windows Server 2008 R2 cluster for a specific reason. Interestingly, they informed that this used to work fine with SQL server 2008 R2 but in SQL server 2014 is failing with an error.
I checked the summary file and found the message about install error.
SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group
As a part of my consulting job, I do work with clients who wanted to deploy AlwaysOn availability group. Sometimes there are some simple errors which are encountered, but new DBAs are not aware of such things. In this blog we would talk about one of such error.
SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List
Recently I came across an issue where I was not able to fix directly. My client reported below error in Skype, which is related to a service pack.
SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation
Have you come across a situation where setup is taking many hours while navigating from one screen to another in clustered environment? Have you ever waited for many hours watching following message related to slow installation wizard on cluster?
SQL SERVER – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore
One of my clients reported that he is trying to apply security patch for SQL Server clustered instance and it was failing. Since this is SQL 2005 instance, there is no official support available from Microsoft at this point. So, they contacted me. I asked to share setup logs and found a very interesting note.