SQL Server Requirements

Note: Passwords for recent versions of SQL Server are case sensitive. Ensure passwords are updated if upgrading from a version older than 2008.

SQL Server Installed Components

The following components must be installed:
  • Database Engine Services

SQL Server Naming Conventions

Do not use special characters for server names.

SQL Server User Access

As an SQL Server user, you must have following permissions to install Plant Applications Server successfully.
  • SYSADMIN Server role.

Supported Network Protocols

Before installing SQL Server, the stand-alone named and default instances must support the following network protocols:

  • Shared memory (Shared memory is not supported on failover clusters)
  • Named pipes
  • TCP/IP

The same network protocol must be set up on the server and client computers to be able to communicate with each other.

SQL Server Browser Service and Plant Applications Server

Microsoft System CLR Types SQL Server 2016 (32-bit only) must be installed.

If you are installing Plant Applications Server on a computer and SQL Server on a different computer, the SQL Server Browser service (sqlbrowser) must be running before installing Plant Applications Server.

For information on the SQL Server Browser service, see: http://msdn2.microsoft.com/en-us/library/ms165724.aspx

Enabling TCP/IP and XP_cmdshell

The xp_cmdshell option and the TCP/IP protocol, which are disabled by default, must be enabled. The installation process will verify whether the TCP/IP protocol is enabled and if it is not enabled, a message box appears asking permission to enable the TCP/IP protocol. If permission is denied, the installation process will quit. The xp_cmdshell option is automatically enabled during the installation process.

Note: If you are installing Plant Applications Server on a computer and SQL Server on a different computer, you must manually enable the TCP/IP protocol. It cannot be enabled remotely.