We have an SSAS server with a cube deployed on a server over the WAN.. We are trying to connect to the cube from Excel on various client workstations. The server is not on a domain with the clients. It "works" for some of us but not for others. We are trying and failing yet to determine what the difference is on the machines that work versus the ones that don't. However, even for the ones that work, it isn't as seamless as we think it should be. I'll explain:
我们有一个SSAS服务器,通过WAN部署在服务器上的多维数据集。我们正在尝试从各种客户端工作站上的Excel连接到多维数据集。服务器不在具有客户端的域中。它对我们中的一些人“有效”,但对其他人则不然。我们正在尝试并且未能确定有效机器与不使用机器的区别。然而,即使是那些有效的,它也不像我们想象的那样无缝。我会解释一下:
In Excel, we use the Data-Other Sources-Analysis Server option, which presents us with the standard dialog: standard dialog http://www.freeimagehosting.net/uploads/de3420ec26.gif
在Excel中,我们使用Data-Other Sources-Analysis Server选项,它为我们提供标准对话框:标准对话框http://www.freeimagehosting.net/uploads/de3420ec26.gif
Now, we believe the firewall and server settings are correct, because we are then presented with the dialog which lets you pick which cube to use from the server: pick a cube dialog http://www.freeimagehosting.net/uploads/882a09ee7f.gif
现在,我们认为防火墙和服务器设置是正确的,因为我们会看到对话框,您可以从服务器中选择要使用的多维数据集:选择一个多维数据集对话框http://www.freeimagehosting.net/uploads/882a09ee7f。 GIF
And, clicking "Finish" lets Excep being to work with the cube, as evidenced by the standard Excel dialog: all seems OK http://www.freeimagehosting.net/uploads/fdf4626609.gif
并且,单击“完成”可以让Excep与多维数据集一起使用,如标准Excel对话框所示:一切似乎都正常http://www.freeimagehosting.net/uploads/fdf4626609.gif
But then we are presented with the dreaded "transport layer error" message: transport layer error http://www.freeimagehosting.net/uploads/243d5f3d49.gif
但后来我们看到了可怕的“传输层错误”消息:传输层错误http://www.freeimagehosting.net/uploads/243d5f3d49.gif
Note that this error appears even on the machines that "work." What makes them "work" is that after clicking OK on that dialog, the next dialog appears: mysterious new dialog http://www.freeimagehosting.net/uploads/b8fc6bae18.gif
请注意,即使在“工作”的计算机上也会出现此错误。使它们“工作”的原因是,在该对话框上单击“确定”后,将出现下一个对话框:神秘的新对话框http://www.freeimagehosting.net/uploads/b8fc6bae18.gif
Once this dialog appears, you re-enter your password, and everything "just works" after that. While I'd like it to "just work" without that second dialog, at least it works... But on many machines we've tested this new dialog never comes up. Instead, they just get the following error message, leaving them out of luck: final error http://www.freeimagehosting.net/uploads/601b9294e3.jpg
出现此对话框后,您将重新输入密码,之后“一切正常”。虽然我希望没有第二个对话框就能“正常工作”,但至少它可以工作......但是在许多机器上我们测试过这个新对话框永远不会出现。相反,他们只是得到以下错误消息,让他们运气不好:最后的错误http://www.freeimagehosting.net/uploads/601b9294e3.jpg
Can anyone offer any advice for this? Thanks!
任何人都可以为此提供任何建议吗?谢谢!
1 个解决方案
#1
0
Do the connections work if you allow "NT Authority/Authenticated Users" or "NT Authority/Anonymous Logon" to connect? Would help troubleshooting at least, but it's not a great idea to leave it like that ;)
如果允许“NT Authority / Authenticated Users”或“NT Authority / Anonymous Logon”连接,连接是否有效?至少可以帮助排除故障,但是这样做并不是一个好主意;)
#1
0
Do the connections work if you allow "NT Authority/Authenticated Users" or "NT Authority/Anonymous Logon" to connect? Would help troubleshooting at least, but it's not a great idea to leave it like that ;)
如果允许“NT Authority / Authenticated Users”或“NT Authority / Anonymous Logon”连接,连接是否有效?至少可以帮助排除故障,但是这样做并不是一个好主意;)