SQL 2005 Reporting Services Add-in - Installation Problem

Tue, 12 Aug 2008 16:04:09 Z

I am having a problem installing the SQL 2005 Reporting Services Add-in.

Environment:
All on one physical server
Windows Server 2008 Standard X64
SQL 2005 Enterprise x64 SP2 - Reporting Services Instance
SQL 2005 Express x86 SP2 - MOSS Instance

I have installed, uninstalled, and reinstalled several times.

What I end up with is the Reporting Services web part that I can add to a page but not configure and no feature for Reporting Services shows up in the Application Management area of Central Administration.

Does anyone know what else I could look at?

This is what the RS_SP log file reads:

User: <username>
Installing Report Server feature.
Calling copyappbincontents command.

copyappbincontents command completed successfully.
Adding Report Server feature to farm.
Installed Report Server feature.
Activating Report Server feature to root level site collections.
Activating feature in web app 'SharePoint - SiteA'
Activating feature to root site collection: http://<server>:<portSiteA>
Feature already activated in site collection http://<server>:<portSiteA>
Activating feature in web app 'SharePoint - SiteB'
Activating feature to root site collection: http://<server>
Feature already activated in site collection http://<server>
Activateing Report Server feature in all admin site collections.
Activating feature in web app ''
Activating feature to root site collection: http://<server>:<portCentralAdmin>
******* User does not have permission to add feature to site collection: http://<server>:<portCentralAdmin>
Updating DocIcon.xml file
DocIcon.xml file updated.
Beginning install of cab files.
Calling HCInstal for lcid '1033'

Outcome code is: 4

Calling HCInstal for lcid '3082'

Outcome code is: 4

Calling HCInstal for lcid '2070'

Outcome code is: 4

Calling HCInstal for lcid '2052'

Outcome code is: 4

Calling HCInstal for lcid '1055'

Outcome code is: 4

Calling HCInstal for lcid '1053'

Outcome code is: 4

Calling HCInstal for lcid '1049'

Outcome code is: 4

Calling HCInstal for lcid '1046'

Outcome code is: 4

Calling HCInstal for lcid '1045'

Outcome code is: 4

Calling HCInstal for lcid '1044'

Outcome code is: 4

Calling HCInstal for lcid '1043'

Outcome code is: 4

Calling HCInstal for lcid '1042'

Outcome code is: 4

Calling HCInstal for lcid '1041'

Outcome code is: 4

Calling HCInstal for lcid '1040'

Outcome code is: 4

Calling HCInstal for lcid '1038'

Outcome code is: 4

Calling HCInstal for lcid '1036'

Outcome code is: 4

Calling HCInstal for lcid '1035'

Outcome code is: 4

Calling HCInstal for lcid '1032'

Outcome code is: 4

Calling HCInstal for lcid '1031'

Outcome code is: 4

Calling HCInstal for lcid '1030'

Outcome code is: 4

Calling HCInstal for lcid '1029'

Outcome code is: 4

Calling HCInstal for lcid '1028'

Outcome code is: 4

Cab files installed successfully.
Stopping W3SVC service.
Starting W3SVC service.

SQL 2005 Reporting Services Add-in - Installation Problem

Wed, 13 Aug 2008 14:13:01 Z

I think my problem here is with the SQL 2005 Express installation. I am going to remove that component and see what the results are.

SQL 2005 Reporting Services Add-in - Installation Problem

Mon, 27 Apr 2009 16:46:35 Z

Are you still have this issue? If yes, then based on the logs it can be seen that user installing the msi:
Activating feature to root site collection: http://<server>:<portCentralAdmin>
******* User does not have permission to add feature to site collection: http://<server>:<portCentralAdmin>

Hence, you may need to activate the feature in Central Admin manually, for details refer to http://msdn.microsoft.com/en-us/library/bb677366(SQL.90).aspx.

HTH
Prash

This posting is provided "AS IS" with no warranties, and confers no rights.