Can''t connect OlapDataManager to SQL Server Express instance

[Bruno Filippone]

Hi everyone,

I'm having some problem with the connection string, when I try to connect to my SQL Server Express instance like this:

string connectionString = @"Data Source=MYPC\SQLEXPRESS;Initial Catalog=SYNCFUSION_TEST;";
if (connectionString != "")
{
DataManager = new OlapDataManager(connectionString);
this.OlapClient1.OlapDataManager = DataManager;
this.OlapClient1.DataBind();
}

I get the following exceptions on DataBind():

"Unable to open the connection"
INNER --> "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running"
INNER -----> "Unable to establish a connection because the target machine expressly rejected the connection 127.0.0.1:2382"

I can connect with no problems to the database with other applications, but not using OlapDataManager, I've also tried changing the Data Source with .\SQLEXPRESS, ip address and port, etc, with no luck..

Any ideas?

[Bruno Filippone]

Maybe the correct translation of the latest inner exception is the following:

"No connection could be made because the target machine actively refused it 127.0.0.1:2382"

[Bruno Filippone]

I' ve tried to connect directly to the address and port which SQL Server Express is listening, and now the error is the following:

"DIME protocol error: The required bytes cannot be read from the stream"

[Bruno Filippone]

It seems that I should have Analysis Service running, and Express Edition dasent have AS.

I wonder if there is any other OLAP provider I can use, can you help?

[Ganesan]

Hi Bruno,

We inform you that Olap providers could establish a connection from the database only if the Cube Schema is mapped with that. Once you have a proper plan of your cube schema, you can use this schema with any of the OLAP/Xmla server like Analysis Server, mondrian server,Hyperion server,Oracle Olap server.

Please refer the following links to define a Cube Schema .

http://wang.se/en/CreateOLAPCube.html


http://mondrian.pentaho.com/documentation/workbench.php


http://livedocs.adobe.com/flex/3/html/help.html?content=olapdatagrid_4.html

Thanks,
Ganesan