Tim Elhajj

Off the Microsoft stack!


How to Install SQL Server 2008 Management Studio Express for TFS basic

Two nice thing about SQL Server Express: its low-cost (free!) and ease of use. Often you don’t even install it: another program handles the install for you, as Team Foundation Server can with its basic install. But occasionally you may find you need to do some management tasks with your database backend. For example, you might want to back up your data prior to upgrade. For situations like that, you can download and use SQL Server 2008 Management Studio Express (SSMSE) to manage SQL Server Express.

This post describes how to install SSMSE.

If you’re installing SSMSE on Windows 7 or Windows Server 2008 R2, you get some crazy program compatibility error that looks like this when you run the installer:

You can safely ignore this message. From the page were you download SSMSE, you will find this message (in the middle of page):

For Windows 7 and Windows Server 2008 R2, the install process displays the “Program Compatibility Assistant” dialog indicating that you must apply SQL Server 2008 Service Pack 1 or later. Select the option to “Run Program” to continue. Future releases of Microsoft SQL Server 2008 R2 Management Studio Express will not have this problem.

An auspicious start, but it is a free tool! Let’s move on:

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on Windows server.

To install SQL Server 2008 Management Studio Express
  1. Launch the install program you downloaded. If you get the compatibility error, choose Run Program.
  2. On the SQL Server Installation Center page, choose Installation, and then choose New SQL Server stand-alone installation or add features to an existing installation.
  3. On the Setup Support Rules page, choose OK.
  4. On the Setup Support Files page, choose Install.
  5. On the Setup Support Rules page, choose Next.

    : A Windows Firewall warning might appear here, but you can ignore this warning. TFS automatically adds an exception for Windows Firewall during upgrade.
  6. On the Installation Type page, choose Perform a new installation of SQL SErver 2008 and then choose Next.

    Tip: I tried to add features to my existing instance of SQL Server Express, and the installer wouldn’t give me the option to install the tool. 😦
  7. On the Product Key page, choose Next.
  8. On the License Terms page, accept the license agreement and choose Next.
  9. On the Feature Selection page, select the check box for Management Tools – Basic and then choose Next.
  10. On the Disk Space Requirements page, choose Next.
  11. (Optional) On the Error and Usage Reporting page, specify whether to send information about errors and then choose Next.
  12. On the Installation Rules page, choose Next.
  13. On the Ready to Install page, review the information, and then choose Install.
  14. The Installation Progress page shows the status of each component. Choose Next.
  15. On the Complete page, choose Close.


How to Install and Configure MOSS 2010 for TFS 2010

This video shows how to install and configure MOSS 2010 for TFS 2010. MOSS offers the full featured TFS dashboard experience, but you have to setup MOSS on your own to use it with TFS. And the MOSS setup is somewhat complex.

In this video, we install MOSS on the same server as TFS and even go through the TFS installation. When you’re done with these steps, you’ll have a working installation of TFS 2010 with MOSS 2010.

What do you need to accomplish the steps in this video?

We assume you already have SQL Server setup (but if you don’t, check out this video for instruction). We use the TFS MOSS Configuration tool to configure MOSS 2010, so you’ll want to download it.

You’ll also need a single domain account. We use a single domain account for two identities: 1) the account used to create reports in TFS (TFSREPORTS) and 2) the service account for MOSS (WSSERVICE). This account has to be permissioned with the “Log on as a Service” permission. You can find more information on the accounts required for installing TFS here.

You’ll also need a global security group from the domain that contains all the users to whom you want to grant access to dashboards and reports in TFS.

I don’t want to use the MOSS configuration tool. Where can I find the manual steps for configuring MOSS 2010 for TFS 2010?

At this point, no manual instructions exist. However, I have taken over this space and intend to make creating these instructions a priority. For now, you’ll have to use the tool.

UPDATE: I have published the manual instruction for configuring MOSS 2010 on MSDN. If you’re more of a watch and learn kind of gal (or guy), you can also check out this video I created that walks you through the entire process.

Speaking of the tool, I found a bug in it on MOSS 2010 during the making of this video, but working with the product unit, we found a workaround for the bug, so I wanted to mention the workaround here.

Where can I find the manual steps for the other procedures in this video?

Glad you asked: