Paul Kimmel's Blog

I wrote this blog in support of a reader question about using the TotalFlight database for Professional DevExpress ASP.NET Controls with SQL Server 2008. Basically, if you install VS2010 beta or SQL Server EXPRESS 2008 SSMS (SQL Server Management Studio) is not installed. You can follow these instructions to install SSMS 2008.

Google for SSMS 2008 or use this link to go to the SQLEXPRESS 2008 download page and download the appropriate (x84 or x64 installation file). The installation program has a couple of dozen links, so its not really that clear. These instructions should lead you to the quickest route to the installation.

1. http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en
2. Save of Run the installation file. If you save it (about 240M) then run after the download is complete.
3. The first screen looks like Figure 1 with a lot of links. I installed on an x86 box running Windows 7 with SQLEXPRESS 2008 already installed. (You may have to tinker a bit if your configuration is vastly different.)
4. On screen 1 click the Installation link on the left.
5. On the Installation view click the New SQL Server stand-alone installation or add features to an existing installation link (Figure 2).
6. On the Setup Support Rules page click OK to install the setup support rules Figure 3).
7. On the next page click install to install setup support rules (no figure provided).
8. Click next after the rules report a has run unless you get some errors (see Figure 4).
9. Click Next to go to the next step. (This is where things are a little weird, see Figure 5.)
10. Leave the Perform a new installation of SQL Server 2008 checked and click Next. (It seems intuitive that you might check add features, but this doesn’t seem to get us where we want—installing SSMS).
11. Click Next on the Product Key page; no product key is required.
12. Check “I accept the license terms” and click Next.
13. On the Feature Selection step—see Figure 6—under Shared Features click Management Tools and click Next.
14. Click Next on Disk Space Requirements assuming you have the space available.
15. Click next on Error and Usage Reporting unless the holidays have you feeling like a good Samaritan.
16. The Installation Rules runs again--~snooze~
17. Click Next
18. Finally, (whew!) on the Ready to Install page click Install (see Figure 7).

I think no one read Alan Cooper because this all-in-one install process makes me think that the inmates are indeed loose and running the asylum. You could try searching for the SSMS install package and running it directly, but I found a few forum posts that indicated that this approach fails.

If you are reading Professional DevExpress ASP.NET Controls over the holidays—and again are feeling generous—then post a review on Amazon or my blog. I actually read these things good and bad and try to update information or use what I learn for future projects.

Happy Holidays!

Figure 1: Click the Installation link on the left.

Figure 2: Click the New SQL Server stand-alone installation or ad features to an existing installation.

Figure 3: Click OK to install the setup support rules.

Figure 4: Setup support rules detailed report.

Figure 5: Leave the perform a new installation of SQL Server 2008 checked.

Figure 6: Click Management Tools under shared features

Figure 7: SQL Server Management Studio 2008.