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
- On a system that meets the prerequisites for database installation and upgrade scripts, open PowerShell.
- 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\
- 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.
Note: If you use this switch, you need an authentication .NET assembly. To get this assembly, download the Microsoft JDBC Driver for SQL Server package that is compatible with the database version you are using. Refer to Microsoft's
JDBC Driver for SQL Server Support Matrix webpage to determine the driver version you need. Then extract the .NET assembly called
mssql-jdbc_auth-VERSION.x64.dll, where
VERSION is the version of the JDBC driver, and place it in the same directory as your database script.
- 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:
- Type the following command:
& '.\Install Content Manager database.ps1'
- Follow the instructions in the PowerShell console to install the database.
Results
You have created the
Content Manager Database.