Cara Install Sql Server 2008 Management Studio Express

1. Sql Server Management Studio Express
2. Install Sql Server 2008 R2
3. Cara Install Sql Server 2008 Management Studio Express Free
4. Sql Server 2008

Just installed SQL Server 2008 R2 Developer Edition on my XP box. There is no sign of SQL Server Management Studio (SSMS). Aarg. And I can't seem to see that specific option available in Add Features. What do I do?

Feb 18, 2011  Step-by-Step: Installing SQL Server Management Studio 2008 Express after Visual Studio 2010. STEP 14: Now it looks like we're ready to install. Click the Install button. The install will kick off and will take about 5 minutes to complete. STEP 15: Once the installation completes, click the Next button again.

• Workaround: install management studio on a different (than the citrix sql server) 2008 server (or workstation) and connect to the citrix sql over the network, this works fine.
• Step 4: Download SQL Server 2008 Management Studio Express by clicking the appropriate link later on this page. To start the installation immediately, click Run. To install SQL Server Express at a later time, click Save.

I did notice that my machine already had the setup files for SQL Server 2008 installed. So I uninstalled everything - first R2 then the setup for 2008, and now when I go to reinstall R2, still no option for SSMS in the feature list.

Help!

2 Answers

You need to go to Control Panel, Add/Remove Features, pick SQL Server 2008 R2, and click Uninstall/Change.

It will ask you if you want to Add, Repair or Remove. Pick Add.

At this point you will have to point to the setup files. So if you have the DVD you will need to point the DVD drive, otherwise if you've mounted the ISO or have the installation files locally or on the network, you'll have to point to the folder that holds setup.exe. Once the installation files are recognized, you will:

• say OK on the 'Setup Support Files' dialog
• click Next on the 'Setup Support Rules' dialog
• choose 'New Installation or Add Shared Features' on the 'Installation Type' dialog and click Next
• click Next on the 'Product Key' dialog (it should be pre-populated for you, or you may have to enter the product key if this is retail)
• accept the License Terms and click Next
• Setup Role should be 'SQL Server Feature Installation' and click Next
• On the 'Feature Selection' dialog, you should see options for 'Management Tools - Basic' and 'Management Tools - Complete' - make sure they both become checked, and click Next
• Click Next, Next, Next, Next, Install

Here is a screen shot of what the 'Feature Selection' dialog should look like once you've checked 'Management Tools - Basic' and 'Management Tools - Complete':

(If they're already checked, cancel and get out of setup - Management Studio is already installed.)

When installation has finished, you should find ssms.exe in the following location:

If you're on a 32-bit machine, I'm sorry. You'll have to look here instead:

In some cases the option is just not anywhere on the installation menu. Check my previous answer.

Basically just use the Web Platform Installer 4.0 and get this: Products > Database > 'Sql Server 2008 R2 Management Objects'. Then 'Management Tools' will be available, and follow previous answers.

Not the answer you're looking for? Browse other questions tagged sql-server-2008-r2 or ask your own question.

I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008.

Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't install it without installed the SQL Server by itself.

Is there a way to just install this software without setting up a brand new instance of a SQL Server?

3 Answers

You can download and install Microsoft SQL Server 2008 Management Studio Express from this Microsoft Download Center page.

Sql Server Management Studio Express

The Non express version only ships with SQL Server 2008 editions and cannot be sold or distributed separately.

The full version of Microsoft SQL Server Management Studio can be installed WITHOUT installing the server, and it can administer a SQL Server Express Edition.

Here's a tutorial (with screenshots) on how to do this: SQL Server 2008 Client Tools Installation

About SQL Server Management Studio Express Edition (from Wikipedia):

3 Answers

You can download and install Microsoft SQL Server 2008 Management Studio Express from this Microsoft Download Center page.

Sql Server Management Studio Express

The Non express version only ships with SQL Server 2008 editions and cannot be sold or distributed separately.

The full version of Microsoft SQL Server Management Studio can be installed WITHOUT installing the server, and it can administer a SQL Server Express Edition.

Here's a tutorial (with screenshots) on how to do this: SQL Server 2008 Client Tools Installation

About SQL Server Management Studio Express Edition (from Wikipedia):

Microsoft has also introduced a free edition known as the Express Edition. As with all of Microsoft's 'Express' products, this is downloadable as a standalone tool or integrated with a SQL Server Express edition at no charge. The tool's limitations lie in the fact that it cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, or SQL Server 2005 Mobile Edition.

Install Sql Server 2008 R2

Yes, it can be done but I only got this to work using SQL server Management studio 2005.

Works well with SQL 2008.

Cara Install Sql Server 2008 Management Studio Express Free

Sql Server 2008

Not the answer you're looking for? Browse other questions tagged sql-server-2008sql-management-studiosql-server-express or ask your own question.