安装sql server managerment studio报错"The instance id is required but it is missing"

时间:2022-02-17 00:33:35

问题描述:

今天在安装sql server managerment studio的时候提示报错"The instance id is required but it is missing"。操作步骤如下:

  1. 打开SQLManagementStudio_x64_ENU.exe这个安装程序
  2. 选择Add fetures to an exisiting instance of SQL Server 2008
  3. 点击next,如下图所示(下图是sql server 2008 r2的,原先使用sql server 2008就报错)

安装sql server managerment studio报错"The instance id is required but it is missing"

原因:

  我本机上安装的是sql server 2008 r2版本。但是我下载的确是sql server 2008的managerment stuido,而又选择了“Add fetures to an exisiting instance of SQL Server 2008”,所以报错。因为本机上根本没有sql server 2008的instance,只有sql server 2008 r2的instance