We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Can''t connect OlapDataManager to SQL Server Express instance

Thread ID:





100118 Jul 6,2011 09:12 AM UTC Jul 8,2011 10:43 AM UTC General Discussion 4
Tags: General Discussion
Bruno Filippone
Asked On July 6, 2011 09:12 AM UTC

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;

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"

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
Replied On July 6, 2011 09:29 AM UTC

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

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

Bruno Filippone
Replied On July 6, 2011 09:52 AM UTC

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
Replied On July 6, 2011 10:11 AM UTC

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 [Syncfusion]
Replied On July 8, 2011 10:43 AM UTC

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 .






This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon