One of my client was unable to install SQL Server 2014 on a Windows 2012 Cluster. They were using mount points with below the structure. Let us learn about installation error.
SQL SERVER – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.
There are many DBAs who like to automate the deployment of SQL. It is not fun to use wizard in all the installations. Imagine that setup media is kept in a remote share and all you need to do is provide a batch file to run and it would take care of installation. Let us learn How to Install SSMS From Command Line?
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 – Management Studio Missing – SSMS 2014 not Installed with SQL Server 2014
Recently I got a message on Skype about SSMS.
Hi Pinal, Need quick suggestion. I am unable to find ssms.exe after installation of SQL Server. Do you know how I can install it?
Initially I thought that since SQL Server 2016 doesn’t come with SQL Server Management Studio, this would be an expected behavior. So, I shared my blog to him.
SQL SERVER – Installation Error – The Specified Driver is Invalid
In this blog post we are going to learn about Installation Error – The Specified Driver is Invalid.
SQL SERVER – Event ID 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name)
While trying to start SQL Service for a named instance, I got an error message related to event id 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name).
SQL SERVER – Discovery Report – How to Find Information About Installed Features?
Many times, we need to find information about the various features / version of SQL Server installed on a machine. If you ask a DBA, he can provide you information by looking at services and tell what all are installed. He might run some WMI/T-SQL queries to list the services of SQL Server and their versions. Let us learn about the Discovery Report.