I'm with a project using Sql Server 2008 on Windows Server 2008 R2.
It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled).
And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege
to my windows account (ERROR: Only an administrator can make changes to server properties).
Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine).
View Complete Post