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
  • Reporting Services
  • Client Tools Connectivity
  • Client Tools Backwards Connectivity
  • SQL Server Books Online (recommended)
  • Management Tools - Basic

SQL Server Naming Conventions

Do not use special characters for server names.

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
  • VIA

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

If you are installing Plant Applications Server on a server with Microsoft SQL Server, the SQL Server Browser service (sqlbrowser) must be running before installing Plant Applications Server.

For information on SQL Server Browser service, go to the MSDN web site: 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.