Documentation Center

Creating the Content Manager database

Content Manager Server requires a Content Manager database. Use a PowerShell script to create a Microsoft SQL Server or Oracle database.

Before you begin

Software

To install or upgrade SDL Tridion databases on a Windows machine requires Windows PowerShell 3.0 and Microsoft .NET Framework 4.0 or higher.

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 Tridion 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:
    • Database\MSSQL\ or
    • Database\Oracle\
  3. Type the following command:
    & '.\Install Content Manager database.ps1' 
  4. Follow the instructions in the PowerShell console to install the database.

Results

You have created the Content Manager Database.