dbTalk Databases Forums  

Problem in cube processing

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problem in cube processing in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sanjeev
 
Posts: n/a

Default Problem in cube processing - 08-22-2005 , 05:41 AM






I have analysis server(server1) on one server and my website is hosted
on another server(server2). I want to initiate processing of cube
through server2, for that I creted a dts package on the server1, now
when i run dtsrun command through server2

"dtsrun /SAnalysisServer\server /NProcess_cube /E"

I get an error message

"could not find msmdso.rll in c:\windows\system32\resources\1033\"

DSO is installed on this machine, i have also put msmdso.rll in this
folder, but this does not work.

Please help

Thanks,
Sanjeev


Reply With Quote
  #2  
Old   
Joel Leong
 
Posts: n/a

Default RE: Problem in cube processing - 08-28-2005 , 08:12 PM






You have to install AS in your web server. Process cube need to read several
registry key which will be created after you install AS in your web server.
You don't have to install the AS server during AS installation.

DtsRun need Sys Admin role as well. Make sure you have the appropriate rights.

"Sanjeev" wrote:

Quote:
I have analysis server(server1) on one server and my website is hosted
on another server(server2). I want to initiate processing of cube
through server2, for that I creted a dts package on the server1, now
when i run dtsrun command through server2

"dtsrun /SAnalysisServer\server /NProcess_cube /E"

I get an error message

"could not find msmdso.rll in c:\windows\system32\resources\1033\"

DSO is installed on this machine, i have also put msmdso.rll in this
folder, but this does not work.

Please help

Thanks,
Sanjeev



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.