Previous Topic: Controlling Disk Space UsageNext Topic: Network Configuration


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