Try this:

When setup your datasource, on the Share Data Source dialog box menu, in Credentials tab, choose "No credentials".

Hope this helps.

Qiang

Finally solved this problem by installing these two components:

1. Microsoft Core XML Services (MSXML) 6.0

http://www.microsoft.com/downloads/info.aspx?na=46&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=993c0bcf-3bcf-4009-be21-27e85e1857b1&u=http://download.microsoft.com/download/2/e/0/2e01308a-e17f-4bf9-bf48-161356cf9c81/msxml6.msi

2. Microsoft SQL Server...

.

I check the Analysis Server Properties Security page but nobody is in there, even though they all have...