Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals > Forums Home > System Center Essentials Forums > System Center Essentials - Deployment > SCE SP1 on Windows 2008

Answered SCE SP1 on Windows 2008

    •  
      Sunday, November 16, 2008 5:21 PM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hello,

      I'm having some real challenges getting SCE 2007 SP1 installed on Server 2008. I'll lay out what I've done, and hopefully someone can get me back on course. Any help is much appreciated, its been whooping me for a few days now.

       

      Environment:

      Windows 2008 x86 Standard - All Patches

      SQL 2005 SP2 Express with Advanced Technologies, x86. All features installed locally

       

      During SCE setup, it fails to find SQL Reporting Services as installed. I've found other users with this same challenge, but have been unable to resolve this for myself.

       

      I've been working off of this KB article:

      How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008 (http://support.microsoft.com/kb/938245/)

       

      It seems to work OK based on that KB, but SCE still fails to install.

       

      Any pointers or help someone can provide?


      Thanks,
      Tim

       

    Answers

    • Thursday, November 20, 2008 3:18 AM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

      Hi Tim,

       

      Which steps you encounter the problem? From the setup.log, I find following:

       

      A warning The selected SQL Reporting Server instance is not configured.

       

      1.In IIS Manager, open the Sites folder, and then open the folder of the Web site that contains the reportserver virtual directory. 

      2.Select the report server virtual directory.

      3.In the IIS area, double-click Handlers Mappings.

      4.In the Actions pane, click Edit feature Permissions.

      5.Click Script.

      6.Click OK.

      7.Repeat steps 2-6 for reports virtual directory

       

      If the problem remains, I recommend to re-build Windows Server 2008 as a workaround to see if it works.

       

      HTH.

       

    All Replies

    • Sunday, November 16, 2008 9:14 PM
       
       
      Sign In to Vote
      0
      Sign In to Vote

       

      Here is the error from my SCE Setup log:

       

      9:45 PM: EnumSRSInstances added instance : NATNM01.
      9:45 PM: DiscoverSRSInstanceInformation: SRS Instance is: MSSQLSERVER
      9:45 PM: DiscoverSRSInstanceInformation:  Actual SRS reg location is: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup
      9:45 PM: CheckHttpAddressResponse: WebException Raised. The following error occured : The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
      9:45 PM: StackTrace:    at System.Net.HttpWebRequest.GetResponse()
         at Microsoft.EnterpriseManagement.SCE.Setup.SrsHelper.CheckHttpAddressResponse(String httpSite)
      9:45 PM: Unable to find a working HTTP site from the /LM/W3SVC/1/Root/ReportServer iis node.
      9:45 PM: DiscoverSRSInstanceInformation: SRS Instance is: MSSQLSERVER
      9:45 PM: DiscoverSRSInstanceInformation:  Actual SRS reg location is: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup
      9:45 PM: CheckHttpAddressResponse: WebException Raised. The following error occured : The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
      9:45 PM: StackTrace:    at System.Net.HttpWebRequest.GetResponse()
         at Microsoft.EnterpriseManagement.SCE.Setup.SrsHelper.CheckHttpAddressResponse(String httpSite)
      9:45 PM: Unable to find a working HTTP site from the /LM/W3SVC/1/Root/ReportServer iis node.

       

      I've unchecked 'Require Secure Socket Layer (SSL) Connections' in the SRS Configuration Manager.

       

      Any guess what I've done wrong?


      Thanks,
      Tim

       
    • Tuesday, November 18, 2008 4:00 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi Tim,

       

      First, check if you can browse http://localhost/reports and http://localhost/reportserver correctly. Also, there is no SSL setting enabled in virtual directories of reports and reportserver.

       

      If the problem persists, try to reinstall SRS and patched sp2 to see if it works. 

       

      HTH.

       
    • Tuesday, November 18, 2008 4:40 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hello,

      Thanks for helping out with this.

       

      http://localhost/reports and http://localhost/reportserver work correctly, but to get them to do so I had to add them to my trusted sites list (so they open in a new window when I try to navigate to them. SSL is unchecked on the virtual directories inside IIS.

       

      I'm using SQL 2005 Express with advanced technologies, and am at SP2. I've reinstalled SRS so many times already. Do you know of specific guidance I can follow to ensure I'm not repeating a mistake during installation? I'm just installing every option, and allowing the setup wizard to configure SRS for me.

       

      Thanks in advance,
      Tim

       

       
    • Tuesday, November 18, 2008 9:22 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi,

       

      Navigate to %programfiles%\Microsoft SQL server\MSQL.2\Reporting Services\ReportServer\rsreportserver.config and find the strings of <Add Key="SecureConnectionLevel" Value="0"/>. Ensure the value is set to 0 and there is no certificate inside IIS.

       

      HTH.





       

       
    • Tuesday, November 18, 2008 1:07 PM
       
       
      Sign In to Vote
      0
      Sign In to Vote

       

      I've confirmed both settings. SecureConnectinLevel is set to 0, and there are absolutely zero certificates in IIS. There was a self signed cert, I deleted that and then did an IIS reset.

       

      One thing I've noticed, http://localhost/reports only works when I launch IE as an administrator. If I just run IE, I only get the header portion of the reports page.


      Thanks,
      Tim

       
    • Wednesday, November 19, 2008 3:40 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi Tim,

       

      Checked for the registry key (HKLM\Softwares\Microsoft\Microsoft Operations Manager). If it exists, deleted the registry keys. Also, check if the <SCE servername>_MG is there in ADUC. If so, please also delete it.

       

      Then, disable UAC temporarily and go to internet options->advanced tab to restore advanced setting.

       

      If the problem still persists, please send latesd SCESetupx.log, SCEX.log and SCEReportingx.log from %temp% to scedata@microsoft.com. Note copy following in email body:

       

      http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=4132750&SiteID=17

       

      HTH.

       
    • Wednesday, November 19, 2008 7:32 PM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hello,

      I didn't have the registry key, but I did have the group in AD. I suspect this was from a very old installation (pre SP1, on Win2k3) of SCE.

       

      I disabled UAC, and can now get to the reports site without opening an elevated IE window.

       

      Still no luck in installing SCE though, fails at same location. Log files sent.

       

      Thank you very much for looking into this.

      Thanks,
      Tim

       

       
    • Thursday, November 20, 2008 3:18 AM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

      Hi Tim,

       

      Which steps you encounter the problem? From the setup.log, I find following:

       

      A warning The selected SQL Reporting Server instance is not configured.

       

      1.In IIS Manager, open the Sites folder, and then open the folder of the Web site that contains the reportserver virtual directory. 

      2.Select the report server virtual directory.

      3.In the IIS area, double-click Handlers Mappings.

      4.In the Actions pane, click Edit feature Permissions.

      5.Click Script.

      6.Click OK.

      7.Repeat steps 2-6 for reports virtual directory

       

      If the problem remains, I recommend to re-build Windows Server 2008 as a workaround to see if it works.

       

      HTH.

       
    • Thursday, November 20, 2008 6:52 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

       

      Hello,

      Yep. I've made the changes to the Handlers Mappings section of IIS with no change.

       

      This is the 3rd build of 2k8 I've tried this on. I guess if I thought I would do something different to affect the outcome I'd reload it for the 4th time.

       

      Thanks for trying.

       

      Tim