In a previous post, we learned about installing Db2. Now I'm installing SQL Server.
Therefore, I've downloaded Windows 2019 Standard (Evaluation) from this link. (Evaluation 180 days).
And then I've download SQL Server Developer Edition from here.
So I've uploaded the SQL Server installation file to the Hyper V - VM.
To install SQL Server I double click on SQL2019-SSEI-Dev.exe to start the installation so we will see the following screen, where I click on Custom.
Media location. I'll keep that. So I click Install.
And the download of the packages starts. So access to the internet is required to download these packages.
Click on Installation.
and then on New SQL Server stand-alone installation or add features to an existing installation.
Developer Edition is selected already so click Next.
Read :-D, accept the license terms and click Next.
There is 1 Firewall warning that can be ignored for a Lab @ Home. Click Next.
Select the following Instance features.
- Database Engine Services.
- Client Tools
- Integration Services.
- Client Tools Backwards Compatibility.
It is recommended to install SQL Server on another drive, but since this is a sandbox and there is only one disk, I will install it on C:\.
I'll keep the default SQL Server instance name MSSQLSERVER.
This is a single instance installation so I'll keep the default service accounts. So I click on Collation.
One thing to notice here is, if you read the Microsoft Oficial documentation about collation, you will read the following...
Default server-level collation is SQL_Latin1_General_CP1_CI_AS.
However, as you can see on the following screenshot mine is Latin_General_CI_AS
So why is that? It is because my Windows System locale is English UK and the collation for this is Latin_General_CI_AS.
This is specified here.
During SQL Server setup, the default installation collation setting is determined by the operating system (OS) locale.
So once we've confirmed the SQL Server collation value, we can can continue the installation.
Note: Once installed, SQL Server instance collation cannot be changed unless the system databases are rebuilt.
Next we can set the authenication mode. Click Next.
- Windows Authentication mode.
- Mixed Mode
Here we can configure data directories if, for example, we have more than 1 disk. In my case, I've just created a different folder for the backup directory. Click Next.
Here we can configure TempDB. I'll leave this all by default, but here you can find more information about how to do it properly.
This part is to set max degree of parallelism (MAXDOP). Here more information. I'll leave 1 as I only have 1 CPU.
Here we can set the Memory of SQL Server. I only have 4 GB of Memory, but in the future, I'll add more memory so, for the time being, I'll leave it as it is. This parameter can be changed later. Click Next.
Well, finally we are ready to install. It is a good practice to review the summary.
All this configuration will be saved in the following file, therefore, in the future, wecan install SQL Server using a configuration file.
C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200301_192235\ConfigurationFile.ini
Then we should see all features with status Succeeded.
Just to be sure the installation lets check the Summary.
SQL Server Management Studio (SSMS) is not included anymore as part of the instance features, so I'll leave that for another day.