What acount is used when MSPOLAPBreakout is run?

[Bob Segrest]

Hello Everyone,

I have written code to extend the OLAP cube and tested it using the OLAP
Breakout Test utility supplied in the Project 2003 SDK. Everything works
great in the test mode, but I am getting errors when I use the resulting
MSPOLAPBreakout.DLL module.

More specifically, I am receiving a "CREATE TABLE permission denied" error
which implies that the user context MSPOLAPBreakout runs in does not have
permission to create a SQL table in the project database.

I was under the impression that MSPOLAPBreakout runs under the OLAPAdmin
account. I tried giving OLAPAdmin SA access to the SQL database, but did not
see any change in symptom.

Can anyone verify that the OLAPAdmin account is used when MSPOLAPBreakout is
run?

If not, what account is used?


Bob Segrest, PMP
BSegE LLC
(540) 937-5875
http://www.BSegE.com

 

[Lars Hammarberg]

The breakout is using the MSPROJECTSERVERUSER id and password when accessing
the ProjectServer database - if you didn't substitute another account for
the default account.

If you examine the connection object you get as an input parameter in the
breakout code, you'll find the account used on your server.

It's executed under the COM+ OLAP account (OLAPAdmin), though.