Cannot open database "PerformancePointDB"

Aug 11, 2011 at 6:21 PM

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
Level:         Critical
Keywords:     
User:          CONTOSO\SRV-SP-FARM
Computer:      CONTOSO-SPAPP01.contoso.int
Description:
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. -->
        <PerformancePointService Provision="true"
                      Name="PerformancePoint Service"
                      ProxyName="PerformancePoint Service"
                      UnattendedIDUser="CONTOSO\SRV-SP-PERF"
                      UnattendedIDPassword="p@ssw0rd">
            <Database>PerformancePointDB</Database>
        </PerformancePointService>

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?

Thanks, Marco

 

Aug 13, 2011 at 4:09 PM

See step #3 here: http://autospinstaller.codeplex.com/discussions/263027

You may just have to give it permissions post-install.

Coordinator
Aug 21, 2011 at 1:21 PM

I've just observed this myself (on some environments, but not others, strangely). To fix, I have added lines to grant the Farm Account rights to the PerformancePoint DB - will be included in next check-in.

Brian