"Error: SharePoint is installed but not configured" when installing the RS Add-in on Windows 2008
I ran across an interesting issue when trying to install the Reporting Services Add-in for SharePoint on a Windows 2008 server. We would get the error listed above when trying to install the Add-in.
We choose repair on the Add-in component. It got to the point of removing backup files and then we got the following error:
Setup was interrupted before Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft Sharepoint Technologies could be completely installed.
Uninstalling and reinstalling the add-in resulted in the same error and this is what we saw in the log:
User: SYSTEM
Installing Report Server feature.
SSRSCustomActionError: Sharepoint is installed, but not configured.
In the Event Log we also saw this error every time we ran the setup:
Log Name: Application
Source: Windows SharePoint Services 3
Date: 12/4/2008 10:34:39 AM
Event ID: 3351
Task Category: Database
Level: Error
Keywords: Classic
User: N/A
Computer: MYSERVER.myorg.org
Description:
SQL database login failed. Additional error information from SQL Server is included below.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
Event Xml:
<Event xmlns="https://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Windows SharePoint Services 3" />
<EventID Qualifiers="0">3351</EventID>
<Level>2</Level>
<Task>484</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2008-12-04T15:34:39.000Z" />
<EventRecordID>105973</EventRecordID>
<Channel>Application</Channel>
<Computer>MYSERVER.myorg.org</Computer>
<Security />
</System>
<EventData>
<Data>Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.</Data>
</EventData>
</Event>
My initial thought went to some sort of Kerberos issue, but everything checked out there. It turns out that the issue is with the actual installer in the fact that it will not try to impersonate on Windows 2008.
The resolution to the issue was to get the latest RS Add-in with the build of 9.00.3294. This allowed the RS Add-in to install successfully on Windows 2008.
It can be downloaded here:
Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies