Creating a Development VM - Part 3: Setting up the Database

This document details the steps required to install and test the SDL Tridion Content Manager 2011 server on a Windows 2008 R2 platform, with a SQL Server backend.

Creating a Development VM - Part 3

Tutorial Sections:

Install SQL Server 2008 R2

Link the SQL Server 2008 R2 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 2008 R2 ISO and click open

Click OK to continue

Run Setup

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

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

Click "OK"

Enter your product Key for SQL Server 2008 R2

Click Install

Click Next

Select to install a "SQL Server Feature Installation" and click next

Select to install the Database Engine and the Management Tools.

Click next

Click Next

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

Click Next

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.

Click Next

Click Next

Click Next

Click Install

Click Close

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

In this step, we will create the two database schemas required by the Tridion Content Manager.

Run the Tridion Database Manager (TDM) tool

Download and install MSXML 4 SP3

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7f6c0cb4-7a5e-4790-a7cf-9e139e6819c0&displaylang=en

Locate the Tridion Database Manager (under [Tridion_Install]\Database) and launch this tool.

Click on New Database.

Select the default options of "Content Manager" and click Next

Since we're installing on the same server, you can leave the default values on this screen. Click Next

Enter the password you used for the SA user.

Enter a password for the TCMDBUser

Enter a password for the TCMLogDBUser

Enter the MTSUser accound information. If this account does not yet exist or the information is incorrect you will receive a warning message. Make sure the Domain field has the current machine name. Click Next.

Enter the SYSTEM account to use. Typically you will NOT change this value.

Enter the details of the "Tridion Administrator" account. This will default to the user currently executing the installation.

Select the location of the log file generated by this tool.

Wait for the completion of the database creation.

Select File -> Exit, and close the Database Manager

You have now created the Tridion Content Manager database schemas. The next step will guide you through the installation of the Content Manager software.

Next section: Installing the Content Manager

Move on to the next section: Installing the Content Manager