SSAS 2012 – You do not have permission to run ‘SP_TRACE_CREATE’.; 42000

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]

Now it appears to work just fine.

About Russ

Russ Loski is a data warehouse developer focusing on SSIS and SQL Server development. He has worked with SQL Server since 1998. He has used various technologies to move data from one source to others. He has worked for well-known companies such as the Bank of America, the Dallas Cowboys Football Club, T-Mobile and Coca Cola Enterprises. Currently he is developing a Data Warehouse for a large health care organization.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply