SQL Server Performance

Problem with alaysis Server

Discussion in 'Analysis Services/Data Warehousing' started by rafaelrc, Oct 13, 2005.

  1. rafaelrc New Member

    Hi,


    I am trying to create a Data Source in analysis server, poiting to a Oracle Database installed in another machine over the network. Connection test is ok, but when a press ok button, i got the message: "Cannot update. Database or object is read-only".
    Thank you for the information.
    Rafael
  2. ranjitjain New Member

    Have you checked the oracle DB whether it is set to read only or not.
  3. satya Moderator

    This error usually indicates that you did not set the appropriate permissions on the database.

    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.
  4. rafaelrc New Member

    Problems still continues...DB is operating normally. I connect and make dml operatins normally.
    Is there anything about permissions in the OS? Does Analysis Manager save any file in any directory?
  5. satya Moderator

    Ensure you're using proper privileged account on AS & Oracle.

    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.
  6. ranjitjain New Member

    Also try creating a new dummy databse connecting to Access same like FoodMart2000.
    This is to make sure the previleges.

Share This Page