SQL Server Performance Forum – Threads Archive

DTS which used to process a cube now fails??

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?? Thanks.

This behavior occurs because the security permissions change on the Data folder when you install Microsoft SQL Server 2000 Analysis Services SP3. If you execute the DTS manually it will be running under your own login context, which might have admin rigths including OLAP admin rights on the box. When you schedule it then you must ensure the SQLAgent has required privileges and the used account must be a member of OLAP Administrators. To work around this problem, assign the OLAP Administrators group full control of the remote Data folder. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks satya. Everyting else seems to be fine and is the same as it has been sincethe past so many months EXCEPT for the lasttip that you have given i.e. "To work around this problem, assign the OLAP Administrators group full control of the remote Data folder." I will try this. Thanks.

]]>