Connectivity to excel from a different domain

Hi,

I would like to know if anybody has successfully connected to Analysis services cube using Excel 2007 over a different domain using the msmdpump ? I am able to connect it over the intranet, but if I try to connect from any other outside environment it fails to connect .

My analysis server and IIS are configured on the same box.

Any suggestions most welcome.

Thanks

JK

I have no problem with connecting over HTTP to the server in another domain. For example, DSP Panel runs open server in Internet - I just connected to it from Excel - just put the following in the wizard: http://demo.dspanel.com/olap/msmdpump.dll

HTH,

Mosha (http://www.mosha.com/msolap)

|||

This sounds like a firewall/routing problem. Might be worth trying to get some networking admin to help out.

In the meantime, can you connect to the IIS server for normal content?

sqlsql

Connection to the SSAS Cubes

I have some users connecting to the cubes using excel, is there any way i can track which users aere connected to the cubes without using the Profiler/running a trace.

You can do an XMLA discover command to discover the current sessions/connections

<Discover xmlns="urnchemas-microsoft-com:xml-analysis">

<RequestType>DISCOVER_SESSIONS</RequestType>

<Restrictions>

<RestrictionList />

</Restrictions>

<Properties>

<PropertyList />

</Properties>

</Discover>

<Discover xmlns="urnchemas-microsoft-com:xml-analysis">

<RequestType>DISCOVER_CONNECTIONS</RequestType>

<Restrictions>

<RestrictionList />

</Restrictions>

<Properties>

<PropertyList />

</Properties>

</Discover>

But I think that the easiest way to run these commands is to use the Analysis Services Stored Procedure Project www.codeplex.com/asstoredprocedures where you can do the equivalent and get the results in an easy to read table form by doing

CALL ASSP.DiscoverSessions();

or

CALL ASSP.DiscoverConnections();

There was also an AMO Activity sample (or something like that) in the Analysis Services product samples that could show this sort of information.

Connection string

I am connecting to a SQL Express database from Excel 2K.
I have three connection strings examples. The first two work however the
third was the one I wanted to use as I do not want to specify a local db.
These two work fine:
strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=IPS;
Trusted_Connection=yes;"
strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=IPS;
INTEGRATED SECURITY=sspi;"
This one doesn't which I got from http://www.connectionstrings.com/ I like
it as it is simple and easily understood.
strConn = " Server=dimension9150;Database=IPS;Truste
d_Connection=yes;"
The server name is dimension9150 as is verified in the following:
C:\>sqlcmd -S dimension9150
1> SELECT name FROM sys.databases
2> GO
name
----
--
---
master
tempdb
model
msdb
IPS
(5 rows affected)
1> exit
C:\>
Thanks in advance...Hi,
Yuu can use all of the above mentioned, the (local) can be exchanged by
the servername you want to work on like:
strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=Dimension9150;INITIAL
CATALOG=IPS;
INTEGRATED SECURITY=sspi;"
(local) is only a pointer like "." or localhost to your current machine
you are connecting from. if you want to use another instance than the
default one, you have to additionally specify the instancename within
the servername, something like this: servername\instancename if you are
using a different port number than the original one,you can use
servername\instancename,Portnumber.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

Connection string

I am connecting to a SQL Express database from Excel 2K.
I have three connection strings examples. The first two work however the
third was the one I wanted to use as I do not want to specify a local db.
These two work fine:
strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=IPS;
Trusted_Connection=yes;"
strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=IPS;
INTEGRATED SECURITY=sspi;"
This one doesn't which I got from http://www.connectionstrings.com/ I like
it as it is simple and easily understood.
strConn = "Server=dimension9150;Database=IPS;Trusted_Connect ion=yes;"
The server name is dimension9150 as is verified in the following:
C:\>sqlcmd -S dimension9150
1> SELECT name FROM sys.databases
2> GO
name
master
tempdb
model
msdb
IPS
(5 rows affected)
1> exit
C:\>
Thanks in advance...
Hi,
Yuu can use all of the above mentioned, the (local) can be exchanged by
the servername you want to work on like:
strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=Dimension9150;INITIAL
CATALOG=IPS;
INTEGRATED SECURITY=sspi;"
(local) is only a pointer like "." or localhost to your current machine
you are connecting from. if you want to use another instance than the
default one, you have to additionally specify the instancename within
the servername, something like this: servername\instancename if you are
using a different port number than the original one,you can use
servername\instancename,Portnumber.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de