SQL Server - Installation of Microsoft SQL Server 2008 Management Studio Express (SSMS)

Card Puncher Data Processing

About

Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server 2008 Management Studio Express combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels.

This article talk about its installation on a Windows 2003 server.

Prerequisites

Steps

Start the installation

  • Install Powershell
  • Double click the SQL Server 2008 Management Studio Express installation file : SQLManagementStudio_x86_ENU
  • The Sql Server installation screen show up
  • Click on Installation > New Sql Server stand alone installation

or add features to an existing installation

Setup Support Tools

  • Setup Support Tools : Operation Completed. Passed: 6 Failed 0 Warning 0 Skipped 0 - Click Ok

Installation

A new installation wizard process show up and you can see the steps in the left pane of the screen :

  • Setup Support Files : Some checked are performed and must be passed.
  • Installation Type : Choose Perform a new installation of Sql Server 2008.

You can remark than the previous instances installation are listed.

Sql Management 2 Installation Type

  • Product Key : Skip
  • License Term : Verify that the licence talk about the installation of Microsoft SQL Server 2008 Management Studio Express, accept it and hit next
  • Feature Selection : Select All
  • Disk Space Requirement : Hit Next
  • Error and usage reproting : Hit Next
  • Installation Rules : Checks are performed and must return no failed and warning.
  • Ready To Install : Review the summary and hit Install

Sql Management 9 Ready To Install

  • Installation Progress
  • Complete

Sql Management 11 Complete

Success. You can find it in the Start Menu.

Sql Management 12 Start Menu

Configuration

  • Uncheck : Tool > Options > SQL Server > Include the query in the result set
print 1

will print

1

and not

/*------------------------
print 1
------------------------*/
1

Support

Windows firewall warning

Sql Server Windows Firewall Warning





Discover More
Card Puncher Data Processing
SQL Server - Installation

With docker: Sql Server 2008: Client Installation Azure:
Installation Sql Server 2008 8 Instance Configuration
SQL Server - Installation Express 2008

This article talk the installation of SQL Server Express 2008 on Windows Server 2003 X86. (If you use an other platform, just choose the file for your operating system). You can do an on-line installation...
Sql Server Sysadmin
SQL Server Database ACME_POS Installation for the book Oracle Warehouse Builder Getting Started 11g

“” This article refer to the creation of the database ACME_POS in a SQL Server and the load of the data set that you need to perform the tutorial of the bookACME_POS database scriptinstallatiACME_POS_Bulk_Load_Data.bat...



Share this page:
Follow us:
Task Runner