00. Installazione Progex su NUOVO SERVER

  1. Download and Install (RunAsAdministrator) SQL Express
  2. Al termine (su prompt finale di install precedente)
    download and Install (RunAsAdministrator) SSMS (SQL Server Management Studio)
  3. Segui step copiati da https://www.sqlshack.com/how-to-install-sql-server-express-edition/

    Installing SQL Server Express edition

    After the completion of the download, the SQL Server Installation Center will meet us. In this screen, besides installing the SQL instance, we are able to install SQL Server Reporting Service, SQL Server Management Studio or SQL Server Data Tools and we can also upgrade the installed version of SQL Server.

    Now, we will select the New SQL Server stand-alone installation or add features to an existing installation option to start the installation:

    SQL Server Installation Center

    We will accept the license terms and other details on the Licence Terms screen and click Next:

    SQL Server Setup Licence Terms screen

    The Global Rules screen will be launched and, the SQL Server Setup will be checked the computer configurations:

    SQL Server Setup Global Rules screen

    The Product Update screen checks the latest updates of the SQL Server Setup and if we don’t have an internet connection, we can disable the Include SQL Server product updates option:

    SQL Server Setup Product Updates screen

    In the Install Rules screen, the potential issues will be checked by SQL Setup that might be occurred during the installation. We will click the Next button and skip the next step:

    SQL Server Setup Install Rules screen

    In the Feature Selection screen, we can select the features which we want to install. For this installation, we will disable the following features:

    • Machine Learning Services and Language Extensions
    • Full-Text and Semantic Extractions For Search
    • PolyBase Query Service for External Data
    • LocalDB

    At the same time, we can specify the installation path of the SQL Server through the Instance root directory option:

    SQL Server Setup Feature Selection

    In the Instance Configuration screen, we will give a name to the SQL instance but we will not change the default name of the installation. Click the Next button:

    SQL Server Setup Instance Configuration screen

    In the Server Configuration screen, we can determine the startup type of the SQL Server Database Engine and SQL Server Browser services. We will not change the default options:

    SQL Server Setup Server Configuration screen

    At the same time, we can determine the service account of the SQL Server Database Engine and SQL Server Browser. In the Collation tab, we can customize the Server collation option of the SQL Server:

    SQL Server Setup setting the collation

    In the Database Engine Configuration screen, we will specify the authentication mode of the SQL Server. We have two options on this screen.

    In the Windows authentication mode, the SQL logins are controlled by the Windows operating systems and it is best practice to use this mode.

    In the Mixed Mode, the SQL Server can be accessed with both Windows authentication and SQL Server authentication. For this installation, we will select the Mixed Mode option, so we will set the password of the sa login of the SQL Server and we will also add a windows login. We can directly add the current windows user to the windows through the Add Current User button:

    SQL Server Setup Database Engine Configuration

    In the Data Directories tab, we can set the default directory of the database and backup files:

    SQL Server Setup setting database files directories

    In the TempDB tab, we can set the number and size of the tempdb files. For this installation, we will not change these settings and click the Next button:

    SQL Server Setup setting the tempdb number

    Tip: If you predict over workload on the TempDB database for your SQL Server, you can change the number of the tempdb files. Microsoft recommended the following rule as a best practice:

    As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical processors.”

    In the Installation Progress screen, we can follow the progress of the installation:

    SQL Server Express Installation Progress screen

    In the final step, the Complete screen meets us and it gives information about the result of the installation:

    Compete screen of the SQL Server Setup

    Test connection to SQL Server Express

    After installing the SQL Express, we are able to connect to the SQL Server Database Engine over the SQL Server Management Studio. The following server notation can be used to open a connection to SQL Engine:


    Test connection to SQL Server Express through SQL Server Management Studio

    At the same time, we can test the connection SQL Server Engine through the command prompt.

    For the Windows authentication:


    For the SQL authentication:


    Checking SQL Server Express connection status

    How to enable TCP/IP connection for the SQL Server 2019 Express edition?

    We can use TCP/IP protocol to connect the SQL engine after the installation but this protocol will be disabled by default. To enable the TCP/IP protocol:

    • Open SQL Server Configuration Manager and find the Protocols for SQL Express option
    • Enable the TCP/IP protocolEnable TCP/IP connection for the SQL Server
    • Right-click to TCP/IP and select Properties menu item
    • Change TCP Port to 1433 under the IPAll tabEnable TCP/IP protocol of the SQL Server Express
    • Restart SQL Server (SQLEXPRESS)Restart SQL Server


    In this article, we learned how to install SQL Server Express step by step with details. By following these steps, we can easily complete the installation process of the SQL Server 2019 Express edition.

    See more

    To boost SQL coding productivity, check out these free SQL tools for SSMS and Visual Studio including T-SQL formatting, refactoring, auto-complete, text and data search, snippets and auto-replacements, SQL code and object comparison, multi-db script comparison, object decryption and more

Print Friendly, PDF & Email

Leave a Reply

  • AdminDocs on July 30, 2020 @ 15:38:11

This post was created by Alessandro Orsenigo on 30 July 2020.