Visual Studio和SQL Server-正确的安装顺序? [英] Visual Studio and SQL Server - correct installation sequence?

问题描述

我正在重建我的开发机器.这个问题对我来说并不陌生，但我不记得解决方案了. 我从SQL 2008 Developer开始，然后是VS 2008 Pro，然后是SQL SP1，然后是VS SP1.结果是我无法打开SSIS项目(请参见下面的错误).正确的顺序是什么，以便我可以避免安装SQL Server Express而仍然使所有功能正常工作?

I am rebuilding my development machine. This issue is not new to me, but I don't remember the solution. I started with SQL 2008 Developer, then VS 2008 Pro, then the SQL SP1, then VS SP1. The result is that I cannot open SSIS projects (see the error below). What is the correct order so that I can avoid the installation of SQL Server Express and still have all the features working?

---------------------------
Microsoft Visual Studio
---------------------------
Package Load Failure

Package 'DataWarehouse VSIntegration layer' has failed to load properly ( GUID =
{4A0C6509-BF90-43DA-ABEE-0ABA3A8527F1} ). Please contact package vendor for 
assistance. Application restart is recommended, due to possible environment 
corruption. Would you like to disable loading this package in the future? You 
may use 'devenv /resetskippkgs' to re-enable package loading.
---------------------------
Yes   No   
---------------------------

推荐答案

事实证明，我在问题中缺少2条重要信息，这使安装如此痛苦:

It turns out I was missing 2 important pieces of information in my question that make this installation such a pain:

• 我正在安装64位版本的SQL Server
• 我将其安装到非标准位置(即D:驱动器，因为C:是不是全部 那么大的空间)

• I was installing the 64 bit version of SQL Server
• I was installing to a non-standard location (i.e. the D: drive, because C: is an SSD with not all that much space)

这不成功.这是我第一次(第二次和第三次)尝试的最终结果:

This was not successful. Here is what I ended up doing in my first (second, and third) attempt:

• 在D上安装VS 2008 Professional:
• 安装VS 2008 SP 1
• 安装SQL Server 2008 Developer Edition(D上的实例和共享组件)
• 安装SQL Server SP 1

显然，VS 2008 Pro不需要数据库.我不确定为什么我记得确实如此.尽管Visual Studio的安装没有问题，但在SQL Server安装过程中遇到了以下错误:

Apparently VS 2008 Pro does not require a database. I am not sure why I remembered that it does. While the Visual Studio installation was eventless, I encountered the following errors during the SQL Server installation:

未指定INSTANCESHAREDWOWDIR命令行值.

The INSTANCESHAREDWOWDIR command line value was not specified.

我能够解决从命令行启动安装程序(感谢

I was able to resolve that be starting setup from the command line (thanks to this MSDN forum post):

setup.exe /INSTALLSHAREDWOWDIR="D:\Program Files(x86)\Microsoft SQL 
Server" /INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server"
/ACTION=install

然后在安装结束时，出现此错误:

Then towards the end of the installation, I got this error:

由于以下错误，升级失败.错误代码为:-2147467259.Message:Unspecified error

Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error

没有解决方案，但是有一种解决方法，在 connect.microsoft.com 上的此帖子.它包括在安装前后复制一个VS配置文件，然后仅针对BIDS(这是一个失败的组件)重新运行安装程序.

There is no solution, but a workaround, described in this post on connect.microsoft.com. It consists of copying a VS config file around before and after the installation, and re-running the installer just for BIDS (which is the one component that failed).

SQL Server SP1安装运行没有问题. VS Studio在尝试通过SSIS项目加载解决方案时，仍然抛出了我在原始问题中发布的错误.

The SQL Server SP1 installation ran without issue. VS Studio, when trying to load a solution with an SSIS project, still threw the error that I posted in my original question.

我忽略了在BIDS安装结束时弹出的错误:

I had ignored this error that popped up towards the end of the BIDS installation:

用于应用程序2.0的Microsoft Visual Studio工具 找不到一个或多个组件.请重新安装该应用程序.

Microsoft Visual Studio Tools for Applications 2.0 Cannot find one or more components. Please reinstall the application.

但是，安装日志中没有错误，并且已成功"完成，因此我认为可以忽略该错误.

However, there was no error in the install log and it completed "successfully", so I thought it would be ok to ignore the error.

似乎我的配置是不可能的(但我可以肯定地知道我在D:驱动器上安装了VS和SQL Server的2005版本).

It seems that my configuration is not possible (but I know with certainty that I had the 2005 versions of VS and SQL Server on a D: drive).

我再次卸载了所有内容，手动删除了剩下的所有文件夹，然后重新安装在C:驱动器上，包括SQL Server共享组件.我将实例文件夹放在D:上.

I uninstalled everything once again, manually deleted whatever folders were left, and reinstalled on the C: drive, including the SQL Server shared components. I put the instance folder on the D:.

• 在C上安装VS 2008 Professional:
• 安装VS 2008 SP 1
• 安装SQL Server 2008 Developer Edition(实例在D:上，共享组件在C:上)
• 安装SQL Server SP 1

这一次安装了所有东西，我可以打开我的SSIS项目.

This time everything installed and I can open my SSIS project.

这篇关于Visual Studio和SQL Server-正确的安装顺序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！