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:
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
SQL database login failed. Additional error information from SQL Server is included below.
Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’.
<Provider Name=”Windows SharePoint Services 3″ />
<TimeCreated SystemTime=”2008-12-04T15:34:39.000Z” />
<Data>Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’.</Data>
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