2008 R2 安装后缺少 SQL Server Management Studio [英] SQL Server Management Studio Missing after 2008 R2 Install

问题描述

刚刚在我的 XP 机器上安装了 SQL Server 2008 R2 Developer Edition.没有 SQL Server Management Studio (SSMS) 的迹象.阿尔.而且我似乎看不到添加功能"中可用的特定选项.我该怎么办?

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?

我确实注意到我的机器已经安装了 SQL Server 2008 的安装文件.所以我卸载了所有东西 - 首先是 R2，然后是 2008 年的设置，现在当我重新安装 R2 时，功能列表中仍然没有 SSMS 选项.

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.

帮助！

推荐答案

您需要转到控制面板，添加/删除功能，选择 SQL Server 2008 R2，然后单击卸载/更改.

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.

此时您必须指向安装文件.因此，如果您有 DVD，则需要指向 DVD 驱动器，否则，如果您已安装 ISO 或在本地或网络上拥有安装文件，则必须指向包含 setup.txt 的文件夹.exe.识别安装文件后，您将:

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:

• 在设置支持文件"对话框中说确定"
• 点击设置支持规则"对话框中的下一步
• 在安装类型"对话框中选择全新安装或添加共享功能"，然后点击下一步
• 点击产品密钥"对话框中的下一步(应该为您预先填充，如果这是零售产品，您可能需要输入产品密钥)
• 接受许可条款并点击下一步
• 安装角色应该是SQL Server 功能安装"，然后点击下一步
• 在功能选择"对话框中，您应该会看到管理工具 - 基本"和管理工具 - 完成"选项 - 确保它们都被选中，然后点击下一步
• 点击下一步、下一步、下一步、下一步、安装

以下是选中管理工具 - 基本"和管理工具 - 完整"后功能选择"对话框的外观的屏幕截图:

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":

(如果它们已被选中，请取消并退出设置 - Management Studio 已安装.)

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

安装完成后，您应该会在以下位置找到ssms.exe:

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

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\

如果您使用的是 32 位机器，我很抱歉.你必须看这里:

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

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\

这篇关于2008 R2 安装后缺少 SQL Server Management Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！