Creating databases for your sample single-machine installation
Run a number of PowerShell scripts to create the databases for Content Manager and Content Delivery.
Before you begin
Procedure
- Start Windows Explorer.
- Create a folder c:\SDLDBinstall\ and a subfolder c:\SDLDBinstall\Scripts\.
- Go to your SDL Web installation media and go to the Database\ folder.
- Copy the subfolder mssql\ to c:\SDLDBinstall\.
- Go to the installation media subfolder Database\Scripts\.
- Copy the installation media files Tridion.Database.Management.dll and Utilities.ps1 to c:\SDLDBinstall\Scripts\.
- Copy the installation media subfolder mssql\ to c:\SDLDBinstall\Scripts\.
- Copy the installation media subfolder Tools\ to c:\SDLDBinstall\Scripts\.
- Right-click c:\SDLDBinstall\Scripts\Tridion.Database.Management.dll and select Properties from the context menu. If you see an Unblock button, select it and select OK.
- Start PowerShell as an administrator-level user by right-clicking the PowerShell icon and selecting Run as administrator, even if you are already logged in to Windows as an administrator-level user.
The PowerShell console opens.
- Enter the following command:
Set-ExecutionPolicy UnrestrictedAnswer A (All) when prompted.
- Go to c:\SDLDBinstall\mssql\.
- Run the following command:
& '.\Install Content Manager database.ps1' - Confirm the default database server name,
(local), and the default administator account name,sa. - Enter the password for
sa. - Confirm the default database name,
Tridion_cm, and the default database account name,TCMDBUser. - Enter and confirm as the password for this user:
tridion. - Confirm that you do not want to create another user:
N. - Replace the default full user name of the SDL Web Content Manager MTSUser account,
DOMAIN\MTSUser(where DOMAIN is your domain) with the value.\MTSUser. - Confirm the default SDL Web Administrator User Name,
MACHINE\Administrator, where MACHINE is the name of your machine, as well as the default name of the local system account,NT AUTHORITY\SYSTEM. - Confirm that you want to proceed:
Y.The script installs the database. - Run the following command:
& '.\Install Topology Manager database.ps1' - Confirm the default database server name,
(local), and the default administator account name,sa. - Enter the password for
sa. - Confirm the default database name,
Tridion_Topology, and the default database account name,TTMDBUser. - Enter and confirm as the password for this user:
tridion. - Confirm that you do not want to create another user:
N. - Confirm that you want to proceed:
Y.The script installs the database. - Run the following command:
& '.\Install Content Data Store.ps1' - Confirm the default database server name,
(local), and the default administator account name,sa. - Enter the password for
sa. - Confirm the default database name,
Tridion_Broker, and the default database account name,TridionBrokerUser. - Enter and confirm as the password for this user:
tridion. - Confirm that you want to proceed:
Y.The script installs the database. - Run the same command again:
& '.\Install Content Data Store.ps1' - Confirm the default database server name,
(local), and the default administator account name,sa. - Enter the password for
sa. - Replace the default database name,
Tridion_Broker, withSDLWeb_xpm_sample. - Confirm the default database account name,
TridionBrokerUser. - Confirm that you want to proceed:
Y.The script installs the database. - Close PowerShell.
- Remove the folder c:\SDLDBinstall\ to free up disk space on your machine.