Before installing the SQL server, check the system requirements for the specific SQL server edition at https://msdn.microsoft.com/en-us/library/ms143506(v=sql.140).aspx.
Ensure the existing SQL server supports updates. For a list of supported upgrade scenarios, see https://msdn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017.
Note: Back up all your databases.
Note: Some warnings about the firewall might be displayed. Despite the warnings, you can still continue with the installation. Depending on the situation, it is not necessary to close the installation wizard and restart. If all the checks are passed, the Global Rules screen will close automatically and the following screen will be displayed:
Note: Depending on the situation, it is not necessary to close the installation wizard and restart.
Note: If Reporting Services is installed, this will be removed during the upgrade. Before you continue, back up your report server database, and your encryption key. Furthermore, Reporting Services for SQL Server 2017 and 2019 is done via a separate installation, and you have to migrate the reports. For more information, see How-to: Installing SQL Server Reporting Services (SSRS).
Once you have made a backup of the report server database, and the encryption key, you can select the Uninstall Reporting Service check box, and click Next to continue.
Note: When you have a firewall, you have to configure the firewall to allow connections with SQL Server 2017 or 2019. The default port for SQL Server 2017 and 2019 is 1433. The SQL browser used UDP port 1434.
The next step is to install SQL Server Management Studio. SQL Server Management Studio is an application for managing the SQL Server. With SQL Server Management Studio, you can create and restore backups, change database settings, and give users SQL server rights.
Note: If you already have an older version of SQL Server Management Studio installed, it is advisable to install the most recent version of SQL Server Management Studio. The new version will be installed side-by-side with the previous versions so both the versions can be used.
The following screen will be displayed:
Click Install to start the installation.
During the installation, you can follow the progress of the installation. The following screens will be displayed. The installation can take some time.
When the installation is completed, the following screen will be displayed. You have to restart the system to complete the setup.
Note: You have to change the Compatibility level for every company database.
For optimal performance, it is important to update the indexes and statistics. To create these optimization jobs, you can use the ESI tool. For more information, see Exact System Information (ESI) help file.