I am preparing to teach a class on SSAS. I am trying to run the demonstration and labs on my local machine. My machine has several differences from the lab environments provided by Microsoft. I don’t have an adventureworks domain with the appropriate user which I can use for the credentials of the data source for my SSAS project, so I used the SSAS service account. This account, which is not a sysadmin on my SQL Server, I added to the db_datareader in my source database.
I tried running an MDX query and I got the error “You do not have permission to run ‘SP_TRACE_CREATE’.; 42000.” I found that I needed to grant my SSAS service account “Alter Trace” permission on the database engine server.
use [master] GO GRANT ALTER TRACE TO [SSAS Service Account] GO
Now it appears to work just fine.