Database Guide › SQL Server Guidelines › CA DataMinder Server Requirements

CA DataMinder Server Requirements

After setting up your SQL Server database for CA DataMinder, note the following requirements when you install your CMS and gateway servers.

TCP/IP Port Number

When you install the CMS or a gateway server, the installation wizard prompts you for the TCP/IP port number used by SQL Server. If you have multiple instances of SQL Server running on a single machine, each must have its own port number. Make sure that you enter the port number associated with the CA DataMinder database when you run the installation wizard.

Using a Remote \Data Folder

If you want to use a SQL Server database while storing your captured data in a remote \Data folder, you must:

• Use a network-attached storage (NAS) device, or
• Use a storage area network (SAN), or
• Create an empty WGN database on the host database server before you run the installation wizard.

  Note: This is necessary because, if the WGN database does not already exist, the CA DataMinder installation wizard will create the necessary database files in the remote \Data folder, causing database access errors.

These limitations are due to a known SQL Server issue that prevents you storing your database files on a network file share. For details, see MS Knowledge Base article Q304261.