Deployment error -- Incorrect ImpersonationInfo object

Hi,

I'm new to SSAS 2005 and I'm walking through the Analysis Services tutorial in the online documentation. So far so good until when I wanted to deploy the project. The error is

Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. 0 0

I don't know why it asked for ImpersonationInfo. I'm a local administrator of the computer and I want to deploy to local server.

However, when I went through the Deployment Wizard in Analysis Services, it was deployed successfully. When I switched back to Visual Studio AS project and tried to browse the cube or dimension, it failed again saying that

Either the user, [UserID], does not have access to the Analysis Services Tutorial database, or the database does not exist.

What am I missing? :(

Thanks
Jenny

[898 byte] By [JennyTam] at [2008-1-31]

«« Create 1 connection to execute multiple Packages
»» Object Datasource example in Win Forms

# 1

Nevermind. I've figured it out myself. I forgot to deploy the Adventure Works DW analysis services project first. Also, when I set up the data source, for some reasons, impersonation was selected by mistake.

Thanks!

JennyTam at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Analysis Services...

# 2

Hi Jenny Tam.
I had the same error. here is how to correct it
1-right-click on data source in solution explorer
2-select View Designer
3-select Impersonation Information tab, then Default box
It's all.

SaliDM at 2007-9-9 >

# 3

Thanks - I have the same problem and it is great solution.