Documentation Center

Configuring Windows database servers

If the database server is a Windows Server system, you must disable the complex password requirement before completing the procedure below to create the tablespaces in the database.

About this task

To do this, go to: Control Panel > Administrative Tools > Local Security Policies > Account Policies > Password Policies.
If you cannot, or do not, want to disable the requirements, change the password in the pdm_setup.sql script from manager to a password which can meet complexity requirement of Local Security Policy, and then follow the procedure below to execute the script.

Procedure

  1. Install SQLCMD, Client Tools, and Client Libraries on the database server.
  2. Edit the pdm_setup.sql script installed into the Contenta_home/setup directory on the Contenta Server. You can modify:
    • Path name for the data file and log file
      In the example, these are defined as:
      C:\Program Files (x86)\Microsoft
      SQLServer\MSSQL.1\MSSQL\Data\xyadmin.mdf
      C:\Program Files (x86)\Microsoft SQL
      Server\MSSQL.1\MSSQL\Data\ftxyadmin_log.ldf
    • Size of the data file and log file and allotted file growth
      In the example, it is defined as:
      SIZE = 2048KB, FILEGROWTH = 1024KB
  3. Execute the script as follows:
    1. At a command prompt on the server, go to the Contenta_home/setup directory.
    2. At the command prompt, enter the following:
      sqlcmd -S <servername>\<ODBC DNS> -i pdm_setup.sql

      where <servername> is the name of the Microsoft SQL Server and <ODBC DNS> is the ODBC data source name.

  4. Manage the minimum and memory for each instance because the default SQL Server installation consumes all available memory.

    If you have more than one database instance, divide the available memory among the instances. If you have only one instance, you still may not want to set the memory for “less than all available” to avoid potential crashes when memory usage is at its maximum.

    With a 32‐bit operating system, the default value only allows the use of up to 2GB. Edit the boot.ini file to set the 3Gig switch to be able to use more than 2GB of memory.

  5. On each client workstation that runs the administrator tools, edit the PCM_CreateDB.sql file in the Contenta_home/bin directory.
    The pdm_setup.sql script is an example. It shows how you can define the tablespaces. The data you modify for your site is highlighted in bold in the above example.