Hey guys, I have 2 servers in seperate domain one for database and other for moss 2007. SERVER 1 : AD,DNS,SMTP,SQL SERVER 2005 sp3 .... SERVER 2: MOSS 2007 APPLICATION SERVER with sp2 and october cumilative updates applied. i have even installed NDP20-KB913384-X86.exe hot fix for .net framework 2.0 access voilation error. In CA my server 2 version is 12.0.0.6520 When i installed sql server 2005 on server 1 during installtion for report server i choosed install but do not configure. Now I decided to integrate the sql server report services into sharepoint and did some research and found some articles on msdn which says in order to integrate the report services into sharepoint i need to have a minimal install of moss 2007 on server hosting report services (correct me if i am wrong). since i have only 2 servers i decided to install the minimal installation of moss 2007 on my server 1 ( Web front end only ). Here are the steps i followed for it Installed .NET framework 3.0 Installed moss 2007 sp2 Installed october cumuilative update for wss then same for moss 2007. Installed .net framework 2.0 NDP20-KB913384-X86.exe hot fix. and then ran the psconfig from command line as psconfig -cmd configdb -connect -server <SQLServerName> -database SharePoint_Config_ <dbname> -user <domainusername> -password <password> -cmd helpcollections -installall -cmd secureresources -cmd services -install -cmd installfeatures -cmd applicationcontent -install it returned me success and then i went to CA and when i checked my server 1 version is shown as 12.0.0.6421. ( i think this is the version number that u get when u install moss 2007 sp2) but i have installed the cumilative updates too then why its not showing the same version as my server 2. and even when i go to report services configuration wizard i dont see sharepoint integration link.( Has this got anything to do with the version issue? ) Where did i go wrong? Guys i am waiting for ur suggestions.......... Cheers Friend.

After install sharepoint 2007 do you install "Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies" http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en Do you have this manual to install Reporting services Integration with sharepoint 2007 with SQL server 2005? http://blogs.msdn.com/sharepoint/attachment/4194088.ashxAndr Lage Microsoft SharePoint, CRM and Sybase Consultant Blog:http://aaclage.blogspot.com Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/

yes i did installed the addin . do i need to install the addin on both servers or only on report server instance?

If you are integrating a SharePoint farm with a report server deployment, copy or download the Reporting Services Add-in to each computer in the farm that has a Web server front-end.Andr Lage Microsoft SharePoint, CRM and Sybase Consultant Blog:http://aaclage.blogspot.com Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/

Hi, There is a pre-requisite beyond the addin...Either install SharePoint Server on your SSRS Server or install SSRS on your SharePoint Server . This enables the SSRS to be part of the SharePoint Farm. After you have SSRS installed on one of the SharePoint Servers and configured to use your SQL Server for its Db, create your SSRS Integrated Db, and as Andre has said ensure that you download the correct SSRS Addin for SharePoint. The Addin does not install SSRS but creates the features that allow you to configure the integration and if you also download report Builder 2 and configure it your users will be able to build reports with Report Builder.. Most people install SSRS on an Application Server in a multiple SharePoint Server Farm -Ivan Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.

I have installed the sql server sp3 and the sharepoint integration link appears now. I am yet to do remaing configurations for report server in CA. But can you tell why the servers in farm have different versions. server 2 version is 12.0.0.6520 server 1 version is 12.0.0.6421 ( i did applied the cumilative patches on this server too but still the version is same). Can i reapply the patch? Did i followed the steps in order ? what did i miss?. can any one point me to right link which explains how to join a new server into existing farm . Cheers, Friend.

Hey Guys, After lot of struggle i was able get to a stage where now both machines are showing same version and was able to configure reportservices half way (created the report services database in sharepoint integration mode and was able to access it from browser) but the problem i am facing now is Manage integration settings no error Grant database access no error Set server defaults when ever i click this link i get the error as below. i tried to change the custom errors mode to off and allowpagelevetrace to true in web.config but still i am not able to get detailed error message to trouble shoot any suggestions? Error message: An 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=Windows-1252', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Runtime Error</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head> <body bgcolor="white"> Server Error in '/' Application. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off". <configuration> <system.web> <customErrors mode="Off"/> </system.web> </configuration> Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL. <configuration> <system.web> <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/> </system.web> </configuration> </body> </html> --. Troubleshoot issues with Windows SharePoint Services.

Hey guys , I have reverted back to my old configuration and started over again . That is I have SERVER 1 : AD,DNS,SMTP,SQL SERVER 2005 sp3 .... SERVER 2: MOSS 2007 APPLICATION SERVER with sp2 and october cumilative updates applied. i have even installed NDP20-KB913384-X86.exe hot fix for .net framework 2.0 access voilation error. In CA my server 2 version is 12.0.0.6520 When i installed sql server 2005 on server 1 during installtion for report server i choosed install but do not configure. Now I decided to integrate the sql server report services into sharepoint and did some research and found some articles on msdn which says in order to integrate the report services into sharepoint i need to have a minimal install of moss 2007 on server hosting report services (correct me if i am wrong). since i have only 2 servers i decided to install the minimal installation of moss 2007 on my server 1 ( Web front end only ). Here are the steps i followed for it Installed .NET framework 3.0 Installed moss 2007 sp2 Installed october cumuilative update for wss then same for moss 2007. Installed .net framework 2.0 NDP20-KB913384-X86.exe hot fix. and then ran the psconfig from command line as psconfig -cmd configdb -connect -server <SQLServerName> -database SharePoint_Config_ <dbname> -user <domainusername> -password <password> -cmd helpcollections -installall -cmd secureresources -cmd services -install -cmd installfeatures -cmd applicationcontent -install psconfig -cmd upgrade.... then now in CA both servers show the same version. Then went to sql server report server configuration. i have created to domain accounts for services ( wnReportService and wbReportservice) for windows service and webservice. created a website for reporting services created app pool created virtual directory configured window identity(wnReportService) and web identity(wbReportService) created database in sharepoint integration mode. But when i go to browser and type the reportservice url http://machinename:8888/Reportservice i get error Error Msg: 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. i think it is related to permission issue. Can anyone let me know what kind permissions to provide for service accounts on sharepoint databases? Friend

Hey guys , I went to sharepoint CA and after performing the below steps Manage integration settings Grant database access and then when i access the report server url from browser (on report server machine)it works fine, but when i try to click Set server defaults I get the error message 401 unauthrized. and when i try to access the report server url from sharepoint CA machine i get the prompt asking for credentials. Report services making me mad hahah.. Trying to figure it out but if u have any inputs for me to speed of my resolution i will be thank ful Friend.

Hey guys, I ran the below command on Report server cscript adsutil.vbs set w3svc/NTAuthenticationProviders "NTLM" and now i can browse the report server url from the Sharepoint CA server and also i can access the set server defaults without any error. Just want to make sure am i doing it right way? or am i compromising the security? how ever as of know it is working fine for me but just want ur feedback on this if i am in right direction or not. Will mark it as answer after feedback from u guys Friend.

Hey Guys, No suggestions or comments???. I will mark it as answer then Friend.