Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akarra
Starting Member
15 Posts |
 Posted - 2010-04-09 : 15:01:25
|
| Iam facing a problem in integrating the SQL Server 2005 with the Sharepoint Server 3.0 Here's the background:· Sql Server 2005 is installed on a separate box, let's call it SERVER1. This Sql Server hosts both the MOSS content database as well as the reporting services database. · MOSS 2007 is installed on a different box, let's call it SERVER2 · I've installed all the required components for both boxes with no installation errors · SSRS seems to be running fine on SERVER1 and the configuration tool is showing the report services are running.· MOSS is running ok on SERVER2 · Also I reset the IIS server on server1· I can see that SERVER1 is in the same farm after I've installed WSS3.0 on SERVER1· Also I can see the "Reporting Services" section in Central AdministrationSo all in all, everything seems to be ok. However, Iam getting the below errors Error in the log file when trying to access the reporting database from management Studio w3wp!library!9!04/09/2010-10:29:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.w3wp!library!9!04/09/2010-10:29:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.;Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. Error when trying to link from moss 2007 central administrationAn unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.The request failed with the error message:--<html><head><title>SQL Server Reporting Services</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3282.00" /><meta name="HTTP Status" content="500" /><meta name="ProductLocaleID" content="9" /><meta name="CountryLocaleID" content="1033" /><style>BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}</style></head><body bgcolor="white"><h1>Reporting Services Error<hr width="100%" size="1" color="silver" /></h1><ul><li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3282.00" target="_blank">Get Online Help</a></li></ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span></body></html>--. Troubleshoot issues with Windows SharePoint Services. When trying to open the report from normal URl the below is the error. Error when trying to open the report from normal URL http://hostname/reportserverReporting Services Error --------------------------------------------------------------------------------The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help --------------------------------------------------------------------------------SQL Server Reporting Services |
|
|
|
|
|
SSRS integration with sharepoint