Hi,
I am trying to connect to an OLAP database using SQL Analysis Services
Manager over a Cisco VPN connection.
When I attempt this I get the following error:
Errors occurred. Cannot open connection to Analysis server Error in data
[Possible data corruption].
My problem is seems to be the same described on
Connecting using HTTP seems to be the solution for this situation but:
- first, where to find a step by step procedure about how to set up the server side configuration? (IIS, users, ecc.).
- to do this seems that I need to use the Analysis Services/Enterprise Edition. If yes do I need also to update SQL Server to Enterprise Edition? If not, no problem with 2 different product type - standard/enterprise.
Any help would be greatly appreciated!
Cheers!
Luca
I am trying to connect to an OLAP database using SQL Analysis Services
Manager over a Cisco VPN connection.
When I attempt this I get the following error:
Errors occurred. Cannot open connection to Analysis server Error in data
[Possible data corruption].
My problem is seems to be the same described on
Connecting using HTTP seems to be the solution for this situation but:
- first, where to find a step by step procedure about how to set up the server side configuration? (IIS, users, ecc.).
- to do this seems that I need to use the Analysis Services/Enterprise Edition. If yes do I need also to update SQL Server to Enterprise Edition? If not, no problem with 2 different product type - standard/enterprise.
Any help would be greatly appreciated!
Cheers!
Luca