Usage on a remote computer

[pmarjou]

It works great on the local server (where analysis services and IIS are installed).

I don't manage to connect to the service on a remote computer I get : "connection refused", "nothing there". Indeed there is no prompt for user login/password.

On other hand I manage to access the service via Excel.

Is there way to make it works remotely ?

Thanks

[Igor]

It works with remote server too, ofcourse:

It is a bit hard to troubleshoot your problem like this but I would check to see how is you virutal directory configured on the remote server.
Does the user that get through have the right to access AS database?
Did you follow the instructions for setting up a virtual dir in MS XMLA toolkit help file?
Can you open that URL with your browser, e.g.:
http://remoteserver/xmla/msxisapi.dll
What do you get? What AS version are you using?
Furthermore, try running:
run.me.terminal.bat
from command line to get the exception stacktrace.

Hope some of this will help you,

Regards,

Igor

[pmarjou]

In Addition I use AS 2005 SP1

Thanks
Pierre

[pmarjou]

I think the configuration with IIS is correct, indeed I access the service via the msxisapi.dll with Excel. I access the dll url from IE.

The NT user (on the remote computer) has no permission to connect to the AS Database.

Is there in this case any prompt for a user/password ?

Here is the trace

Error(discoverDataSources):java.net.ConnectException: Connection timed out: conn
ect
java.net.ConnectException: Connection timed out: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at sun.net.NetworkClient.doConnect(Unknown Source)
        at sun.net.www.http.HttpClient.openServer(Unknown Source)
        at sun.net.www.http.HttpClient.openServer(Unknown Source)
        at sun.net.www.http.HttpClient.<init>(Unknown Source)
        at sun.net.www.http.HttpClient.New(Unknown Source)
        at sun.net.www.http.HttpClient.New(Unknown Source)
        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown
Source)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Sour
ce)
        at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
        at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown S
ource)
        at rex.xmla.RexXMLAPort.discover(RexXMLAPort.java:256)
        at rex.xmla.RexXMLAPort.discoverDataSources(RexXMLAPort.java:321)
        at rex.metadata.ServerMetadata.discoverDataSources(ServerMetadata.java:1
13)
        at rex.graphics.datasourcetree.DataSourceTreeModel.addDataSource(DataSou
rceTreeModel.java:75)
        at rex.graphics.datasourcetree.DataSourceTree.actionPerformed(DataSource
Tree.java:220)
        at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at javax.swing.AbstractButton.doClick(Unknown Source)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)

[Igor]

Login dialog will pop up only if virutal directory in   IIS has "Basic authentication" set.
It is recommended that you use https with basic auth otherwise (if you use http) password can easily be sniffed.
User that gets logged in, ofcourse, has to have permissions to view the cubes.