Verify that the impersonation account has access to the Microsoft SQL Server database. The Web Service uses impersonation to make connections from the Analysis Center Console and Data Extensions to the Analysis Center Data Warehouse. The connection will fail if this account does not have the correct permissions. For more information, see the Microsoft Software Developer Network article at http://msdn2.microsoft.com/en-us/library/dwc1xthy(VS.80).aspxAlso, verify that the ASPNET account has administrative access to the local computer.
Analysis Center WebService uses the Service account context for the Impersonation account.