SQL Server 2005 维护计划无法保存

from:http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/10/16/you-get-an-error-when-you-attempts-to-save-ssis-packages-to-the-msdb-package-store-if-the-network-packet-size-16388-bytes.aspx

In SQL Server 2005 if you configure network packet size to 16388 or greater,  and attempts to save SSIS packages to the MSDB package store, It will fail with the following error message:

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Communication link failure).The SQL statement that was issued has failed.

 

 Attempting to import a package using Management Studio's Integration Services Connection fails with error:

 

 Communication link failure. SSL Provider: Packet size too large for SSL Encrypt/Decrypt operations [50]. (Microsoft Native Client)

 

 The same behaviour can be seen if we are deploying the package from the Visual studio.

 

 Steps to reproduce

1. Reconfigure Network Packet Size to 16388:

sp_configure 'network packet size (B)', 16388

go

reconfigure with override

2. In SQL Management Studio, drill into the server and then Management, and then right-click on Maintenance Plans and choose New Maintenance plan.

3. Accept the name and click OK.

4. Click the Save Selected Items button on Management Studio's toolbar.

Results: Error: The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Communication link failure).The SQL statement that was issued has failed.

Resolution

Dropping the run value for Network packet size to 16387 or less, and the maintenance plans save as packages and the packages import successfully.

You can do that using

1.      Go to server properties by right clicking the instance NameàAdvancedàNetwork Packet Size

Or

2.     sp_configure 'network packet size (B)', <numeric value less than 16388>

go

reconfigure with override

 

Reason:

The reason is that when SSIS is loading and saving packages into SQL Server MSDB, the connection used is encrypted with a server generated self-signed SSL certificate so that the packages and any secrets such as connection manager passwords within the SSIS package are not visible as plain text on the network. That form of encryption is incompatible with the large network packet size in SQL 2005.

Note: This issue is fixed in SQL Server 2008

 

Author : Lalitesh(MSFT) , SQL Developer Engineer , Microsoft

Reviewed by : Jason(MSFT) , SQL Escalation Services , Microsoft

posted on 2011-06-27 17:35  Fanr_Zh 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/Amaranthus/archive/2011/06/27/2091559.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值