Skip to main content

Microsoft SQL Server 2008 Management Studio Express

sqlserver2008gridvr2.png

Microsoft offers a free tool, the Microsoft SQL Server 2008 Management Studio Express, as a convenient means of managing and editing entries in SQL databases through a GUI. The SQL Server 2008 license comes with the full version of the Management Studio, but the Express version is still very functional for the day-to-day operations. However, finding the stand-alone version of the software is quite a pain. Most people don't need to install a SQL server on their machine, but that is the most promoted means of getting the Management Studio Express.

You can download it from here
https://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displayLang=en
( 32-bit (168.3 MB) or 64-bit (176.5 MB))

Before you Install:
Microsoft .Net Framework 3.5 SP1
Windows Installer 4.5
Windows PowerShell 1.0


How to Install:

Once the installer starts, select "Installation" from the left column. The options on the right will change to match your selection. When they update, click the top link 'New SQL Server stand-alone installation or add features to an existing installation'.
addfeatures.png

Follow the on-screen instructions and when you get to the Feature Selection screen put a check in the box in front of Management Tools – Basic. You should be able to select the defaults through the rest of the installation unless you want to customize it a bit.
selecthvs.png

After the install completes, you should find an entry on your Start Menu for Micrsofot SQL Server 2008 and under that folder the SQL Server Management Studio shortcut lives.
startmenuw.png

Clicking on the shortcut should successfully launch the Management Studio and prompt you to login to your SQL instance.
connectr.png

If you're getting this error after installation:

The file C:\Windows\Microsoft.NET\Framework\version_number\mscorlib.tlb could not be loaded. An attempt to repair this condition failed because the file could not be found. Please reinstall this program.
 
  • you can Reinstall Microsoft® SQL Server® 2008 Management Studio Express
                or

Comments

Anonymous said…
i am getting problem of ..windows power shell..

kindly let me know how to solve this issue
you gotto install power shell before installing SQL.did you try reinstall everything.
Anonymous said…
ӏch habe onlіne mеhr als drei Stunden gebrоweѕd ,аber kaum Eintraegе gefundеn, dіe ѕo intereѕѕant wie deine sinԁ.
Das ist еcht suрeг fuer mich!
Here is my weblog :: samp Roleplay