sql-server - 将集成服务添加到以前的 SQL Server 安装

Question

我正在尝试将集成服务添加到我机器上的 SQL Server 实例。尝试这样做时出现以下错误:

一些基本的谷歌搜索没有产生任何有用的东西。这里有没有人有任何见解？

Answer 1

检查 sqlncli.msi 是否存在于 %PROGRAMFILES%\Microsoft SQL Server\100\SDK 中。如果它不存在，请使用后续步骤下载、卸载并重新安装它来解决此错误。

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms131321(v=sql.105)?redirectedfrom=MSDN

The SQL Server Native Client header and library files (sqlncli.h and sqlncli10.lib) are installed in the following location:

%PROGRAMFILES%\Microsoft SQL Server\100\SDK

You can distribute (install) SQL Server Native Client through sqlncli.msi. You might have to install SQL Server Native Client when you deploy an application. One way to install multiple packages in what seems to the user to be a single installation is to use chainer and bootstrapper technology. For more information, see Authoring a Custom Bootstrapper Package for Visual Studio 2005 and Adding Custom Prerequisites.

The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client. If your application targets a platform other than the one it was developed on, you can download versions of sqlncli.msi for x64, Itanium, and x86 from the Microsoft Download Center.

When you invoke sqlncli.msi, only the client components are installed by default. The client components are are files that support running an application that was developed using SQL Server Native Client. To also install the SDK components, specify ADDLOCAL=All on the command line. For example:

msiexec /i sqlncli.msi ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1}

如果记录的路径中不存在 sqlncli.msi 采取的步骤

1. 转到控制面板并卸载 SQL Server 2012 Native Client
2. 下载 Microsoft® SQL Server® 2012 Native Client - QFE https://www.microsoft.com/en-us/download/details.aspx?id=50402并安装
3. 使用 SQL Server Installation Center 添加 SSIS