I'm trying to connect to an analysis services database in SSIS using a specific user name and password.
我正在尝试使用特定的用户名和密码连接到SSIS中的分析服务数据库。
I'm getting the message
我收到了消息
Error in initializing provider. An error was encountered in the transport layer.
初始化提供程序时出错。传输层中遇到错误。
The peer prematurely closed the connection.
同伴过早地关闭了连接。
Any ideas?
2 个解决方案
#1
Are your rights properly set up in Analysis Services? Assuming when you create the new AS connection through SSIS you click the 'Edit' button in the Add New Analysis Services Connection window and type in your username and password it should work. Are you able to log in through SQL Management Studio?
您是否在Analysis Services中正确设置了权限?假设在通过SSIS创建新的AS连接时,单击“添加新的Analysis Services连接”窗口中的“编辑”按钮,然后键入应该使用的用户名和密码。您是否可以通过SQL Management Studio登录?
#2
Try installing/reinstalling Microsoft OLE DB Provider for Analysis Services 9.0 (for 2005) or Microsoft OLE DB Provider for Analysis Services 10.0 (2008)
尝试安装/重新安装Microsoft OLE DB Provider for Analysis Services 9.0(适用于2005)或Microsoft OLE DB Provider for Analysis Services 10.0(2008)
#1
Are your rights properly set up in Analysis Services? Assuming when you create the new AS connection through SSIS you click the 'Edit' button in the Add New Analysis Services Connection window and type in your username and password it should work. Are you able to log in through SQL Management Studio?
您是否在Analysis Services中正确设置了权限?假设在通过SSIS创建新的AS连接时,单击“添加新的Analysis Services连接”窗口中的“编辑”按钮,然后键入应该使用的用户名和密码。您是否可以通过SQL Management Studio登录?
#2
Try installing/reinstalling Microsoft OLE DB Provider for Analysis Services 9.0 (for 2005) or Microsoft OLE DB Provider for Analysis Services 10.0 (2008)
尝试安装/重新安装Microsoft OLE DB Provider for Analysis Services 9.0(适用于2005)或Microsoft OLE DB Provider for Analysis Services 10.0(2008)