Installation And Configuration of Microsoft Content Management Server: Part 1

Exclusive offer: get 50% off this eBook here
Enhancing Microsoft Content Management Server with ASP.NET 2.0

Enhancing Microsoft Content Management Server with ASP.NET 2.0 — Save 50%

Use the powerful new features of ASP.NET 2.0 with your MCMS Websites

£14.99    £7.50
by Lim Mei Ying Spencer Harbar Stefan Goßner | March 2010 | .NET Content Management Open Source

This article series by Spencer Harbar, Lim Mei Ying, and Stefan Gobner, authors of Enhancing Microsoft Content Management Server with ASP.NET 2.0, delves into the integration of key ASP.NET 2.0 features such as Master Pages, Site Navigation, Themes and Skins, and the Membership Provider Model with Microsoft Content Management Server 2002 (MCMS) Service Pack 2. Each article builds upon the last, walking through these new features available to MCMS developers and building a sample site.

In this article series, we will cover:

  • Installation And Configuration of Microsoft Content Management Server (see below)
  • Getting Started with the Development Environment
  • Using Master Pages
  • Navigation Controls
  • Applying Themes
  • Authentication Controls and Membership Providers
  • How-Tos, Tips, and Tricks

In this first article of the series we walk you through the installation and configuration of MCMS 2002 Service Pack 2 (SP2), along with SQL Server 2005 and Visual Studio 2005 on a single developer workstation. In addition, we will cover the changes to the SP2 development environment and a number of tips for working within it.

This article assumes you are already familiar with the steps necessary to install MCMS 2002 SP1a as detailed in depth in the previous book, Building Websites with Microsoft Content Management Server from Packt Publishing, January 2005 (ISBN 1-904811-16-7).

There are two approaches to setting up a development environment for SP2: upgrading from a previous SP1a installation, or starting from scratch and building a fresh installation including SP2. We will cover both approaches in this article.

For example, we will be using Windows XP Professional SP2 as our development workstation. However, where there are significant differences for a Windows Server 2003 SP1 machine, those will be noted. All examples assume the logged-on user is a local machine administrator.

Overview of MCMS 2002 Service Pack 2

As with other Microsoft Service Packs, one major purpose of SP2 is to provide an integrated installation for a large number of previously released hotfixes. SP2 will now be a prerequisite for any future hotfix releases.

While many customers will view SP2 as a regular Service Pack, it also offers support for the latest development platform and tools from Microsoft, namely SQL Server 2005, .NET Framework 2.0 and ASP.NET 2.0, and Visual Studio 2005:

  • SQL Server 2005: MCMS databases can be hosted by SQL Server 2005, offering numerous advantages in security, deployment, and most significantly, performance.
  • .NET Framework 2.0 and ASP.NET 2.0: MCMS applications can be hosted within the .NET Framework 2.0 runtime, and take advantage of v2.0 language features as well as security and performance improvements. In addition, many of the new features of ASP.NET 2.0 such as master pages, themes, navigation, and Membership Providers can be used. This provides numerous opportunities to both refine and refactor MCMS applications, and is the primary focus.
  • Visual Studio 2005: MCMS applications can be developed using Visual Studio 2005. One of the greatest advantages here is the use of the new HTML-editing and designer features in VS.NET along with improved developer productivity.

If you wish, you can continue to use SQL Server 2000 for your MCMS applications. However, we recommend upgrading to SQL Server 2005 and will use it throughout the examples in this book.

There are numerous versions or Stock Keeping Units (SKUs) of Visual Studio 2005, all of which are supported with SP2. Throughout the examples in this book, we will be using Visual Studio 2005 Professional Edition.

Unfortunately, SP2 is not a cumulative service pack and therefore requires an existing installation of SP1a. Likewise, there is no slipstreamed distribution of SP2. The SP2 distribution is suitable for all editions of MCMS.

Mainly due to the extremely fast preparation and release of SP2 following the Release to Manufacturing (RTM) of .NET 2.0, Visual Studio 2005, and SQL Server 2005, the Microsoft installation information (KB906145) isn’t particularly well documented and is somewhat confusing. Rest assured that the guidance in this article has been verified and tested for both installation scenarios covered.

Obtaining MCMS Service Pack 2

MCMS SP2 can be downloaded from the following locations:

Installation Approach

We cover both an in-place upgrade to SP2 and a fresh installation in this chapter. Which approach you take is down to your specific requirements and your current, if any, MCMS installation.

If you wish to perform a fresh install, skip ahead to the Fresh Installation of Microsoft Content Management Server 2002 Service Pack 2 section, later in this article

Upgrading to Microsoft Content Management Server 2002 Service Pack 2

This section details the steps required to upgrade an existing installation of MCMS SP1a, which includes the Developer Tools for Visual Studio.NET 2003 component. The outline process for an upgrade is as follows:

  1. Install Visual Studio 2005.
  2. Install MCMS 2002 Service Pack 2.
  3. Configure the development environment.
  4. (Optional) Prepare the MCMS database for SQL Server 2005.
  5. (Optional) Upgrade SQL Server.
  6. (Optional) Install SQL Server 2005 Service Pack 1.

We will perform all steps while logged on as a local machine administrator.

Installing Visual Studio 2005

Visual Studio 2005 can be installed side by side with Visual Studio.NET 2003. Once we have completed the upgrade, we can remove Visual Studio.NET 2003 if we wish to only develop MCMS applications using SP2 and ASP.NET 2.0.

  1. Insert the Visual Studio 2005 DVD, and on the splash screen, click Install Visual Studio 2005.
  2. On the Welcome to the Microsoft Visual Studio 2005 installation wizard page, click Next.
  3. On the Start Page, select the I accept the terms of the License Agreement checkbox, enter your Product Key and Name, and click Next.
  4. On the Options Page, select the Custom radio button, enter your desired Product install path, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  5. On the second Options page, select the Visual C# and Visual Web Developer checkboxes within the Language Tools section, and the Tools checkbox within the .NET Framework SDK section. Click Install.

    Installation And Configuration of Microsoft Content Management Server: Part 1

    Feel free to install any additional features you may wish to use. The above selections are all that’s required to follow the examples in this book.

  6. Wait (or take a coffee break) while Visual Studio 2005 is installed. When the Finish Page appears, click Finish.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  7. From the Visual Studio 2005 Setup dialog, you can choose to install the Product Documentation (MSDN Library) if desired.
  8. From the Visual Studio 2005 Setup dialog, click Check for Visual Studio Service Releases to install any updates that may be available.
  9. Click Exit.

Installing MCMS 2002 Service Pack 2

Next, we will install MCMS Service Pack 2.

  1. From the Start Menu, click Run.
  2. In the Open textbox, enter IISRESET /STOP and click OK. Wait while the IIS Services are stopped.
  3. Double-click the SP2 installation package.
  4. On the Welcome to Microsoft Content Management Server 2002 SP2 Installation Wizard page, click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  5. Select the I accept the terms of this license agreement radio button, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  6. On the ready to begin the installation page, click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

    Wait while Service Pack 2 is installed.

  7. During installation you may be prompted for the MCMS 2002 SP1a CD-ROM.
  8. Once The Installation Wizard has completed page, click Finish.
  9. If prompted, click Yes on the dialog to restart your computer, which will complete the installation.
  10. Otherwise, from the Start Menu, click Run.
  11. In the Open textbox, enter IISRESET /START and click OK to restart the IIS services.

    Stopping IIS prior to the installation of SP2 avoids potential problems with replacing locked files during the installation, and can prevent the requirement to reboot.

Configuring the Development Environment

Before continuing, a few additional steps are required to configure the development environment. We will:

  • Configure the shortcut that opens Site Manager to bypass the Connect To dialog.
  • Install the MCMS website and item templates in Visual Studio.

Site Manager Shortcut

During the installation of SP2 the Site Manager Start-menu shortcut will be overwritten. To configure Site Manager to bypass the Connect To dialog, take the following steps:

  1. Select Start | All Programs | Microsoft Content Management Server.
  2. Right-click the Site Manager shortcut and click Properties.
  3. In the Target textbox, replace
    "C:\Program Files\Microsoft Content Management Server\Client\NRClient.exe" http:///NR/System/ClientUI/login.asp
    with
    "C:\Program Files\Microsoft Content Management Server\Client\NRClient.exe" http://localhost/NR/System/ClientUI/login.asp.
  4. Click OK.

It is possible to configure many different Site Manager shortcuts pointing to different MCMS entry points. However, for this book we will only use the entry point on localhost, which is the only supported configuration for MCMS development.

Visual Studio Templates

The installation of MCMS Service Pack 2 automatically registers the MCMS developer tools such as MCMS Template Explorer in Visual Studio 2005. However, before we can create MCMS applications with Visual Studio, we need to make the website and item templates available.

  1. Select Start | All Programs | Microsoft Visual Studio 2005 | Visual Studio Tools | Visual Studio 2005 Command Prompt.
  2. Execute the following commands, replacing MCMS_INSTALL_PATH with the install location of MCMS (usually C:\Program Files\Microsoft Content Management Server) and PATH_TO_MY_DOCUMENTS_FOLDER with the location of your My Documents folder:

    xcopy "MCMS_INSTALL_PATH\DevTools\NewProjectWizards80\Visual WebDeveloper" "PATH_TO_MY_DOCUMENTS_FOLDER\Visual Studio 2005\Templates\ProjectTemplates\Visual Web Developer"/E

    xcopy "MCMS_INSTALL_PATH\DevTools\NewItemWizards80\Visual WebDeveloper" "PATH_TO_MY_DOCUMENTS_FOLDER\Visual Studio 2005\Templates\ItemTemplates\Visual Web Developer"/E

  3. Execute the following command to register the templates with VisualStudio 2005:

    devenv /setup

  4. Close the command prompt.

This completes the steps to upgrade to SP2, and our environment is now ready for development! We can test our installation by viewing the version number in the SCA, connecting with Site Manager, or by using the Web Author. Of course, any existing MCMS web applications will at this time still be hosted by.NET Framework v1.1.

It is not necessary at this stage to register ASP.NET as detailed in the Microsoft Installation Instructions (KB 906145). This registration was performed by the Visual Studio 2005 installer.

Additionally it is unnecessary to configure IIS to use ASP.NET 2.0 using the Internet Information Services Snap-In, as Visual Studio 2005 automatically sets this option on each MCMS website application created.
However, if you are installing on Windows Server 2003, you must configure the Virtual Website root and the MCMS Virtual Directory to use ASP.NET 2.0, as it is not possible to use two versions of ASP.NET within the same Application Pool.

The ActiveX controls that are part of HtmlPlaceholderControl are updated with SP2. Therefore you will be prompted to install this control when first switching to edit mode.
If you have pre-installed the controls using regsvr32 or Group Policy as detailed at http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#51C0CE4B-FC57-454C-BAAE-12C09421B57B, you might also be prompted, and you will need to update your distribution for the controls.

At this stage you can also choose to upgrade SQL Server or move forward.

Preparing the MCMS Database for SQL Server 2005

Before upgrading our SQL Server installation to SQL Server 2005, we need to prepare the MCMS database so that it is compatible with SQL Server 2005.

  1. Request the following MCMS hotfix from Microsoft:
    http://support.microsoft.com/?kbid=913401.
  2. Run the hotfix executable to extract the files to a local folder, e.g. c:\913401.
  3. Copy both of the files (_dca.ini and _sp1aTosp2upgrade.sql) to the MCMS SQL install folder (typically c:\Program Files\Microsoft Content Management Server\Server\Setup Files\SQL Install). Overwrite the existing files.
  4. Delete the temporary folder.
  5. Select Start | Microsoft Content Management Server | Data Configuration Application.
  6. On the splash screen, click Next.
  7. In the Stop Service? dialog, click Yes.
  8. On the Select MCMS Database page, click Next.
  9. In the Upgrade Required dialog, click Yes.
  10. On the Upgrade Database page, click Next.
  11. In the Add an Administrator dialog, click No.
  12. On the Database Configuration Application page, uncheck the Launch the SCA Now checkbox and click Finish.
Enhancing Microsoft Content Management Server with ASP.NET 2.0 Use the powerful new features of ASP.NET 2.0 with your MCMS Websites
Published: August 2006
eBook Price: £14.99
Book Price: £23.99
See more
Select your format and quantity:

Upgrading SQL Server 2005

Before proceeding, be sure to have the details of your existing SQL Server Service Account, which you will need during the upgrade process.

  1. Insert the SQL Server 2005 CD-ROM or DVD.
  2. On the splash screen, click the Server components, tools, Books Online, and samples link within the Install section.
  3. On the End User License Agreement dialog, select the I accept the licensing terms and conditions checkbox and click Next.
  4. On the Installing Prerequisites dialog, click Install and wait while the prerequisites are installed.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  5. Once complete, click Next, and wait while the System Configuration Check completes.
  6. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.
  7. On the System Configuration Check page, all Actions should report a Status of Success.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  8. Click Next and wait while Setup prepares the installation.
  9. On the Registration Information page, personalize your installation details, enter your product key, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  10. On the Components to Install page, select the SQL Server Database Services and Workstation components, Books Online and development tools checkboxes, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  11. On the Instance Name page, select the Default instance radio button, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  12. On the Existing components page, check the SQL Server Database Services 8.00.2039 checkbox, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  13. On the Upgrade Logon Information page, select the Windows Authentication Mode radio button, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

    Wait while the upgrade is analyzed.

  14. On the Service Account page, select SQL Browser from the Service combo box, enter your SQL Server Service Account details, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  15. On the Error and Usage Report Settings page, choose if you would like to submit error and usage reports to Microsoft, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  16. On the Ready to Install page, click Install.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  17. Wait while SQL Server is upgraded, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  18. On the Completing Microsoft SQL Server 2005 Setup page, click Finish.

    Installation And Configuration of Microsoft Content Management Server: Part 1

To avoid possible ODBC errors while saving in the Web Author following an upgrade to SQL Server 2005, perform an IISRESET on the MCMS server machine. Note that for a production system, we would stop IIS before upgrading the SQL Server instance.

Installing SQL Server 2005 Service Pack 1

We will now install Service Pack 1 for SQL Server 2005, which can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc.

  1. Double-click the installer file, and wait while the files are extracted.
  2. On the Welcome page, click Next.
  3. On the End User License Agreement page, check the I accept the licensing terms and conditions checkbox, and click Next.
  4. On the Feature Selection page, click Next.
  5. On the Authentication Mode page, click Next.
  6. On the Ready to Install page, click Install, and wait while the Service Pack is installed. During the installation, you may be prompted regarding Pending Reboot Files. If you are, click Yes.
  7. When the Locked Files Found dialog appears, click Continue.
  8. In the Computer Reboot Required dialog, click OK.
  9. Click Next, and on the Installation Complete page. click Finish.
  10. Restart your computer.

Modifying the CreateBackgroundProcessingJob Stored Procedure

Before proceeding, you need to modify one of the MCMS Stored Procedures to ensure its compatibility with SQL Server 2005.

  1. Select Start | All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio.
  2. In the Connect To dialog, click Connect.
  3. In the Object Explorer, expand the Databases folder, right-click the MCMS database, and click New Query.
  4. Open Internet Explorer and navigate to http://support.microsoft.com/default.aspx?id=906145#XSLTH3161121122120121120120.
  5. Copy and paste the SQL Script in the grey textbox to the Query Window in SQL Server Management Studio.
  6. On the SQL Editor toolbar, click the Execute button.
  7. Close SQL Server Management Studio.

This completes the steps to upgrade SQL Server 2005.

Fresh Installation of Microsoft Content Management Server 2002 Service Pack 2

This section details the steps required to perform a fresh installation of SP2 using SQL Server 2005. All components are installed on a single machine and to their default locations. The following installation order provides all necessary prerequisites and is the optimal installation order from a time perspective. We start with a base installation of Windows XP Professional SP2, with all Windows updates installed. The outline process for the installation is as follows:

  • Configure Local Security Policy.
  • Create Service Accounts.
  • Install Internet Information Services.
  • Configure Internet Information Services.
  • Install SQL Server 2005.
  • Install SQL Server 2005 SP1.
  • Configure SQL Server 2005.
  • Bypass installation of Visual Studio.NET 2003.
  • Install MCMS 2002 prerequisites.
  • Install MCMS 2002 SP1a.
  • Remove temporary items.
  • Install Visual Studio 2005.
  • Install MCMS 2002 SP2.
  • Configure MCMS using the Database Configuration Application.
  • Configure the development environment.

We will perform all steps while logged on as a local machine administrator.

Configuring Local Security Policy

In order to authenticate Service Account identities, we need to modify the Windows XP Local Security policy. Note that this section is not required if your machine is a member of a domain.

  1. Select Start | Control Panel.
  2. Double-click Administrative Tools, and double-click Local Security Policy. (If you do not see Administrative Tools, click the Switch to Classic View link.)
  3. Expand the Local Policies node, and click the Security Options node.
  4. In the Policy pane, scroll to locate the Network access: Sharing and security model for local accounts item and then double-click it.
  5. Set the combo box to Classic – local users authenticate as themselves and click OK.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  6. Close Local Security Settings and Administrative Tools.

Creating Service Accounts

We will create two Service Accounts, one for use by SQL Server and one for the MCMS System Account.

  1. From the Desktop, right-click My Computer and select Manage.
  2. In Computer Management, expand the Local Users and Groups node.
  3. Right-click on the Users folder and click New User.
  4. In the New User dialog, enter mssql in the User name textbox.
  5. Provide a Full Name and Description.
  6. Provide a Password.
  7. Uncheck the User must change password at next logon checkbox.
  8. Check the User cannot change password and Password never expires checkboxes and click Create.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  9. In the New User dialog, enter mcmssys in the User name textbox.
  10. Provide a Full Name and Description.
  11. Provide a Password.
  12. Uncheck the User must change password at next logon checkbox.
  13. Check the User cannot change password and Password never expires checkboxes and click Create.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  14. Close the New User dialog and close Computer Management.
Enhancing Microsoft Content Management Server with ASP.NET 2.0 Use the powerful new features of ASP.NET 2.0 with your MCMS Websites
Published: August 2006
eBook Price: £14.99
Book Price: £23.99
See more
Select your format and quantity:

Installing Internet Information Services

The following steps detail the installation of the minimal required components of Internet Information Services (IIS). Any differences to the procedure when installing on Windows Server 2003 SP1 are noted.

  1. Select Start | Control Panel.
  2. Double-click Add or Remove Programs.
  3. Click Add/Remove Windows Components.
  4. In the Windows Components Wizard, click (note: not check) Internet Information Services (IIS) followed by Details.
  5. In the Internet Information Services (IIS) dialog, click (note: not check) World Wide Web Service followed by Details.
  6. In the World Wide Web Service dialog, check the World Wide Web Service item and click OK.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  7. Ensure that the Common Files, Internet Information Services Snap-In, and World Wide Web Service have been selected. Click OK.

    Installation And Configuration of Microsoft Content Management Server: Part 1

    It is not necessary to install FrontPage 2000 Server Extensions despite the requirement being stated in the product documentation, and during the installation of Visual Studio.NET 2003 later.

  8. Click Next and wait while IIS is installed; you may be prompted to insert your Windows XP CD-ROM.
  9. Click Finish when the Completing the Windows Component Wizard page appears, and close Add or Remove Programs.

    When installing on Windows Server 2003 SP1.
    Install the Application Server Role with ASP.NET (but not FrontPage Server Extensions) using the Manage My Server application. Then use Add or Remove Programs... Windows Components to add Active Server Pages and Server Side Includes. IIS Manager cannot be used to enable these; Add or Remove programs must be used or the MCMS installer will not recognize them!
    In addition, create a new virtual website to host the Server Configuration Application. This site should be configured to use Windows Authentication and deny access from hosts other than localhost. Preferably this site hosting the SCA should also use Secure Sockets Layer (SSL). If this is not possible, configure the site to use a port other than 80.

Configuring Internet Information Services

We will initially configure IIS to use Windows Authentication. Later in the book we will explore alternative authentication methods.

  1. From the Start Menu, click Run.
  2. In the Open textbox, enter inetmgr and click OK.
  3. Expand the Local Computer node, and the Websites folder.
  4. Right-click Default Website and click Properties.
  5. Click the Directory Security tab, and within the Anonymous access and authentication control frame, click Edit.
  6. Uncheck the Anonymous Access checkbox and select the Integrated Windows Authentication checkbox, and click OK.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  7. Click OK, and close Internet Information Services.

Installing SQL Server 2005

The following steps detail the installation of SQL Server 2005:

  1. Insert the SQL Server 2005 CD-ROM or DVD.
  2. On the splash screen, click the Server components, tools, Books Online, and samples link within the Install section.
  3. In the End User License Agreement dialog, select the I accept the licensing terms and conditions checkbox and click Next.
  4. In the Installing Prerequisites dialog, click Install and wait while the prerequisites are installed.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  5. Once complete, click Next, and wait while the System Configuration Check completes.
  6. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.
  7. On the System Configuration Check page, all Actions should report a Status of Success.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  8. Click Next and wait while Setup prepares the installation.
  9. On the Registration Information page, personalize your installation details, enter your Product Key, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  10. On the Components to Install page, select the SQL Server Database Services and Workstation components, Books Online and development tools checkboxes, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  11. On the Instance Name page, select the Default instance radio button, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  12. On the Service Account page, select the Use a domain user account radio button and enter the Service Account details for the mssql account. Check the SQL Server Agent and SQL Browser checkboxes, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  13. On the Authentication Mode page, select the Windows Authentication Mode radio button, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  14. On the Collation Settings page, click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  15. On the Error and Usage Report Settings page, choose if you would like to submit error and usage reports to Microsoft, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  16. On the Ready to Install page, click Install.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  17. Wait while SQL Server is installed, and click Next.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  18. On the Completing Microsoft SQL Server 2005 Setup page, click Finish.

    Installation And Configuration of Microsoft Content Management Server: Part 1

This completes the steps to install SQL Server 2005.

Installing SQL Server 2005 Service Pack 1

We will now install Service Pack 1 for SQL Server 2005, which can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc.

  1. Double-click the installer file and wait while the files are extracted.
  2. On the Welcome page, click Next.
  3. On the End User License Agreement page, check the I accept the licensing terms and conditions checkbox, and click Next.
  4. On the Feature Selection page, click Next.
  5. On the Authentication Mode page, click Next.
  6. On the Ready to Install page, click Install, and wait while the Service Pack is installed. During the installation, you may be prompted regarding Pending Reboot Files. If you are, click Yes.
  7. When the Locked Files Found dialog appears, click Continue.
  8. In the Computer Reboot Required dialog, click OK.
  9. Click Next, and on the Installation Complete page, click Finish.
  10. Restart your computer

Configuring SQL Server 2005

We will now configure our installation of SQL Server 2005 and create a database for use by our MCMS applications.

  1. Select Start | Programs | Microsoft SQL Server 2005 | Microsoft SQL Management Studio.
  2. In the Connect to Server dialog, select your server in the Server name combo box, Windows Authentication in the Authentication combo box, and click Connect.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  3. In the Object Explorer, right-click the Database folder, and click New Database
  4. In the Database name textbox, enter TropicalGreen, click OK, and wait while the database is created.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  5. In the Object Explorer, expand the Security folder.
  6. Right-click the Logins folder, and click New Login.
  7. In the Login name textbox, enter MACHINENAME\mcmssys.
  8. In the Default database combo box, select TropicalGreen.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  9. Click the User Mapping item within the Select a page pane.
  10. In the Users mapped to this login grid, click the Map checkbox for the TropicalGreen database.
  11. In the Database role membership grid, check the db_datareader, db_datawriter, and db_ddladmin checkboxes.

    Installation And Configuration of Microsoft Content Management Server: Part 1

  12. Click OK, and close SQL Management Studio.

Bypass the Installation of Visual Studio.NET 2003

MCMS SP1a requires an installation of a previous version of Visual Studio.NET to enable the Developer Tools component, prior to installing SP2. Installing Visual Studio.NET 2003 is both time consuming and undesirable. It is possible to bypass this requirement using the following procedure, which tricks the SP1a installer into thinking Visual Studio .NET 2003 is installed.

  1. Request the following MCMS hotfix from Microsoft: http://support.microsoft.com/?kbid=915190
  2. Run the hotfix executable to extract the files to a local folder, e.g. c:\kb915190.
  3. Use Windows Explorer to create a folder, e.g. c:\VSTemp.
  4. Select Start | Run.
  5. In the Run dialog, type cmd and click OK.
  6. Execute the following commands: cd c:\kb915190 cscript VS2003ByPass.vbs c:\VSTemp

>> Continue Reading: Installation And Configuration of Microsoft Content Management Server: Part 2

[ 1.a | 1.b | 2 | 3 ]

If you have read this article you may be interested to view :

About the Author :


Lim Mei Ying

Lim Mei Ying is a Senior Consultant at Avanade, a global technology integrator specializing in the Microsoft platform. Mei Ying has extensive experience in designing, implementing and supporting enterprise web applications as well as setting up Microsoft Content Management Server (MCMS) systems across the enterprise. An active contributor to the Microsoft newsgroup community, she has spent many hours figuring out the dos and don'ts of MCMS technologies, and thrives on the challenge of finding new ways to solve MCMS-related problems. Mei Ying, who has earned the prestigious title of Microsoft's Most Valuable Professional award for Content Management Server. Mei Ying lives on the sunny island of Singapore and blogs at meiyinglim.blogspot.com

Spencer Harbar

Spencer, a MCSD for Microsoft .NET, MCSE and MVP for MCMS, has over twelve years commercial experience of architecture, design, development, deployment and operational support of Web based applications and hosting platforms for some of Europe's largest organisations.

Spencer maintains www.mcmsfaq.com - a MCMS resources portal, and is active in the public newsgroups. His experience of MCMS goes back to the days of NCompass Resolution and he has been involved in many enterprise implementations.

Currently working as an independent consultant, Spencer delivers enterprise content management and portal systems architecture, design, development and deployment solutions, application security best practices, threat modeling and the implementation of highly available Windows Server System based hosting platforms.

Product expertise includes MCMS, SharePoint Technologies, IIS, SQL Server, Commerce Server and BizTalk Server, Windows Security, PKI and High Availability.

Selected clients include Barclays Bank, Scottish Power plc, HBOS, Microsoft, The Royal Bank of Scotland, Scottish Enterprise, Centrica, Clifford Chance, The Automobile Association and BASF

Stefan Goßner

Stefan Goßner works for Microsoft as an Escalation Engineer in the Developer Support department. He provides customers with technical solutions to problems related to Microsoft Internet Server Products. Stefan has breadth and depth in all areas of MCMS.

His contributions to the newsgroup have helped many people to implement MCMS solutions in corporations around the globe to the point where it has been said that if you don't know Stefan, then you're probably new to MCMS.

Stefan maintains a huge MCMS 2002 FAQ on the Microsoft Website and provides MCMS tips and tricks on his personal blog: http://blogs.technet.com/stefan_gossner.

He lives in Munich, Germany.

Books From Packt


Drupal 6 Performance Tips
Drupal 6 Performance Tips

Grok 1.0 Web Development
Grok 1.0 Web Development

CMS Made Simple 1.6: Beginner's Guide
CMS Made Simple 1.6: Beginner's Guide

Learning jQuery 1.3
Learning jQuery 1.3

Building Websites with Joomla! 1.5
Building Websites with Joomla! 1.5

Drupal: Creating Blogs, Forums, Portals, and Community Websites
Drupal: Creating Blogs, Forums, Portals, and Community Websites

Magento 1.3: PHP Developer's Guide
Magento 1.3: PHP Developer's Guide

PHP 5 E-commerce Development
PHP 5 E-commerce Development


Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software