Install Microsoft SQL Server 2019 - Intergraph Smart 3D - Installation & Upgrade - Hexagon

Intergraph Smart 3D Installation

Language
English
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
13.1
  1. Start the Microsoft SQL Server setup program.

  2. From the Planning page, select System Configuration Checker to check for prerequisite applications and identify potential installation problems. You might have to restart your computer if any prerequisite applications were installed.

    System Configuration Checker SQL 2019

  3. Click Installation, and then select the New SQL Server stand-alone installation or add features to an existing installation option.

    New SQL Server Stand-alone 2019

  4. Enter your SQL Server 2019 product key provided by Microsoft, and click Next.

  5. Accept the license terms, and click Next.

  6. On the Microsoft Update page, check Use Microsoft Update to check for updates based on your company's policy. Click Next.

    Wait while the SQL Server Setup files are installed on the computer.

    SQL Server 2019 Setup Files

  7. After the setup files are installed, review the results for any failures that must be fixed before you continue. Click Next.

    Setup Failure Results

  8. On the Feature Selection page, select the features below.

    • Database Engine Services

    • SQL Server Replication (required if the SQL server instance is set up for the Global Workshare configuration)

    • Client Tools Connectivity

    SQL 2019 Feature Selection

  9. Set the instance root directory and shared feature directories as you need. Click Next.

  10. Define your instance name. Click Next.

  11. On the Server Configuration page, specify a domain account name with administrative privileges on the database server. Then, set the Startup Type to Automatic.

    • If you are not sure, use the default NT Service accounts and change the server logon later.

    • A domain user account offers more flexibility. This type of account is typically used because many server-to-server activities can be performed only with a domain user account, including remote procedure calls, replication, and backing up network drives.

  12. Select the Collation tab. Use locale-specific collation. These collation settings include the character set, sort order, and other locale-specific settings.

    S

  13. Click Next.

  14. On the Server Configuration tab of the Database Engine Configuration page:

    • Select Windows authentication mode if you plan to use Windows user names and passwords to access the databases.

    • Select Mixed Mode if you plan to use database user names and passwords to access the databases.

    See Understanding Database Authentication to learn about the differences between the two choices.

    Server Config Tab Windows Auth Mode

  15. Specify at least one SQL Server Administrator. You will need this administrator logon later to open SQL Server Management Studio.

  16. On the Data Directories tab, verify that the directories are set as you need.

  17. Click Next.

  18. Review the settings you have defined. Click Install.

    Wait while Microsoft SQL Server is installed.

    If any errors occur during installation, refer to the Summary Log for more information and contact support for further assistance.

  19. Click Close.

  20. On the Installation page, click Install SQL Server Management Tools.

    Install SQL Server Mgmt Tools

  21. Download and install SQL Server Management Studio from the MSDN web site.