Running the Content Manager database creation script

Use a PowerShell script to create the Microsoft SQL Server, Oracle, Microsoft Azure, or AWS RDS-MSSQL database for Content Manager.

Before you begin

Database server
Before running a PowerShell script:
  • On Oracle—make sure that there are no open database connections and configure the Oracle database server.
  • On Microsoft SQL Server—configure the Microsoft SQL Server database server.
Database credentials
PowerShell scripts prompt you for the following information:
  • DBA and user credentials (unless you created an Oracle Tridion Sites administrator user)
  • the server and port number (if non-standard) where your database server resides
Database details
PowerShell scripts prompt you to provide the following information which you will need to store in a safe place along with Database credentials as you will need it when you install and configure the Content Manager and Content Delivery:
  • the name of the database
  • the name of the database user
PowerShell scripts provide default database names and user names, or you can enter your own.
Users
PowerShell scripts prompt you to provide the following information:
  • A system user (MTSUser)
  • The name of an administrator user
  • Local system account—the default is NT AUTHORITY\SYSTEM

Procedure

  1. On a system that meets the prerequisites for database installation and upgrade scripts, open PowerShell.
  2. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • For a Microsoft SQL Server, AWS RDS-MSSQL or Microsoft Azure database, navigate to Database\MSSQL\
    • For an Oracle database, navigate to 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. Type the following command:
    & '.\Install Content Manager database.ps1' 
  6. Follow the instructions in the PowerShell console to install the database.

Results

You have created the Content Manager Database.