Hi guys,

I need to connect a web .NET application to an OLAP database.
I am using the latest ADOMD.NET build.

This connection string works well when the OLAP server is in the same
machine that the web server :

<add key="OLAPConnectionString"
value="Provider=MSOLAP.2;Password=xxx;Persist Security Info=True;User
ID=xxx;Data Source=serverolap1;Initial Catalog=olapbase1;Client Cache
Size=25;Auto Synch Period=10000;ConnectTo=8.0" />

But I am getting the error message when I try to use a remote OLAP server on
the same local network :

Exception Details: System.Net.Sockets.SocketException: No connection could
be made because the target machine actively refused it

Stack Trace:
[SocketException (0x274d): No connection could be made because the target
machine actively refused it]
System.Net.Sockets.TcpClient.Connect(String hostname, Int32 port) +580


Thanks,

Sam

I see you are specifying user and password properties in your connection string.
Those properties are ignored by the provider and integrated security is always used, so the user running the process that opens the connection should have the appropiate permissions in the remote OLAP server.
HTH,
--
Brian
www.geocities.com/brianaltmann/olap.html


"Samir Bencoscos" wrote:

Thank you Brian,

I updated the connection string : Provider=MSOLAP.2;Integrated
Security=SSPI;Persist Security Info=False;Data
Source=serverolap1;Mode=Read;Initial Catalog=olapbase1;Client Cache
Size=25;Auto Synch Period=10000;ConnectTo=8.0

Now I am getting this error :
Unhandled Execution Error
[AdomdErrorResponseException]

Microsoft.AnalysisServices.AdomdClient.XmlaClientP rovider.Microsoft.Analysis
Services.AdomdClient.AdomdConnection+IXmlaClientPr oviderEx.DiscoverWithCreat
eSession(String requestType, Boolean sendNamespaceCompatibility) +170

I have set the rights of IUSR_serverweb1 as a member of the OLAP
Administrators of serverolap1.

Anyone know what I am doing wrong?

Thanks,

Sam

"Brian Altmann" <findme@thesignaturewebsite> a écrit dans le message de
news:F0925D00-90A3-412B-8CD3-A0553E72D06B (AT) microsoft (DOT) com...
should have the appropiate permissions in the remote OLAP server.

According to the figure 8 scenario of this document
http://msdn.microsoft.com/library/de...l_datapump.asp,
it tells me to run Analysis Services and
IIS 6 on the same computer. "...because of the one-hop restriction of NT
security tokens".

So, I can not have two separate computers running IIS and AS ?? I can not /
dont need to activate Kerberos because the users are not windows users, they
are just identified by a login/pwd. And also everyone is allowed to see any
data in my cubes.

What if I decide to use XMLA in my connection string (this one is working
fine), ie :

<add key="OLAPConnectionString" value="Provider=MSOLAP.2;Persist Security
Info=True;Data Source=http://serverolap1/xmla/msxisapi.dll;Initial
Catalog=olapbase1;Client Cache Size=25;Auto Synch Period=10000" />

Is there a big performance cost because the OLAP connections now are using
the HTTP protocol ?

Thanks all for your answers,
Sam

"Brian Altmann" <findme@thesignaturewebsite> a écrit dans le message de
news:4DE59FF5-CB3E-4F1B-82E2-2C084F5CB50B (AT) microsoft (DOT) com...