Database Guide › SQL Server Guidelines › DLP--Database Configuration › Server Authentication

Previous Topic: Controlling Disk Space Usage

Next Topic: Minimum Memory Allocation

Server Authentication

Applicable to the CMS and gateways

You must up set up the target CMS or gateway server to use the correct authentication method, otherwise it will be unable to connect to the SQL Server database.

In the SQL Server Enterprise Manager, edit the Security properties of the target CMS server so it uses ‘SQL Server and Windows’ authentication. For example, in SQL Server 2005 you do this in the Security page of the Server Properties dialog; see the screenshot below.

SQL Server 2005 server properties