Scenario: We have a server farm that consists of (2) back-end servers, (2) web front-ends that are accessed via the internal network, and (2) web front-ends that are accessed from outside the network (i.e. Extranet users). The two Extranet front-ends are firewalled off from the network and can only access the SQL database and a read-only domain controller.

Issue: PowerPivot has been installed on the four internal servers without issue. However, when trying to install PowerPivot on the two Extranet servers, I get the following error when trying to configure the Service Account during install:

The credentials you provided for analysis services service are invalid. To continue, provide a valid account and password for analysis services service.

Any ideas why I am having this issue?


The only solution I could find to this is temporarily joining the server to a network with a regular, non read-only, domain controller in it. Had attempted to add the SPNs for Analysis Services and the SQL Browser manually, but that didn't work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.