Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

  Asked By: Scottie    Date: Dec 20    Category: Sharepoint    Views: 5805

We are trying to install SSRS on to our SharePoint web server but are getting permission errors.

Our farm topology is as follows:

SQL 2005 server

Windows SharePoint Services Database


Central Administration

Document Conversions Launcher Service

Document Conversions Load Balancer Service

Excel Calculation Services

Windows SharePoint Services Incoming E-Mail

Windows SharePoint Services Web Application


Document Conversions Load Balancer Service

Office SharePoint Server Search

Windows SharePoint Services Help Search

Windows SharePoint Services Incoming E-Mail

Windows SharePoint Services Web Application

The two SPservers are Hyper-V virtual servers both Windows 2008 SP-1 while the database server is a physical box with Windows 2008 SP-1 and the 3 servers are 64 bit.

We have the SQL reporting services on the SQL server installed and we have green checks in the Configure Report server (Except Report Manager Virtual Directory and Encryption keys)

We tried installing SSRS on SPserver-01 and it bombed out at the very end. We checked the RS_SP.log files and we have this error:

Activating feature in web app 'ABC'

Activating feature to root site collection: http://ABC.comcast.org

Install error: Cannot open database "ABC" requested by the login. The login failed.

Login failed for user 'ABCDEV\SPserver-01$'.

We then did the files only install and that worked, but when then did the custom install (rsCustomAction.exe /i) and gives the same error above.

We then went in to the SharePoint and added SPserver-01$ to the Site Collection Administrators for the ABC site collection and did the “repair” install of SRSS and we get the same error.

Link here: spsolution.blogspot.com/.../...ql-server-2005.html



1 Answer Found

Answer #1    Answered By: Angarika Shroff     Answered On: Dec 20

If you are trying to use sharepoint  integration mode for reporting  services, then you need to have basic SharePoint installed on the reporting services  box.

<<Report server  integration with a SharePoint server farm requires that you install  an instance of the SharePoint product or technology on the report server computer. A SharePoint farm consists of multiple servers that all use the same version of the SharePoint product or technology. The instance of the SharePoint product or technology that you install on the report server must be the same version as the other nodes in the farm>> (As per below MSDN link)

Check if this link helps, http://msdn.microsoft.com/en-us/library/bb283190(SQL.90).aspx

For troubleshooting configuration go through this link technet.microsoft.com/en-us/library/ms159704(SQL.90).aspx


Related Topics:



Related Post