Database Server Requirements

From TeamServer ER/Studio
Jump to: navigation, search

Go Up to Main Page

Supported Database Platforms

Notepad blue icon 2.pngNote: IBM DB2 is no longer supported as a Team Server/Repository platform.

Team Server and Repository databases may run on any of the following database platforms:

  • Microsoft SQL Server 2012 to 2017.
  • Oracle 11g, 12c, and 12c R2.

Notepad blue icon 2.pngNote: Team Server/Repository supports running from Amazon EC2 or Azure IaaS environments.

In order for the Repository to communicate with the database, the machine running Team Server must also have the corresponding RDBMS client utility installed.

Important Information

Oracle Characteristics
  • Install the 64-bit version of Oracle Client Utilities.
  • Configure your server in one of the Oracle configuration tools:
    • Net Easy Config
    • Net Configuration Assistant
  • Create a connection alias.
  • If you are upgrading using Oracle, increase the number of processes (connections) to 200 before running.
  • Minimum permissions for owner of Repository and Team Server schema:
    • Roles:
      SELECT_CATALOG_ROLE
    • Privileges:
      CREATE INDEXTYPE
      CREATE PROCEDURE
      CREATE SEQUENCE
      CREATE SESSION
      CREATE SYNONYM
      CREATE TABLE
      CREATE TRIGGER
      CREATE TYPE
      CREATE VIEW
      UNLIMITED TABLESPACE
Microsoft SQL Server Characteristics
  • 64-bit client libraries are already installed on Windows machines.
  • Ensure that the server and database are set to case-insensitive, as case-sensitive is not supported. Also set the SQL Server Configuration Properties to allow SQL Server authentication. Team Server only supports SQL Server Authentication.
  • The database and server collation must be set to SQL_Latin1_General_CP1_CI_AS
  • When using SQL Server, ensure the SQL Server Agent is running.
  • Team Server on SQL Server only supports the following communication protocols:
    • Shared Memory
    • TCP/IP
    • Named Pipes
  • The option ANSI_NULLS (Server Properties > Connections) needs to be set as On.
  • The default schema for Team Server database needs to be dbo. If you were using a different schema please move the tables to dbo schema previous to install or upgrade Team Server.

Notepad blue icon 2.pngNote: After configuring a new installation against a SQL Server 2014 or later database, it is recommended that you go into the properties of the new database and change the compatibility settings to 2012 or 2008. This step helps prevent significant performance degradation in many environments. For more information about this feature, see an IDERA forum post about this subject.

See Also