Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Windows server 2012 R2 or Windows server 2016 
  • Microsoft SQL Server 2014 or Microsoft SQL Server 2016
    • SQL Edition must be Web or higher
    • SQL Server must use mixed mode authentication
    • Full-text filter daemon must be installed
    • TCP/IP must be enabled
  • Administrative access (SA) to SQL server or pre-staged database (see info box below)
  • Open on port 1433 (standard sql port) for sql connections

...

Info
titleNote

If it is desired to use in the installation process of the DAM Center an SQL user that does not have the sysadmin role, then the database needs to be pre-staged before the installation. By using this option the installation process will use the admin_company_dam user (see below for SQL roles).

The following has to be created (company below = your company's name):

Two blank databases

  • Company_dam
  • Company_dam_jobs

Two users

  • Admin_company_dam
  • Admin_company_dam_jobs

Security mapping

Both users need to be db_datareader and db_datawriter on each of the two databases. Furthermore each user should be db_owner on it's respective database (i.e. admin_company_dam needs to be db_owner on Company_dam).

Script to pre-stage the database 

CreateEmpty_DamCenter_Databases.sql

1.3 Processing server

The processing server has the following requirements

...