SQL 2005 Reporting Services Add-in - Installation Problem
- 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: 4Calling HCInstal for lcid '3082'
Outcome code is: 4Calling HCInstal for lcid '2070'
Outcome code is: 4Calling HCInstal for lcid '2052'
Outcome code is: 4Calling HCInstal for lcid '1055'
Outcome code is: 4Calling HCInstal for lcid '1053'
Outcome code is: 4Calling HCInstal for lcid '1049'
Outcome code is: 4Calling HCInstal for lcid '1046'
Outcome code is: 4Calling HCInstal for lcid '1045'
Outcome code is: 4Calling HCInstal for lcid '1044'
Outcome code is: 4Calling HCInstal for lcid '1043'
Outcome code is: 4Calling HCInstal for lcid '1042'
Outcome code is: 4Calling HCInstal for lcid '1041'
Outcome code is: 4Calling HCInstal for lcid '1040'
Outcome code is: 4Calling HCInstal for lcid '1038'
Outcome code is: 4Calling HCInstal for lcid '1036'
Outcome code is: 4Calling HCInstal for lcid '1035'
Outcome code is: 4Calling HCInstal for lcid '1032'
Outcome code is: 4Calling HCInstal for lcid '1031'
Outcome code is: 4Calling HCInstal for lcid '1030'
Outcome code is: 4Calling HCInstal for lcid '1029'
Outcome code is: 4Calling HCInstal for lcid '1028'
Outcome code is: 4Cab files installed successfully.
Stopping W3SVC service.
Starting W3SVC service.
All Replies
- 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.
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.

