Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 DTS which used to process a cube now fails??

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2005-04-08 : 01:39:03
Untill a few days back everyting was fine but since recently my DTS which was scheduled to process a cube now fails. I looked at the detais of the scheduled job and in summary this is the message that it shows:

...Error string: Unable to connect to the registry on the server (UKT19), or you are not a member of the OLAP Administrators group on this server....
I have not made any changes and thus do not understand this problem. The strange part is that when I manually run the DTS, it works fine.

Any clues??

dshelton
Yak Posting Veteran

73 Posts

Posted - 2005-04-17 : 23:17:24
It sounds like the scheduled job is running under a different login than your own. Check to see what login the scheduled job runs under.
Go to Top of Page
   

- Advertisement -