Database requirements for StreamServe repositories

A database installation is required for the StreamServe repositories. For a list of the supported databases, see Databases in the Supported platforms and software documentation.

If you plan to use SQL Server or SQL Server Express for the StreamServe repositories, you must configure the database installation for use with StreamServe components.

All the StreamServe repositories must use the same database vendor. For example, if the enterprise repository runs on Oracle, the runtime repository, the Collector archive, and the web content repository must also run on Oracle.

Database guidelines

For guidelines about how to create, maintain, back up, and fine tune the StreamServe repositories, see the StreamServe Database Guidelines.

You can download the StreamServe Database Guidelines from OpenText Knowledge Center.

Configuring SQL Server and SQL Server Express for use with StreamServe components

You must configure SQL Server and SQL Server Express for use with StreamServe components.

Database configuration

The following configuration is required in the database installation:

•	Enable TCP/IP.

•	Mixed Mode authentication is specified.

•	For all IP addresses, specify the static TCP port number that you use to access the database.

•	Do not specify any dynamic TCP ports.

SQL Server Browser service for named instances

If you use a named instance of SQL Server, the SQL Server Browser service must be started before you create the StreamServe repositories.