SharePoint 2007 Integration with SQL Server 2005 Reporting Services
- From: A4orce84@xxxxxxxxxxx
- Date: Fri, 29 Jun 2007 18:03:55 -0700
Hello Everyone,
I have been banging my head against the wall with trying to integrate
SharePoint 2007 and SQL Reporting Services. I have been following
these 2 websites down to the letter in trying to configure everything:
1. http://msdn2.microsoft.com/en-us/library/bb326356.aspx <---
Microsoft's Steps
2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-
wss-3-0-and-moss-2007.aspx <---SharePoint Blog Group
Basically my setup is as follows:
Server 1 = SharePoint 2007
Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007
services
Server 3 = Database
Server1 is setup and running SharePoint 2007 fine with no problems. It
was installed under the complete option with its own server farm. Then
with the Server2, SharePoint 2007 is installed again, also under the
complete complete option, and configured to join Server1's server
farm. In this way, Server2 is able to supply Server1 with services and
it has been said that if you are using 2 different servers, one for
SharePoint and one for Reporting Services, you need to have an
instance of SharePoint on the reporting services box. With a
SharePoint "front-end" the reporting-services now has a way to also
join Server1s farm.
This is where the headache begins....the SharePoint install is
successful on Server2 and the services are started as evident through
the Central Administration page. The next task is to install SQL
Server 2005 Reporting Services and then the SQL Server 2005 SP2
patch.
After installing SQL Server and the SP2 patch, you go into the SQL
Reporting Services Configuration Manager and setup the Report Server,
Database, and SharePoint integration. I configure everything to run
under the "DefaultAppPool" under IIS, and I get green accepted
checkboxes on everything.
Finally, the last step is to install Microsoft SQL Server 2005
Reporting Services Add-in for Microsoft SharePoint Technologies on
Server1. This add-in actually allows the connection between SharePoint
on Server1 to the Reporting Services on Server2. The install is
successful and the extra options for reporting pop up under Central
Administration page. When configuring the final connection under the
Central Admin I referred to the following Microsoft Page:
http://msdn2.microsoft.com/en-us/library/bb326213.aspx
For the "manage integration settings", I set the report server to
Server2 and use Windows Authentication. Then for the "grant database
access" I use Server2 and login with my credentials...
PROBLEM: Then for the final step of setting the server defaults, I
click on the link and get the following error:
"An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. "
I have googled and tried installing/uninstalling several times, but it
seems that I keep getting hung up here. When trying to access reports
on the ReportServer, the same error message comes up.
If anyone is familiar with integration between SharePoint and SQL
Reporting Services, and may have any ideas/comments/advice, I would
greatly appreciate it. Thanks in advance! =)
--A4orce84
.
- Prev by Date: Unable to connect to the database SPS01_Config_db
- Next by Date: WinPE 2.0 from WAIK and WMI
- Previous by thread: Unable to connect to the database SPS01_Config_db
- Next by thread: WinPE 2.0 from WAIK and WMI
- Index(es):
Relevant Pages
|
Loading
