远程访问SSIS的配置

作者:Jason204 | 可以转载, 但必须以超链接形式标明文章原始出处和作者信息及版权声明

网址：http://jason204.iteye.com/blog/1774211

 

1.   检查防火墙

2.   配置客户端登录名和密码。如果用户名添加至Distributed COM Users 组，可以省略步骤3；如果添加至SSIS 新组,将按步骤3添加新组。

3.    配置MSDTC

a)   Goto Component services -> Computers -> My Computer, right click and go into Properties, Com Security and add the same users / group with the Remote Access privilege

b)    Component services > My computer properties > MSDTC > Security Configuration > Network DTC Access > Allow Remote clients

4.    配置DCOM 配置->MsDtsServer100

5.    重启SSIS服务

 

参考文档：

1．  http://msdn.microsoft.com/zh-cn/library/aa337083(v=sql.100).aspx

2．  http://www.sqlservercentral.com/Forums/Topic311706-146-1.aspx

3．  http://www.cpage.co.uk/2010/02/remote-access-to-ssis-or-ssrs.html

Configure Remote-accessing SSRS

Open Computer Management, browse to Services and Applications -> WMI Control and right click on it then open Properties -> Security and finally add the requried users or group with the Remote Enable privilege.