Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect

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 am getting the above error when I am trying to deploy my objects.

I am trying to deploy this on a named sql 2005 server. The host also have named sql 2000 instance.Search "Impersonation Information" in the Help.
I suggest use "Defualt" for quick fix.

Quoted from the help:

Use the Impersonation Information dialog box to provide information about the security credentials used by the Analysis Services object. You can display the Impersonation Information dialog box by:

Clicking the ellipsis (...) of the Data Source Impersonation Info property in the Database Properties dialog box of SQL Server Management Studio.

Clicking the ellipsis (...) of the Impersonation Info property in the Assembly Properties dialog box of SQL Server Management Studio.|||Hi,

In your project when you double click the Data Source object, you will see Data Source Designer screen.

Open Impersonation tab and check the user name and the password fields.

After corrections on this screen, you will probably deploy your project successfully.

Eralper
http://www.kodyaz.com|||

Hi,

thanks a lot for the suggession. This is working perfectly.

good show.

Swami.

|||

Thanks a lot, your help is very usefull.

I want to add that in the spanish version of sql server anylisis services the translation for Impersonation is "Suplantacion", what is not very proper. Anyway for spanish version of sql you have to look for "Informacion de Suplantacion" in "Origenes de Datos" properties.

Espero que ayude.

Saludos