Problem with alaysis Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem with alaysis Server

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
Have you checked the oracle DB whether it is set to read only or not.
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.
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?
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.
Also try creating a new dummy databse connecting to Access same like FoodMart2000.
This is to make sure the previleges.
]]>