Install database software on the application server - SmartPlant Foundation - IM Update 47 - Installation & Upgrade

Installation and Setup for SmartPlant Foundation Application Server

Language
English
Product
SmartPlant Foundation
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 SmartPlant Foundation 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) 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.

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

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