We have a cube that runs fine on one server but when I deploy and process it
on another server I get the following error when trying to run queries
against it:

OLE DB error: OLE DB or ODBC error: You do not have permission to run
'SP_TRACE_CREATE'.: 42000.

Any ideas?

I'm going to go ahead and answer my own question so that the solution will be
here for others to find.

One of our partitions is using Automatic MOLAP and is looking at the fact
table for notifications. Neither the user in the data source nor the AS
service account had admin privileges and evidently it uses sp_trace_create
(my own conclusion, I may be wrong about this) to create the trace that
monitors the tracking table that is specified. Once I set up the AS service
account as a sysadmin everything worked fine, without even having to
reprocess the cube.

"John Williams" wrote: