Documentation Center

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 SDL Web 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. Open Windows PowerShell from the Windows Start Menu.
  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. Type the following command:
    & '.\Install Content Manager database.ps1' 
  4. Answer Yes if you are installing an AWS RDS-MSSQL 2016 database and you see the following prompt:
    This database server version is not supported. Supported database server versions are 'Microsoft SQL Server 2012 SP3',
    'Microsoft SQL Server 2014 SP2', 'Microsoft SQL Server 2016 SP1'. Do you want to continue anyway?
  5. Follow the instructions in the PowerShell console to install the database.

Results

You have created the Content Manager Database.