

Management Tools: Installs SQL Server Management Studio Express only. SQL Server Management Studio Express (,) and should be used if you require data storage and the ability to manage SQL Server and your databasesĭatabase with Advanced Services: This package installs the SQL Server database engine, SQL Server Management Studio Express, the ability to runįull-Text Search () queries against the database, and the ability to generate reports from the database using Reporting Services (,) you would select this package.ĭatabase with Management Tools: This package installs the SQL Server database engine as well as the For example, if you are using an application that requires SQL Server Express and does not specify that it requires Each package and the features it contains are described below.ĭatabase Only: This package installs only the SQL Server database engine and should be used if you only require data storage. Installation package is right for you, this article provide guidance on:Īll installation packages for SQL Server 2008R2 Express are available for download from the Microsoft download center, and are available in both 32-bit and 64-bit versions. There are multiple installation packages available for SQL Server Express, ranging from a minimal installation containing only the database engine to a full installation containing all optional components of the Express package. But I can't put this full DVD there because of storage limitations.Summary: This article is for end users to determine appropriate options for installing SQL Server 2008 R2 Express and guidance on when customizing the installation may be necessary. In the past, when we were using 2005, I was able to just put Business Intelligence-Management

Now my team of users only needs the Management Studio for doing SQL queries. I also have a multi-license deal for this.


I have the Full MS SQL Server 2008 DVD (4.3 GB). Keep following the wizard till you see the option of selecting Management Studio (and other additional features that you would like - but definitely not the database engine since you have that already (probably) in other server. Once you click that, you should see the option on the right that says New SQL Server Stand Alone installation.etc. Initially I was trying to look at Tool and could not find there. Once you click Setup.exe you should see the menu on the left that says PLanning, Installation, Maintenance, If you have SQL Server 2008 Full Installation(not the express edition) and would like to install the Management Studio, you can find it there.
