Creating a Development VM - Part 3: Setting up the Database
This document details how to install and test an SDL Tridion Content Manager 2013 install on Windows 2012 with a SQL Server database.
Creating a Development VM - Part 3
Install SQL Server 2012
Install SQL Server 2012
Link the SQL Server 2012 ISO file to your VM image
Select your CD/DVD drive and click on "Use ISO image file"
Browse to the location of your SQL Server 2012 ISO and click open
Click OK to continue
Run Setup from the mapped drive.
The welcome screen appears. Click on Installation (on the left side)
Click on "New installation or add features to an existing installation."
Enter your product Key for SQL Server 2012
Agree to the license terms and click Next
Select to install a "SQL Server Feature Installation" and click next
- Select to install the Database Engine and the Management Tools.
Use the default name for SQL Server, unless you know what you're doing.
Assign the System account to all services and click next, unless you know what you're doing.
- Choose "Mixed Mode" authentication (required), enter a password for the SA user, and add the current user to the list of administrators.
Let the software install then click Close
Run Windows update again to get the latest updates for SQL Server
In the next steps, we will optionally backup your work thus far then create the two database schemas required by the Content Manager.
Now's a good time to make a copy (or two) of your VM as a backup and to maybe test different versions of SDL Tridion. Suspend or turn off the guest (VM) and then copy the VM's entire folder on your host machine, giving it a name you'll remember.
Run the Tridion Database Manager Scripts
Start PowerShell (keyboard Start Key, then type out "PowerShell") as an Administrator.
If needed, run:
Install the Content Manager Database
Navigate to your installation scripts folder then run:
& '.\Install Content Manager database.ps1'
(e.g. PS C:\[Tridion_Install]\Database\MSSQL> & '.\Install Content Manager database.ps1')
Follow the prompts in the script then enter "Y" to confirm.
Transcript started, output file is C:\Users\user_name\AppData\Local\Temp\Install Content Manager database_21140302162013.log
Database Server name. Default value is '(local)':
User name of database administrator account. Default value is 'sa':
User password of database administrator account: *******
Current Microsoft SQL Database server version is:
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Database name. Default value is 'Tridion_cm':
User name of database account. Default value is 'TCMDBUser':
Enter user password of database account: *******
Re-enter user password of database account: *******
Full user name of Tridion Content Manager MTSUser account. Default value is 'T2013-CREATE\MTSUser':
Default Tcm Administrator UserName. Default value is 'T2013-CREATE\areyes': Administrator
WARNING: Specified value is not a valid identificator.
Default Tcm Administrator UserName. Default value is 'T2013-CREATE\areyes':
The name of the local system account. Default value is 'NT AUTHORITY\SYSTEM':
Do you really want to create database with specified settings?
[Y] Yes [N] No [?] Help (default is "Y"):
Optionally Run Other Scripts
Based on your VM needs, optionally create the Translation Manager
and Audience Manager
databases using the PowerShell scripts as well. Be sure to install or skip these features in the next section, the Content Manager installation.
Set Auto-Growth Settings
Next section: Installing the Content Manager
Move on to the next section:
Installing the Content Manager