Page Comparison

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