Creating the Access Management database

Create the Access Management database using the provided PowerShell script.

Before you begin

About this task

Installing Access Management consists of creating a database and installing a service, and then completing a number of post-installation configuration tasks.

Procedure

  1. On your database server machine, open a PowerShell prompt.
  2. In the location of your Tridion Sites installation media, navigate to the folder for the type of database you are creating:
    • For a Microsoft SQL Server, AWS RDS-MSSQL or Microsoft Azure database: Database\MSSQL\
    • For an Oracle database:Database\Oracle\
  3. For a Microsoft SQL Server database, you can add an -IntegratedSecurity switch to let the script know that you want to use the current Windows account credentials to access the database, rather than specifying a database username and password.
  4. For Oracle databases, specify a host, port, service name and other connection information for the PowerShell script, either before or while running the script:
    • Before you run the script, you can define a variable in PowerShell, let's say $MyDatabaseServer, and set it to your connection string. When you invoke the script, you then append the string -DatabaseServer $MyDatabaseServer to the PowerShell command.
    • Alternatively, you can just invoke the script as is, and while you run the script, PowerShell prompts you for a value for Net Service, and you can then enter one of the following:
      • Enter the Net Service Name for this database if you have defined a Net Service Name in a tnsnames.ora file and specified the location of that file in a TNS_ADMIN environment variable.
      • Enter the string %manual% to let the script prompt you for the following: Host name, Port and Service name.
      • Enter the actual connection string directly on a single line if you have more to provide than just a host, port and service name. For example:
        (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ora)))
  5. Run the following PowerShell command, following the instructions that appear:
    & '.\Install Access Management database.ps1'
    By completing this step, you have created the Access Management database.