CA DataMinder FastStart uses a Microsoft SQL Server database. CA DataMinder servers need sufficient memory and processing power to run your chosen database. See your database documentation for details.
Not recommended for CMSs or FastStart base machines.
Note: SQL Server is supported on Windows servers only.
Configure the CMS to use the correct authentication method, otherwise it will be unable to connect to the SQL Server database.
In 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’).
Verify that CA DataMinder can connect to SQL Server over a network:
Verify 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 uses dynamic ports, reconfigure the SQL Server instance hosting the CA DataMinder database to use static ports. This is particularly important if your CMS uses SQL Server 2005 Express.
Full details are in the Database Guide. In particular, see the ‘SQL Server Guidelines’ chapter.
Copyright © 2014 CA.
All rights reserved.
|
|