View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ITS ITS is offline
external usenet poster
 
Posts: 3
Default connecting to an olap cube outside the intranet

When we added the settings following the website you gave to us, we get the
message forbidden when we want to access the olap cube in Excel.
We also tried it with Proclarity and we get the same message.
I think I forgot a small item.

"Wei Lu [MSFT]" wrote:

Hello there,

Yes, your assumption is some how right. The Analysis Services only support
Windows Integrated Authentication.

So when you connect the Excel from outside the intranet, you will not
provide the Windows Credential to the Services unless you use VPN to
connect to the internal network.

You may consider use the HTTP access to the SSAS.

http://www.microsoft.com/technet/pro.../httpasws.mspx

Hope this helps.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.