As I wanted to test around with the comming ssas tabular mode, i succesfully installed the evaluation version RC 0 of SQL server 2012 in a virtual environment. After a deployment failure, I noticed the "NT Service\MSSQLServerOLAPService" account was missing. So i promptly added it in MSSMS/"SQL server instance"/Security/Logins.
What "server Roles" should i granted to this account in a "best practice scenario" if i want to balance rights and security?
Hi Challen Fu,
thx for your advice.
While waiting for an answer, i'v' created the account in MSSMS and gave it the sa role. and so far everything went well. So I was wondering if It might be necessary to downgrade its role for security reasons ?