Skip to Content
author's profile photo Former Member
Former Member

Error SBO0001- Server not responding

Hi.

I have a problem with connection (to SSAS OLAP cube, using MS Analysis Services 2008 -> OLE DB for OLAP providers) in designer from client machine.

When I testing connection I recived: Server not responding (SBO0001) -

in detail I have information: DBD: Can not find provider msolap.4

If I try to create and test connection from server machine everything work fine!

Additionaly when I want to refresh data in WEBI report in Rich Client from client mashine I recived en error:

Can not find provider msolap.4 (WIS10901)

or from InfoView from client or server machine:

​A​n​ ​e​r​r​o​r​ ​h​a​s​ ​o​c​c​u​r​r​e​d​ ​w​h​i​l​e​ ​a​t​t​e​m​p​t​i​n​g​ ​t​o​ ​c​o​n​n​e​c​t​ ​t​o​ ​t​h​e​ ​O​L​A​P​ ​s​e​r​v​e​r​.​ ​F​a​i​l​e​d​ ​t​o​ ​i​n​i​t​i​a​l​i​z​e​ ​(​T​h​e​ ​c​o​m​p​o​n​e​n​t​ ​M​i​c​r​o​s​o​f​t​ ​O​L​E​ ​D​B​ ​P​r​o​v​i​d​e​r​ ​f​o​r​ ​A​n​a​l​y​s​i​s​ ​S​e​r​v​i​c​e​s​ ​2​0​0​8​ ​R​2​.​ ​r​e​t​u​r​n​e​d​ ​s​e​r​v​e​r​ ​e​r​r​o​r​ ​(​T​h​e​ ​f​o​l​l​o​w​i​n​g​ ​s​y​s​t​e​m​ ​e​r​r​o​r​ ​o​c​c​u​r​r​e​d​:​ ​ ​A​ ​s​p​e​c​i​f​i​e​d​ ​l​o​g​o​n​ ​s​e​s​s​i​o​n​ ​d​o​e​s​ ​n​o​t​ ​e​x​i​s​t​.​ ​I​t​ ​m​a​y​ ​a​l​r​e​a​d​y​ ​h​a​v​e​ ​b​e​e​n​ ​t​e​r​m​i​n​a​t​e​d​.​ ​)​)​.​ ​(​W​I​S​ ​1​0​9​0​1​)

On clients machines we have:

Windows XP SP3

Business Object Edge 3.1 SP3 (12.3.0.601) Clients components

On server we have:

Windows Server 2008 R2 x64

Business Object Edge 3.1 SP3 (12.3.0.601)

SQL Server 2008 R2

On the server ports 6400, 8080 and 1433 are opend.

Any ideas how to solve this problem?

Thanks in advance for your replying .

Regards

MG

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2011 at 12:33 PM

    Hi,

    I solve the problem with connection by Rich Client by instaling Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider on clients.

    It works fine.

    But I still have problem with connection by InfoView. On server and on client I get the same error:

    ​A​n​ ​e​r​r​o​r​ ​h​a​s​ ​o​c​c​u​r​r​e​d​ ​w​h​i​l​e​ ​a​t​t​e​m​p​t​i​n​g​ ​t​o​ ​c​o​n​n​e​c​t​ ​t​o​ ​t​h​e​ ​O​L​A​P​ ​s​e​r​v​e​r​.​ ​F​a​i​l​e​d​ ​t​o​ ​i​n​i​t​i​a​l​i​z​e​ ​(​T​h​e​ ​c​o​m​p​o​n​e​n​t​ ​M​i​c​r​o​s​o​f​t​ ​O​L​E​ ​D​B​ ​P​r​o​v​i​d​e​r​ ​f​o​r​ ​A​n​a​l​y​s​i​s​ ​S​e​r​v​i​c​e​s​ ​2​0​0​8​ ​R​2​.​ ​r​e​t​u​r​n​e​d​ ​s​e​r​v​e​r​ ​e​r​r​o​r​ ​(​T​h​e​ ​f​o​l​l​o​w​i​n​g​ ​s​y​s​t​e​m​ ​e​r​r​o​r​ ​o​c​c​u​r​r​e​d​:​ ​ ​A​ ​s​p​e​c​i​f​i​e​d​ ​l​o​g​o​n​ ​s​e​s​s​i​o​n​ ​d​o​e​s​ ​n​o​t​ ​e​x​i​s​t​.​ ​I​t​ ​m​a​y​ ​a​l​r​e​a​d​y​ ​h​a​v​e​ ​b​e​e​n​ ​t​e​r​m​i​n​a​t​e​d​.​ ​)​)​.​ ​(​W​I​S​ ​1​0​9​0​1​)

    Please help!

    Regards

    MG

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2011 at 12:26 PM

    You will need to create the appropriate connection on your client machine to the SSAS cube - see what has been set up on the server to access it.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.