Install database software on the application server - HxGN SDx - Update 31 - Installation & Upgrade

Installation and Setup for HxGN SDx Application Server

Language
English (United States)
Product
HxGN SDx
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

For details on the database software versions and editions that are required on the application server, see the software recommendations subsection for the HxGN SDx Application Server platform recommendations.

Oracle

For Oracle database access, install the following:

  • Oracle client software

    After installing the Oracle client on the application server, the server should be rebooted.

  • Oracle Net Server database software, to configure a local net service name pointing to the database server.

    SHARED Tip For more information about installing Net Server, see the Oracle documentation.

SQL Server

To provide access to the SQL Server database when it is installed on a separate database server, install the following Microsoft SQL Server Shared Features on the application server:

  • Client Tools Connectivity

  • Client Tools Backwards Compatibility

  • Client Tools SDK

  • SQL Client Connectivity SDK

SQL Server Management Studio (SSMS) and is no longer distributed with the database engine setup program. SSMS is delivered as a separate product by Microsoft.

SHARED Tip Instead of installing the SQL Server Shared Features, you can install two packages from the SQL Server Feature Pack, downloadable from Microsoft. Select the 64-bit versions of each, version 13 for SQL Server 2016 or version 14 for SQL Server 2017.

  • Microsoft ODBC Driver for Microsoft SQL Server - Windows (msodbcsql.msi)

  • Microsoft SQL Server Command Line Utilities (MsSqlCmdLnUtils.msi)