Below, we explain how to install SQL Server on Windows Server. This tutorial uses Windows Server 2016 and SQL Server Standard Edition 2019 Spanish.
Information
If you need a SQL license, you can purchase one through us. You can check the Microsoft SPLA License Prices and contact us so we can copy the ISO to your server.
If you encounter an error during installation, first check the Problems and Errors section below. If your error is not listed there, contact us so we can resolve it.
Canceling licenses
Important
If you purchased your SQL license through us, please remember that to cancel it, you must contact us by email and formally request cancellation, specifying the server name or IP address, and wait for our confirmation. We recommend requesting cancellations before the end of the month, as licenses are billed at the beginning of the month.
Installing SQL Server on Windows Server
Once one of our technicians has notified you that the ISO has been copied to your server, simply access the server and mount the ISO.
Next, run the setup.exe file as an administrator:
The installer will start, and you will need to click Installation > New SQL Server Stand-Alone Installation or add features to an existing Installation:
Then continue with the installation:
Select the features you need:
Select the Instancia predeterminada option and leave the default name.
Siguiente.
In this section, specify the server configuration and add the user who will administer the SQL server:
Next, start the SQL Server installation:
Once the installation is complete:
You should now have SQL Server running on your server.
Installing SQL Server Tools (Optional)
To install SQL Server Tools, you must have Visual Studio installed. During its installation, you can choose to install SQL Server Tools:
Follow the instructions on the website and, after downloading Visual Studio, select the package you need:
Then install SQL Server Management Studio:
Problems and Errors
Below is a summary of possible errors and how to resolve them.
Error 0x858c001b when installing SQL Server
This error occurs because the language of the SQL image does not match the operating system language. You will need to change the server language by following these instructions: How to change the language in Windows 2012 and Windows 2016 or How to change the language in Windows 2019.