Thursday, 27 September 2012

Installing SQL Server Management Studio 2008 Express



Installing SQL Server Management Studio 2008 Express


Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 R2 SP1 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008 R2 SP1.

System requirements

Supported operating systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista
    • Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows 7, Windows Vista, Windows XP
  • Processor
    • Pentium III - compatible processor with a minimum speed of 1 GHz or a faster processor
  • RAM
    • Minimum 512 MB for SQL Server Express with Tools, and SQL Server Express with Advanced Services and 4 GB for Reporting Services that installs with SQL Server Express with Advanced Services
  • Hard Disk Space
    • 2.2 GB of Disk Space

Limitations :
SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage


STEP 1: Download Microsoft® SQL Server® 2008 Management Studio Express and select either SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe depending on your machine’s OS bit-ness. I’m running Windows 7-64 bit so I’ll be detailing the steps as it pertains to that OS.

STEP 2: Make sure you’re logged in as an administrator of the machine then right-click on the exe you downloaded and select “Run as Administrator”. If you’re on Windows 7 then you’ll get a compatibility warning. Click past it for now to continue with the install. Later you’ll need to apply SQL 2008 Service Pack 2.

STEP 3: You should now see the “SQL Server Installation Center” window. Yes it looks scary. Select the “Installation” tab.

image

STEP 4: Select “New SQL Server stand-alone installation or add features to an existing installation”. It will then run a rule check. Make sure there are no failures and then click OK.

image

STEP 5: The next step is misleading. The Setup Support Files window looks like it’s doing something and stuck on “Gathering user settings.” It’s actually waiting for you to click the Install button! Doh!

image

STEP 6: Another rule check. You’ll probably end up with a Windows Firewall warning this time. If you want to enable remote access to SQL Server you’ll need to configure the firewall later. Since I’m using SQL Server Express for development purposes on this machine only, I won’t need to worry about that. Click Next.

image

STEP 7: On the Installation Type window you have a choice between “Perform a new installation of SQL Server 2008” OR “Add features to an existing instance of SQL Server 2008”. 

You need to select new installation, NOT add features.  Click Next.

image

STEP 8: Next you get the Product Key window. You obviously don’t need a product key for SQL Server Express since it’s free so just click Next.

image

STEP 9: Accept the License Terms and click Next.

image

STEP 10: Okay now for the window we’ve all been waiting for - Feature Selection. Check off “Management Tools – Basic” and then click Next.

image

STEP 11: Verify your disk space requirements and click Next.

image

STEP 12: Help Microsoft improve SQL Server features and services by selecting to send usage and error reports to them (or not). Click Next.

image

STEP 13: Another quick rule check runs. Click Next.

image

STEP 14: Now it looks like we’re ready to install. Click the Install button.

image

The install will kick off and will take about 5 minutes to complete.

STEP 15: Once the installation completes, click the Next button again.

image

STEP 16: Complete! Click the Close button and you should be all set.

image

STEP 17: Fire up SQL Server Management Studio! You should now see it in your Programs under Microsoft SQL Server 2008. Make sure you run it as an administrator for access to all the features.

image

And don’t forget at some point to install the latest SQL Server 2008 Service Pack

Source: Blogged by Beth Massi @ MSDN Blogs 




No comments :

Post a Comment