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

Tutorial Sections:

Install SQL Server 2012

Install SQL Server 2012

  • Link the SQL Server 2012 ISO file to your VM image
    1-set-up-ISO-for-SQL

  • Select your CD/DVD drive and click on "Use ISO image file"
    2-ISO-set

  • Browse to the location of your SQL Server 2012 ISO and click open
    3-set-ISO

  • Click OK to continue
    4-ok

  • Run Setup from the mapped drive.
    5-run-setup

    6-user-account-control

    7-please-wait

  • The welcome screen appears. Click on Installation (on the left side)
    8-welcome

  • Click on "New installation or add features to an existing installation."
    9-installation

  • Click "OK"
    10-start

  • Enter your product Key for SQL Server 2012
    11-product-key

  • Agree to the license terms and click Next
    12-license-terms

  • Click Install
    14-setup

  • Click Next
    15-summary

  • Select to install a "SQL Server Feature Installation" and click next
    16-role

  • Select to install the Database Engine and the Management Tools.
  • Click next
    17-feature-selection

  • Click Next
    18-rules

  • Use the default name for SQL Server, unless you know what you're doing.
    19-config

  • Click Next
    20-disk-space-requirements

  • Assign the System account to all services and click next, unless you know what you're doing.
    21-server-configuration

  • Choose "Mixed Mode" authentication (required), enter a password for the SA user, and add the current user to the list of administrators.
  • Click Next
    23-database-engine-config

  • Click Next
    24-error-reporting

  • Click Next
    25-installation-config-rules

  • Click Install
    26-ready-to-install

  • Let the software install then click Close
    28-installation-complete


Run Windows update again to get the latest updates for SQL Server

29-windows-update


In the next steps, we will optionally backup your work thus far then create the two database schemas required by the Content Manager.

Backup!

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.

30-powershell

If needed, run:

Set-ExecutionPolicy AllSigned

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':

Verify ready
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

  • Open Microsoft SQL Server Management Studio and optionally confirm the Tridion_cm database is created.
  • Right-click on it and select Properties.
    32-sql-server-mgmt-studio

  • Choose Enable Autogrowth set to 50 Megabytes. Optionally set a Maximum File Size (depending on your use case for the VM).
    33-auto-growth

 

Next section: Installing the Content Manager

Move on to the next section: Installing the Content Manager

About the Author
Alvin Reyes
Consultant

As an SDL Content Management Technologies (CMT) consultant, Alvin enjoys the opportunity to help organizations find solutions that balance business and system needs. He is active in the SDL Tridion technical community, participating on Tridion StackExchange, serving as a functional lead for SDL Tridion Powertools, and actively writing about information systems, business analysis, and especially Tridion on his blog, "Create and Break."

SDL CMT division