构建安装项目时，如何停止尝试安装某些程序包的SQL Server 2008 R2? [英] How do I stop SQL Server 2008 R2 trying to install some package when I build my setup project?

问题描述

我有一个WPF Linq-to-SQL项目，正在使用MS Visual Studio 2008开发.我正在运行SQL Server 2008，最近将其升级到了R2版本.现在，每当我构建SETUP项目(而不是应用程序本身)时，构建过程都会导致一个窗口启动:

I have a WPF Linq-to-SQL project which I have been developing using MS Visual Studio 2008. I was running SQL Server 2008, and recently upgraded it to version R2. Now, whenever I build my SETUP project (not the app itself), the build process causes a window to launch:

SQL Server 2008 R2管理Studio Windows等待配置SQL Server 2008 R2 Management Studio时，请等待

SQL Server 2008 R2 Management Studio Please wait while Windows configures SQL Server 2008 R2 Management Studio

在进度条和一些延迟之后，它抱怨:您要使用的功能位于不可用的网络资源上."具有指向源的选项，并且显然正在尝试使用不存在的c:\ 687b0370badbfcf47c \ x86 \ setup \.

Which after a progress bar and some delay, complains: "The feature you are trying to use is on a network resource that is unavaiable." With an option to point to a source, and it is apparently trying to use c:\687b0370badbfcf47c\x86\setup\ , which doesn't exist.

如果此时单击取消"，则会显示找不到产品SQL Server 2008 R2 Management Studio的安装包.请使用安装包'sql_ssms.msi'的有效副本再次尝试安装."

If I click Cancel at that point, it says, "An installation package for the product SQL Server 2008 R2 Management Studio cannot be found. Try the installation again using a valid copy of the installation package 'sql_ssms.msi'."

然后，我看到进度条向后移动，然后重新开始.此时，安装程​​序构建正在等待尝试为我的项目构建MSI.有一次，这导致Visual Studio崩溃.有时候，我可以告诉进度栏窗口取消，然后我的安装项目就可以正常构建了.

I then get to watch the progress bar go backwards, and then it starts all over again. At this point, the setup build is waiting trying to build the MSI for my project. One time this resulted in Visual Studio crashing. Other times, I have been able to tell the progress bar window to cancel, and then my setup project builds fine.

所以我的问题是:

• 当我尝试建立安装程序时，如何获取此信息以停止启动不需要的安装程序尝试?

和

• 为什么首先要这样做?

推荐答案

文件夹c:\687b0370badbfcf47c是运行时由SQL安装创建的文件夹-它创建一个随机命名的文件夹，然后将其所有安装文件扩展到该文件夹​​中文件夹.无论您缺少哪一个功能，都只是以广告"形式安装，而不是完全安装，这意味着直到您实际尝试使用该功能时，它才被安装，这就是VS的发布功能.

The folder c:\687b0370badbfcf47c is what was created by the SQL install when you ran it - it creates a randomly named folder and then expands all its setup files into that folder. Whichever feature you are missing was merely installed as "advertised" instead of being installed fully, this means it doesn't get installed until you actually try to use the feature, which is what the publish functionality of VS is doing.

我无法确切猜出缺少的是什么，但这是解决它的方法.

I can't guess exactly what is missing, but this is how to fix it.

• 卸载当前的SQL实例(这将花费10到15分钟，具体取决于计算机的速度)，然后重新安装.确保选择允许您选择要安装的功能的安装选项，然后确保选择了数据库引擎，客户端连接工具，管理工具(如果有)以及Management Studio(如果有)-您也可以选择，无需PITA即可管理数据库).

• uninstall your current instance of SQL (which will take 10 to 15 mins depending on the speed of your machine), then reinstall. Make sure you take the install option that allows you to choose which feature to install, then make sure you have selected the database engine, client connectivity tools, management tools (if available), and also Management Studio (if available - you might as well, managing the database without it is a PITA).

，或者您可以开始从同一SQL安装程序包中安装另一个实例.进入初始设置屏幕后，打开文件资源管理器并找到它已创建的temp文件夹及其扩展的安装文件.重新创建文件夹c:\687b0370badbfcf47c，然后将扩展的安装文件复制到该文件夹​​.然后取消正在进行的安装.现在再次构建您的设置，SQL安装将开始，但是现在它应该完成并让您继续.

or you can start to install another instance from the same SQL installer package. Once you get to the initial setup screen, bring up file explorer and find the temp folder it has made and its expanded install files. Recreate the folder c:\687b0370badbfcf47c, and copy the expanded install files over to it. Then cancel the install you had in progress. Now build your setup again, the SQL install will kick in, but now it should complete and let you continue.

这篇关于构建安装项目时，如何停止尝试安装某些程序包的SQL Server 2008 R2?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！