Welcome: Guest!

Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

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

  Asked By: Scottie Terrell         Date: Dec 20, 2008      Category: Sharepoint      Views: 285
 

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

SPserver-01

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



SPserver-02

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

Tagged:                          

 

1 Answer Found

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

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

 


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
Hall of Fame  |  Facebook  |  Twitter  |  LinkedIn  |  Terms of Use  |  Privacy Policy  |  Contact us
RSS Feeds: Articles |  Forum |  New Users |  Activities |  Interview FAQ |  Poll |  Hotlinks


Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.

Copyright © 2008-2011