MSOLAP Connection error

Hi,
I have RS with sp1 in one server and MS Analysis server with sp3 in another.
Both inside of Domain and the user is the administrator. Also I have the
correct roles in the AS.
I got this error:
An error has occurred during report processing.
Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
'Sales' does not exist.
In the dev. env works fine and also if AS is in the same server as RS.
The problem is when AS and RS are in different server.
Does some one knows whats wrong?
Thanks in advanceDid you get a solution for this. I have the same problem?
"Carlos Lara" wrote:
> Hi,
> I have RS with sp1 in one server and MS Analysis server with sp3 in another.
> Both inside of Domain and the user is the administrator. Also I have the
> correct roles in the AS.
> I got this error:
> An error has occurred during report processing.
> Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
> 'Sales' does not exist.
> In the dev. env works fine and also if AS is in the same server as RS.
> The problem is when AS and RS are in different server.
> Does some one knows whats wrong?
> Thanks in advance
>|||Yes, I am also having the same problem and noticed that Jane has also posted
the same problem under "Database connection problem".
Can some please help.
Cheers.
"Ramdas" wrote:
> Did you get a solution for this. I have the same problem?
> "Carlos Lara" wrote:
> > Hi,
> > I have RS with sp1 in one server and MS Analysis server with sp3 in another.
> > Both inside of Domain and the user is the administrator. Also I have the
> > correct roles in the AS.
> >
> > I got this error:
> > An error has occurred during report processing.
> > Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
> > 'Sales' does not exist.
> >
> > In the dev. env works fine and also if AS is in the same server as RS.
> >
> > The problem is when AS and RS are in different server.
> >
> > Does some one knows whats wrong?
> >
> > Thanks in advance
> >
> >|||Same problem here as well. Any luck?
Cheers,
"Kelvin" wrote:
> Yes, I am also having the same problem and noticed that Jane has also posted
> the same problem under "Database connection problem".
> Can some please help.
> Cheers.
> "Ramdas" wrote:
> > Did you get a solution for this. I have the same problem?
> >
> > "Carlos Lara" wrote:
> >
> > > Hi,
> > > I have RS with sp1 in one server and MS Analysis server with sp3 in another.
> > > Both inside of Domain and the user is the administrator. Also I have the
> > > correct roles in the AS.
> > >
> > > I got this error:
> > > An error has occurred during report processing.
> > > Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
> > > 'Sales' does not exist.
> > >
> > > In the dev. env works fine and also if AS is in the same server as RS.
> > >
> > > The problem is when AS and RS are in different server.
> > >
> > > Does some one knows whats wrong?
> > >
> > > Thanks in advance
> > >
> > >sql

msmdsrv.exe takes more than 95% cpu

Hi,
The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu. The PC is
very very slow. What can I do? I have SP4 for Analysis Services installed.
I thought SP4 could correct the problem but it did not.
When I looked at the Analysis Services in MMC, the PC icon had a small red
square, which indicates the Analysis Services was not running. I did not
connect to it, since the PC was nearly halted.
Please help me!
Thanks.
Actually msmdsrv *IS* Analysis Services. It is the service.
So it is running -- regardless of what the icon is saying. This just means
that the service APIs cannot detect that it is in a running state. Typically
msmdsrv going into a high CPU loop when the lazy aggregator is running (i.e.
someone kicked off a changing dimension incremental process and the flex
aggs are being reprocessed), or a full processing is being done for a
specific cube, etc.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
news:uuLYlX6cFHA.2420@.TK2MSFTNGP12.phx.gbl...
> Hi,
> The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu. The PC
> is very very slow. What can I do? I have SP4 for Analysis Services
> installed. I thought SP4 could correct the problem but it did not.
> When I looked at the Analysis Services in MMC, the PC icon had a small red
> square, which indicates the Analysis Services was not running. I did not
> connect to it, since the PC was nearly halted.
> Please help me!
> Thanks.
>
|||Do you have a solution to this problem? My OS is windows 2000 server. I
have another PC with Analysis Services. The msmdsrv.exe does not take cpu.
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23qC1fGfdFHA.2696@.TK2MSFTNGP09.phx.gbl...
> Actually msmdsrv *IS* Analysis Services. It is the service.
> So it is running -- regardless of what the icon is saying. This just means
> that the service APIs cannot detect that it is in a running state.
> Typically msmdsrv going into a high CPU loop when the lazy aggregator is
> running (i.e. someone kicked off a changing dimension incremental process
> and the flex aggs are being reprocessed), or a full processing is being
> done for a specific cube, etc.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
> news:uuLYlX6cFHA.2420@.TK2MSFTNGP12.phx.gbl...
>
|||I had the same problem albiet under Windows XP. I resolved it by:
1: Go to Control Panel/Admin Tools/Services. Find the
MSSQLServerOLAPService, choose properties and check the 'Allow service to
interact with desktop' checkbox.
2: Allow the msmdsrv.exe file through your firewall (file typically found in
the \program files\Microsoft Analyst Service\bin\ folder.
I'm not sure if 2: is required but it seemed to help.
This resolved the problem - I'm not technically competent enough to know why
but it worked!
Good luck.
"§Chrissi§" wrote:

> Do you have a solution to this problem? My OS is windows 2000 server. I
> have another PC with Analysis Services. The msmdsrv.exe does not take cpu.
> "Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
> news:%23qC1fGfdFHA.2696@.TK2MSFTNGP09.phx.gbl...
>
>

msmdsrv.exe takes more than 95% cpu

Hi,
The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu. The PC is
very very slow. What can I do? I have SP4 for Analysis Services installed.
I thought SP4 could correct the problem but it did not.
When I looked at the Analysis Services in MMC, the PC icon had a small red
square, which indicates the Analysis Services was not running. I did not
connect to it, since the PC was nearly halted.
Please help me!
Thanks.Actually msmdsrv *IS* Analysis Services. It is the service.
So it is running -- regardless of what the icon is saying. This just means
that the service APIs cannot detect that it is in a running state. Typically
msmdsrv going into a high CPU loop when the lazy aggregator is running (i.e.
someone kicked off a changing dimension incremental process and the flex
aggs are being reprocessed), or a full processing is being done for a
specific cube, etc.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
news:uuLYlX6cFHA.2420@.TK2MSFTNGP12.phx.gbl...
> Hi,
> The process msmdsrv.exe (ver 8.00.2039) takes more than 95% cpu. The PC
> is very very slow. What can I do? I have SP4 for Analysis Services
> installed. I thought SP4 could correct the problem but it did not.
> When I looked at the Analysis Services in MMC, the PC icon had a small red
> square, which indicates the Analysis Services was not running. I did not
> connect to it, since the PC was nearly halted.
> Please help me!
> Thanks.
>|||Do you have a solution to this problem? My OS is Windows 2000 server. I
have another PC with Analysis Services. The msmdsrv.exe does not take cpu.
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23qC1fGfdFHA.2696@.TK2MSFTNGP09.phx.gbl...
> Actually msmdsrv *IS* Analysis Services. It is the service.
> So it is running -- regardless of what the icon is saying. This just means
> that the service APIs cannot detect that it is in a running state.
> Typically msmdsrv going into a high CPU loop when the lazy aggregator is
> running (i.e. someone kicked off a changing dimension incremental process
> and the flex aggs are being reprocessed), or a full processing is being
> done for a specific cube, etc.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Chrissi" <anubisofthydeath@.hotmail.com> wrote in message
> news:uuLYlX6cFHA.2420@.TK2MSFTNGP12.phx.gbl...
>|||I had the same problem albiet under Windows XP. I resolved it by:
1: Go to Control Panel/Admin Tools/Services. Find the
MSSQLServerOLAPService, choose properties and check the 'Allow service to
interact with desktop' checkbox.
2: Allow the msmdsrv.exe file through your firewall (file typically found in
the \program files\Microsoft Analyst Service\bin\ folder.
I'm not sure if 2: is required but it seemed to help.
This resolved the problem - I'm not technically competent enough to know why
but it worked!
Good luck.
"§Chrissi§" wrote:

> Do you have a solution to this problem? My OS is Windows 2000 server. I
> have another PC with Analysis Services. The msmdsrv.exe does not take cp
u.
> "Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
> news:%23qC1fGfdFHA.2696@.TK2MSFTNGP09.phx.gbl...
>
>sql

msmdsrv.exe Ordinal 801 error

Afternoon,

I am trying to install Analysis Services on Win2k, and I am getting an error I don't know what to do with...

msmdsrv.exe - Ordinal not found
The ordinal 801 could not be located in the dynamic link library msjet40.dll.

I have tried:
uninstalling and re-installing Analysis Services
updating MDAC
deleting msjet40.dll and then updating MDAC

I'm at a loss... Can any suggest anything?

Thanks in advance!!Howdy

You may have to remove entries from the Registry to clean it up.

Cheers

SG