Newby: I cannot connect to OLAP Server from Excel
Publicado por
Ariel (1 intervención) el 14/11/2007 20:52:13
Newby: I cannot connect to OLAP Server from Excel
Apparently the OLAP Server is not visible from the client using Excel.
Explanation:
In Excel, over the shape “multi-dimensional connection”, OLAP Server is checked, I put the server name DELLARIEL in this case, I press “next” button and after several seconds this message appears:
“Open connection Failed
Cannot connect to server ‘DELLARIEL.
Olap server error: The operation requested failed due to network problems”
Note:
If I did the same operation over my computer who has the OLAP SERVER works perfect, the cube are showed for connection.
Client Actualization: I run over the client PTSLite.exe and PTSFull.exe from the SP4
The OLAP Server is installed with Analysis Services 2000 Enterprise, SP3 and SP4 are applied.
Any help are welcomed, thanks in advance
Ariel