Error SBO0001- Server not responding

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Sounds like you need to sort out the access/connectivity to the MSAS cube from your WebIntelligence Server.

[Former Member · Accepted solution]

Could you give me some steps how to do it. What and where should I check?

Regards

MG

[Former Member · Accepted solution]

Ask your DBA/SSAS person to set it up with you.

[Former Member]

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.