SSAS excel remote connection -
i migrated sql server 2014 2008 version. have windows server 2012 iis 8.5.
i'm trying configure remote access olap database . followed steps described here:
https://msdn.microsoft.com/it-it/library/gg492140(v=sql.120).aspx.
the iis version mentioned 8.0, fit 8.5 too?
when try test configuration using management studio error:
title: connect server
cannot connect http://localhost/olap/msmdpump.dll.
additional information:
the connection either timed out or lost. (microsoft.analysisservices.adomdclient)
the remote server returned error: (405) method not allowed. (system)
program location: @ microsoft.analysisservices.adomdclient.xmlaclient.endrequest() @ microsoft.analysisservices.adomdclient.xmlaclient.sendmessage(boolean endreceivalifexception, boolean readsession, boolean readnamespacecompatibility) @ microsoft.analysisservices.adomdclient.xmlaclient.discover(string requesttype, string requestnamespace, listdictionary properties, idictionary restrictions, boolean sendnamespacescompatibility) @ microsoft.analysisservices.adomdclient.xmlaclient.supportsproperty(string propname) @ microsoft.analysisservices.adomdclient.xmlaclient.connect(connectioninfo connectioninfo, boolean beginsession) @ microsoft.analysisservices.adomdclient.adomdconnection.xmlaclientprovider.connect(boolean toixmla) @ microsoft.analysisservices.adomdclient.adomdconnection.xmlaclientprovider.microsoft.analysisservices.adomdclient.adomdconnection.ixmlaclientproviderex.connectxmla() @ microsoft.analysisservices.adomdclient.adomdconnection.connecttoxmla(boolean createsession, boolean ishttp) @ microsoft.analysisservices.adomdclient.adomdconnection.open() @ microsoft.sqlserver.management.sqlstudio.explorer.objectexplorerservice.validateconnection(uiconnectioninfo ci, iservertype server) @ microsoft.sqlserver.management.ui.connectiondlg.connector.connectionthreaduser() =================================== remote server returned error: (405) method not allowed. (system) ------------------------------ program location: @ system.net.httpwebrequest.getresponse() @ microsoft.analysisservices.adomdclient.httpstream.getresponsestream() @ microsoft.analysisservices.adomdclient.httpstream.getresponsedatatype() -----------------------------------------------------------------------------------------------------------------
what can more details in order find goes wrong?
thank in advance help!
Comments
Post a Comment