After configuring a new SharePoint installation with (amongst others) Performance Point Services, I get the following error in the Event Log:
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 11-8-2011 20:00:01
Event ID: 3760
Task Category: Database
SQL Database 'PerformancePointDB' on SQL Server instance 'SHAREPOINT' not found. Additional error information from SQL Server is included below.
Cannot open database "PerformancePointDB" requested by the login. The login failed.
Login failed for user 'CONTOSO\SRV-SP-FARM'.
This error repeats every hour. The account mentioned, SRV-SP-FARM, is the farm account.
The section below is from the AutoSPInstallerInput file I used to install:
<!-- If you choose to provision Performance Point Services, the user running the script must be in the sysadmin role of the SQL server whilst the script runs. This can be revoked afterwards. -->
There were no errors in the installation. My question is: Am I doing something wrong here? If yes, what should I change in the script?