Extremely critical. problems with OLAP SERVER (sorry)

13 May 2005 11:35 AM

Enric

I am so sorry fot insist this way, such be a pain, i know but it is very
critical.

A lot!

When I launch my routine from our back-end vb appears this:

Cannot open connection to Analysis server 'BUESSQL01'.
Error in data [Possible data corruption] ''

...

Set m_dsoServer = New DSO.Server

m_dsoServer.Connect m_strMDSERVER

What is happening?
-That servers is reached via PING.
-OLAP services are up and running.
-OLAP server belong to NT domain.
-User which is being responsible for that (via vb code) belong to NT Domain.

???

Any help will be welcomed.

Thanks,

13 May 2005 2:27 PM

Cowboy (Gregory A. Beamer) - MVP

1. Ping is against a different service, so it has nothing to do.
2. Service running and database corruption are two different things
3. Domain membership does not appear to be the problem here (database or user)

It does not appear that you have an authentication issue, based on your
post. I would check your analysis services database and make sure it is not
corrupt. If it is, no amount of tinkering will help.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

Show quote

"Enric" wrote:

> I am so sorry fot insist this way, such be a pain, i know but it is very
> critical.
>
> A lot!
>
>
> When I launch my routine from our back-end vb appears this:
>
> Cannot open connection to Analysis server 'BUESSQL01'.
> Error in data [Possible data corruption] ''
>
> ..
>
> Set m_dsoServer = New DSO.Server
>
> m_dsoServer.Connect m_strMDSERVER
>
>
> What is happening?
> -That servers is reached via PING.
> -OLAP services are up and running.
> -OLAP server belong to NT domain.
> -User which is being responsible for that (via vb code) belong to NT Domain.
>
> ???
>
> Any help will be welcomed.
>
> Thanks,
>

13 May 2005 4:16 PM

XXX

Have you changed your password lately? I have seen this error when I change
my network password but still have an open connection (remote) with the old
password. If this is the case logoff and login again.

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:6FA71B2A-BCD6-4475-946A-8DBE80640272@microsoft.com...
>I am so sorry fot insist this way, such be a pain, i know but it is very
> critical.
>
> A lot!
>
>
> When I launch my routine from our back-end vb appears this:
>
> Cannot open connection to Analysis server 'BUESSQL01'.
> Error in data [Possible data corruption] ''
>
> ..
>
> Set m_dsoServer = New DSO.Server
>
> m_dsoServer.Connect m_strMDSERVER
>
>
> What is happening?
> -That servers is reached via PING.
> -OLAP services are up and running.
> -OLAP server belong to NT domain.
> -User which is being responsible for that (via vb code) belong to NT
> Domain.
>
> ???
>
> Any help will be welcomed.
>
> Thanks,
>