SQL Reports - With Standard Version of Sharepoint
- I have installed the SharePointRS.msi.
But could not see the "Reporting Services", under Application Management.
I am using standard Version of Sharepoint 2007.
Please help me....- ПеремещеноMike Walsh MVPMVP, Модератор26 июня 2009 г. 11:57rs q (From:SharePoint - Setup, Upgrade, Administration and Operation)
Ответы
- I have finally Installed.
using following command,
C:\Users\tfs.admin>msiexec /i C:\Downloads\SharePointRS.msi skipca=1- Помечено в качестве ответаJ Mathews 13 июля 2009 г. 11:37
Все ответы
- Reporting Services questions go to Business Intelligence.Moving this.
WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx Please make sure you have followed the steps to configure the reporting service:
- How to: Configure SharePoint Integration on a Stand-alone Server
- How to: Configure SharePoint Integration on Multiple Servers
If the "Reporting Services" section didn't disappear then, please let me know the topology of your farm and logs in the Event Viewer for further research.
-lambert
Lambert Qin | Microsoft Online Support EngineerHow to ask a question in the forum (http://support.microsoft.com/kb/555375)Posting is provided "AS IS" with no warranties, and confers no rights.- I could not install the SharePointRS.Follwoing is the error.
Install error: The EXECUTE permission was denied on the object 'proc_putObject', database 'VDevMossSharePoint_Config', schema 'dbo'. - I sort the erlier SQl issue.
But i am still having issue with installation of SharePointRS.
Activating Report Server feature to root level site collections.
Activating feature in web app 'SharePoint - 80'
Activating feature to root site collection: http://v-dev-moss-02
******* User does not have permission to add feature to site collection: http://v-dev-moss-02
Activateing Report Server feature in all admin site collections.
Activating feature in web app ''
Activating feature to root site collection: http://v-dev-moss-02:12000
******* User does not have permission to add feature to site collection: http://v-dev-moss-02:12000 - Very common question, reference this thread, has steps for issues related to errors posted above:
http://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/2ea50813-f0c2-46e8-99cb-d8cf3e988c4a
Please click the Mark as Answer button if a post solves your problem!- Помечено в качестве ответаLambert QinMSFT, Модератор3 июля 2009 г. 6:49
- Снята пометка об ответеJ Mathews 7 июля 2009 г. 10:26
- I have compted the installation some how.
But could not see the "Reporting Services", in the Application Management.
I am using the standard version of Sharepoint. - Did you follow steps 7 and 8 on the link above provided? (Repasted below)
7. After the install, you will probably need to navigate to Central Administration > Site Actions > Site Settings and under the heading Site Collection Administration click Site Collection Features.
8. From there, click activate on Report Server Integration Feature
9. The settings for SSRS will now have their sub section on the Application Management tab in Central Admin
Is the Reporting Services Integration feature missing from the list of Site Collection Features in Central Admin?
Please click the Mark as Answer button if a post solves your problem! - Yes, Reporting Services Integration feature missing from the list of Site Collection.
But after installation my Log says installation is complete and configuration required. What is the farm configuration? One or multiple servers?
When the installation said it succeeded, where you still walking through the GUI or using the command line steps indicated in my link?
To get this installed, make sure you are logged in as a user that has MOSS farm admin privileges, and make sure to run the command prompt with elevated permissions. Check the outcode codes as well, example below:
Outcome code is: 32Calling HCInstal for lcid '3082'
Please click the Mark as Answer button if a post solves your problem!- I still have th error.
as following,
SSRSCustomActionError: SharePoint is installed, but not configured.
I am using One web server and SQL sever.(Farm Cofiguration, but missing on Front end server).
I don't know which is configration i am missing.- ИзмененоJ Mathews 8 июля 2009 г. 12:52
Does the account you are logged into while installing this have the proper privileges on the SQL server? If the account you are logged into on the web server does not have permissions to the SQL Server and the associated MOSS databases, then the install will fail.
Please click the Mark as Answer button if a post solves your problem!I am stuck with follwoing error.
SSRSCustomActionError: Failed to find the XML file at location '12\Template\Feat
ures\ReportServer\feature.xml'
Do i need to do anything with the template folder?
I have only one Server(Front end server and webserver) and SQL Server in farm configuration.- Due to repeated installs that didn't fully work, you probably need to do a proper uninstall, then install to make sure all the files get deployed fully.
From the command line, run rsSharePoint.msi -u. After it completes, start fresh from the steps listed above.
Please click the Mark as Answer button if a post solves your problem! I could not complete the installation see below full log,
User: SYSTEM
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 - 80'
Activating feature to root site collection: http://v-dev-moss-02
******* User does not have permission to add feature to site collection: http://v-dev-moss-02
Activateing Report Server feature in all admin site collections.
Activating feature in web app ''
Activating feature to root site collection: http://v-dev-moss-02:12000
******* User does not have permission to add feature to site collection: http://v-dev-moss-02:12000
Updating DocIcon.xml file
DocIcon.xml file updated.
Beginning install of cab files.
Calling HCInstal for lcid '1033'
Outcome code is: 256Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\hcinstal.exe return error code: 8
Uninstalling Report Server feature.
Uninstalling Report Server feature.
Report Server feature was uninstalled.
Stopping W3SVC service.
Removing Report Server web application files
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.cs-CZ.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.da-DK.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.de-DE.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.el-GR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.es-ES.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.fi-FI.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.fr-FR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.hu-HU.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.it-IT.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.ja-JP.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.ko-KR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.nb-NO.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.nl-NL.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.pl-PL.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.pt-BR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.pt-PT.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.ru-RU.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.sv-SE.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.tr-TR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.zh-CN.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.zh-TW.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\80\App_GlobalResources\ReportServer.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.cs-CZ.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.da-DK.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.de-DE.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.el-GR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.es-ES.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.fi-FI.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.fr-FR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.hu-HU.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.it-IT.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.ja-JP.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.ko-KR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.nb-NO.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.nl-NL.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.pl-PL.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.pt-BR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.pt-PT.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.ru-RU.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.sv-SE.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.tr-TR.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.zh-CN.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.zh-TW.resx.
Removed file C:\inetpub\wwwroot\wss\VirtualDirectories\37733\App_GlobalResources\ReportServer.resx.
Removing DocIcon.xml file updates
Beginning uninstall of cab files.
Calling HCInstal for lcid '1033'
Outcome code is: 4Calling HCInstal for lcid '3082'
Outcome code is: 32Calling HCInstal for lcid '2070'
Outcome code is: 32Calling HCInstal for lcid '2052'
Outcome code is: 32Calling HCInstal for lcid '1055'
Outcome code is: 32Calling HCInstal for lcid '1053'
Outcome code is: 32Calling HCInstal for lcid '1049'
Outcome code is: 32Calling HCInstal for lcid '1046'
Outcome code is: 32Calling HCInstal for lcid '1045'
Outcome code is: 32Calling HCInstal for lcid '1044'
Outcome code is: 32Calling HCInstal for lcid '1043'
Outcome code is: 32Calling HCInstal for lcid '1042'
Outcome code is: 32Calling HCInstal for lcid '1041'
Outcome code is: 32Calling HCInstal for lcid '1040'
Outcome code is: 32Calling HCInstal for lcid '1038'
Outcome code is: 32Calling HCInstal for lcid '1036'
Outcome code is: 32Calling HCInstal for lcid '1035'
Outcome code is: 32Calling HCInstal for lcid '1032'
Outcome code is: 32Calling HCInstal for lcid '1031'
Outcome code is: 32Calling HCInstal for lcid '1030'
Outcome code is: 32Calling HCInstal for lcid '1029'
Outcome code is: 32Calling HCInstal for lcid '1028'
Outcome code is: 32Cab files uninstalled successfully.
Starting W3SVC service.
SSRSCustomActionError: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\hcinstal.exe return error code: 8- hmmm. At the moment, the only other thing I can suggest is to do the following:
- uninstall the RS bits so you are starting from scratch
- Pause all web sites in IIS
- Follow the steps I posted earlier from here: http://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/2ea50813-f0c2-46e8-99cb-d8cf3e988c4a
Please click the Mark as Answer button if a post solves your problem! No Luck.
My Sharepoint is installed on Win 2008 server.
Is it going to make any difference.- I have finally Installed.
using following command,
C:\Users\tfs.admin>msiexec /i C:\Downloads\SharePointRS.msi skipca=1- Помечено в качестве ответаJ Mathews 13 июля 2009 г. 11:37
