Create a central ACM database

When planning an ACM deployment, if there are multiple people collaborating on projects, make sure to select a computer to use as the ACM database server that all users in the project have accessed to it. The server can be a standard computer that does not belong to a particular user or a project computer. The computer must always be turned on and available.
Microsoft®
SQL Server®
2016 is the only software required on the shared computer.
TIP:
The ability to connect to a remote database is only available if the product has a Standard activation license and is not available in Lite mode.
Install
Microsoft
SQL Server
 2016 via the ACM installation media. Select only
Microsoft
SQL Server
 2016 when presented with the selection of install options.
When configuring the
SQL Server
, note the following considerations when supporting multiple user connections to the database:
  1. Add Users
    : Normally ACM uses Windows Authentication to connect to the ACM database. When the ACM database is on a remote computer, local users must be created using the SQL Server Management Studio. Create one shared user account for all the project collaborators or add an individual user for each collaborator. Only assign users to the ACM database after the ACM database is created.
    If the SQL user is not a sysadmin, creation of the database for the first time is a multi-step process:
    1. Create users in SQL.
      • Minimum
        Server Roles
         should be dbcreator and public.
      • Permissions on
        Securables
         should be Connect SQL, Control Server, and View any database (optional, but if not, map the database to this user in SQL).
    2. Launch the database manager in ACM and create the database using the new user.
      Creation of this database must be done from ACM and cannot be done manually in
      Microsoft
      SQL Server
      .
    3. In order for the user to connect and update the database, add the newly created database to the User Mapping in SQL and set the memberships on the database to:
      • db_owner
      • db_datareader
      • db_datawriter
      • public
    4. In order for the user to back up the database, add the newly created database to the User Mapping in SQL and set the memberships on the database to:
      • db_backupoperator
  2. Record Database Connection Information
    : Record the
    SQL Server
     computer name and/or computer IP address, the
    SQL Server
     instance name, the
    SQL Server
     authentication (username and password), and the ACM database name. ACM users need this information to connect to the central ACM database.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal