CA DLP FastStart supports various versions of Microsoft SQL Server. In all cases, ensure that your database is correctly configured. In particular:
You must up set up the CMS 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 Mode (formerly known as ‘mixed mode’).
You must ensure that SQL Server can be connected to over a network:
Ensure this service has started. By default, this service is off.
Enable the TCP/IP protocol. By default, this protocol is disabled.
The CMS connects to the DBMS using static ports. If your database host server is configured to use dynamic ports, you must change this so that the SQL Server instance hosting the CA DLP database uses static ports. This is particularly important when your CMS uses SQL Server 2005 Express.
(If upgrading from CA DLP 5.0 only) Grant your CA DLP primary user the database role SQLAgentUserRole in the msdb database.
Note: Since CA DLP 6.0, this role has been granted automatically when you install a new SQL Server CMS.
Full details are in the Database Guide; in particular, see the ‘SQL Server Guidelines’ chapter.
|
Copyright © 2012 CA.
All rights reserved.
|
|