|Q: When I am browsing Real-time ROLAP cube, I am getting error message: OLE DB Error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.|
|Written by Vidas Matelis|
|Saturday, 13 March 2010 03:28|
Q: When I am browsing Real-time ROLAP cube, I am getting error message: OLE DB Error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.
A: When you setup measure group property ProactiveChaching to "Real-time ROLAP" then SSAS assigns by default partition notification type to 'SQL Server'. This notification type uses SQL Server trace to track changes to your tables. For these traces to work properly, either the data source or Analysis Services service account should be configured to use an account with System Administrator privileges on the SQL Server.
So to fix this problem you should identify service account that Analysis Services is using and then assign it to the sysadmin server role.
You can also consider changing Notification type used by Proactive caching.You can do this by following these steps:
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- What TCP port SQL Server Analysis Services 2005 uses
- MDX-How do you calculate monthly average of one year, optionally including empty months?
- MDX-How do I calculate sales for 12 Month to date?