Excel 与 SSAS 的连接 - 在传输层中遇到错误 [英] Excel Connectivity with SSAS - An error was encountered in the transport layer
问题描述
我在 SQL 2012 中有一个 SSAS 多维数据集，我可以使用 Windows 用户凭据从 Excel 2010 连接到该多维数据集，而不会出现问题.但是，每当我重新启动托管多维数据集的服务器并尝试刷新 excel(在客户端计算机中)中的枢轴时，它都会抛出错误并显示在传输层中遇到错误".然后提示我重新输入用于连接数据源的 Windows 帐户的密码.
I have a SSAS Cube in SQL 2012 to which I can connect from Excel 2010 without an issue using a windows user credentials. However whenever I restart the server hosting the cube and I try to refresh the pivot in the excel (in a client machine) it throws and an error saying "An error was encountered in the transport layer". I am then prompted to re-enter the password for the windows account I am using to connect to the data source.
问题是，如果我在每个枢轴的同一 Excel 书中的不同工作表中打开了几个枢轴，则会提示我执行此操作(即使我执行刷新而不是全部刷新)，这有点麻烦.
The problem is that if I have couple of pivots open in different sheets in the same excel book per each pivot I am prompted to do this (even if I do a Refresh and not a Refresh All) which is bit of a trouble.
有没有办法解决这个问题，或者至少确保我只需要输入一次密码并且它不会搜索每一个被刷新的枢轴?
Is there a way to fix this or at least to make sure I have to enter the password only once and it will not seek for each and every pivot being refreshed?
推荐答案
如果您尝试使用不是您用于登录笔记本电脑的凭据的凭据连接到多维数据集，那么完成此操作的正确方法是下列的.从头开始创建新连接.(您不能修改现有连接.)请执行以下操作:
If you are trying to connect to the cube under credentials which are not the credentials you used to log into your laptop, then the proper way of accomplishing this is the following. Create a new connection from scratch. (You can't modify an existing connection.) Do the following:
- 数据选项卡...来自其他来源...来自分析服务...
- 输入服务器名称、用户名和密码...点击下一步
- 选择您的数据库并点击下一步
- 选中始终尝试使用此文件刷新数据".并选中将密码保存在文件中".弹出提示时点击是.
- 点击完成.
这会将您的用户名和密码(以明文形式)保存到 odc 文件中.(出于安全目的，请注意这一点.)
That will save your username and password (in clear text) into the odc file. (Be aware of this for security purposes.)
根据您对症状的描述，我怀疑您在创建连接时没有选中这些复选框.因此，它会在需要重新连接时继续提示输入用户名/密码.
Based upon your description of the symptoms I suspect you didn't have these checkboxes checked when you created the connection. Thus it would continue to prompt for username/password when it needed to reconnect.
这篇关于Excel 与 SSAS 的连接 - 在传输层中遇到错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
