How to install SSMS from command line? A client’s silent install failed: the specified value for setting MEDIALAYOUT is invalid. Here is the fix.
Xpstar.dll Could Not Load in SQL Server: Error 17750 and Reason 126
An xpstar.dll loading error can name a DLL that is already present, because error 17750 with reason 126 usually points at a dependency. This post reads both parts of the error, checks the file, the VC++ runtimes and the loaded modules with tested commands, and explains why copying DLLs between machines is not a repair.
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
A service pack failed with: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Here is what I found.
SQL SERVER – Management Studio Missing – SSMS 2014 not Installed with SQL Server 2014
SSMS 2014 not installed after a SQL Server 2014 setup? The Management Tools feature was never selected. Here is how the discovery report showed it.
Specified Driver Is Invalid in SQL Server Setup: Error 0x84BB0001
The specified driver is invalid error stopped a SQL Server 2012 installation with code 0x84BB0001. The real clue sat in Detail.txt, in the performance counter files, and a fresh copy of the media fixed it. This post shows how to read the logs, check the counter files and confirm the media.
Number of Cluster Nodes Error: Add Node Fails on Enterprise Edition
The number of cluster nodes error stopped a client from adding a second node, even on Enterprise edition. Detail.txt showed the edition as Invalid. The file setup uses to read the edition was missing from the Shared folder.
SQL SERVER – Event ID 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name)
A named instance would not start, and Event ID 26 said the install was corrupt or tampered with (Error Getting Instance Name). Here is what I found.






