I need to deploy my SSAS project to another server. On that analysis server there is a database, and it has a role with full control, and I'm added to that role.
When I try to deploy my project I get the following error:The database , 'MyASProject', contains an ImpersonationMode that is reserved for server administrators.
I know that in the SSAS Project, in Datasource Designer, there is a tabsheet called Impersonation Information and in Management Studio, in the ASDatabase property page there is a property called Data Source Impersonation Info.
I played with these properties, I must have tried every possible combination but it never works.
Does anyone know whats going on and what I should do
Maybe some additional information: The sql server and the analysis server are on different machines (not mine, not local). I'm not the administrator of any machine. So in MyASProject I have a datasource connecting to a remote sql server and I want to deploy to a remote analysis server
SSAS Project Deployment problems
StSt
You might need to become a memeber of Analysis Server's administraitors role.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.