THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.

Some tips on SSMS Express Edition setup

I posted earlier that the Express Edition of Management Studio for SQL Server 2008 R2 (November CTP) is now available for download.

During the first few pages in the setup wizard, I was certain that I had either downloaded the wrong version of the CTP, or else had launched the wrong one by mistake.  So, I thought it might be useful to share a few of my experiences that were confusing during this process.

When you launch the setup for SSMSE (either SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe), you get what feels like the *full* SQL Server setup.  On the initial screen, you choose "New SQL Server stand-alone installation or add features to an existing installation."  Then you pick "Perform a new installation of SQL Server 2008" (click to enlarge):

 

When you hit Next, you get this screen, which certainly makes it seem like you are installing an Engine instance (click to enlarge):

 

But then you finally see this screen, which makes everything all right (again, click to enlarge):

 

As a side note, ake a look at the first screen shot.  See the window that's open in the background?  That's the Installation Center; DO NOT CLOSE IT until setup is complete.  For some reason, the installation process you launch from this window is tied to a temporary folder, and if you close the Installation Center window, the temporary folder gets deleted (even though the setup program is not finished using it).  This will lead to the following error (note that yours will have a different value for the file, since your path will be based on a different GUID):


Actually this last item is an issue of all editions of SQL Server setup, including 2008 RTM and even service pack installations.  I complained about it here, but to no avail so far:

Connect #388671 : Installation Center must stay open throughout setup

Published Wednesday, November 11, 2009 7:38 PM by AaronBertrand

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

uberVU - social comments said:

This post was mentioned on Twitter by aaronbertrand: [Blog] : Some tips on SSMS Express Edition setup : http://is.gd/4SXd7

November 12, 2009 5:48 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement