Database configuration for Microsoft SQL Server

This section describes the minimum database requirements that must be fulfilled before creating StreamServe repositories in a testing environment.

For detailed information, see OpenText StreamServe Microsoft SQL Server Database Guidelines, available at OpenText Knowledge Center.

Database configuration

•	Enable TCP/IP.

•	Specify Mixed Mode authentication.

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

Note:

Do not specify any dynamic TCP ports.

•	Select a proper collation.

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.