SQL Server Performance

DTS which used to process a cube now fails??

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Apr 7, 2005.

  1. Joozh New Member

    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.
  2. satya Moderator

    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.
  3. Joozh New Member

    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.

Share This Page