This issue prevents you from recreating the PowerPivot Service application by using the same application database name. Also, this issue may trigger a Microsoft SharePoint health message that resembles the following:
Event ID: 3760
Event Description: SQL Database '<Database name of PowerPivot Service application>' on SQL Server instance '<Instance name>' not found. Additional error information from SQL Server is included below.
Cannot open database "<Database name of PowerPivot Service application>" requested by the login. The login failed.
Login failed for user '<User Name>'.
SQL Server 2008 R2The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
SELECT Id, classid, parentid, name, status, version, properties
WHERE name like '%PowerPivot%'
ORDER BY name
Article ID: 2291697 - Last Review: 13-Sep-2011 - Revision: 1