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.
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:
Depending on the situation, it is not necessary to close the installation
wizard and restart.
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.