locked
SRS Role SQL 2005 x64 / Windows X64? RRS feed

  • Question

  • Trying to setup the SRS role on a remote 2003 x64 server with SQl 2005 X64.

    Trying to install and setup the SRS on a remote SQL 2005 x64 / Windows X64 server.

    What i'm seeing is many of the logs on that server is that SCCM cannot find HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\MPFDM\Inboxes\.

    Those keys do exist under HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\SMS\MPFDM\Inboxes\

    Is there any fix for this?

    Is SRS role on a remote 2003 x64 server with SQl 2005 X64 even supported?
    Wednesday, September 23, 2009 2:40 PM

Answers

  • SOLUTION:

    ASP.net was not properly registered.
    The following cmd, and then enabling ASP web extension solved the problem:

    C:\WINDOWS\microsoft.net\Framework64\v2.0.50727>aspnet_regiis -i
    Start installing ASP.NET (2.0.50727).
    .......................................
    Finished installing ASP.NET (2.0.50727).

    C:\WINDOWS\microsoft.net\Framework64\v2.0.50727>iisreset

    Attempting stop...
    Internet services successfully stopped
    Attempting start...
    Internet services successfully restarted

    C:\WINDOWS\microsoft.net\Framework64\v2.0.50727>

    • Proposed as answer by TorstenMMVP Thursday, September 24, 2009 7:12 AM
    • Marked as answer by BhaskarK - MSFT Friday, September 25, 2009 11:44 PM
    Wednesday, September 23, 2009 5:20 PM

All replies

  • Hi,

    The SRS role is supported on a Windows X64 server according to the docs - http://technet.microsoft.com/en-us/library/cc161851.aspx What errors do you see SRSRPSetup.log file on the site server?

    Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products
    Wednesday, September 23, 2009 3:34 PM
  • Hi,

    No errors at all. I should point out that SCCM is looking for reg keys in the X86 keys, not the Wow6432Node,

    <09-23-2009 08:06:30> ====================================================================
    <09-23-2009 08:06:30> SMSSRSRP Setup Started....
    <09-23-2009 08:06:30> Parameters: \\SERVER\W$\SMS\bin\i386\ROLESE~1.EXE /install /siteserver:SERVER SMSSRSRP
    <09-23-2009 08:06:30> Installing Pre Reqs for SMSSRSRP
    <09-23-2009 08:06:30>         ======== Installing Pre Reqs for Role SMSSRSRP ========
    <09-23-2009 08:06:30> Found 0 Pre Reqs for Role SMSSRSRP
    <09-23-2009 08:06:30>         ======== Completed Installion of Pre Reqs for Role SMSSRSRP ========
    <09-23-2009 08:06:30> Installing the SMSSRSRP
    <09-23-2009 08:06:30> Invoking process "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe" "W:\SMS\bin\i386\SRSSERVER.dll"
    <09-23-2009 08:06:31> Registered DLL W:\SMS\bin\i386\SRSSERVER.dll
    <09-23-2009 08:06:31> Installation was successful.

    The only errors are actually in the smsexec.log

       WARNING: Could not read registry key HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\MPFDM\Inboxes\ on the server, The operating system reported error 0: The operation completed successfully. SMS_EXECUTIVE 9/23/2009 8:06:34 AM 5012 (0x1394)

    and the srsrp.log

       WARNING: Could not read registry key HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\MPFDM\Inboxes\ on the server, The operating system reported error 0: The operation completed successfully. SMS_SRS_REPORTING_POINT 9/23/2009 9:03:42 AM 992 (0x03E0)
    Failures reported during periodic health check by the SRS Server SERVER. Will retry check in 57 minutes 

    Wednesday, September 23, 2009 3:39 PM
  • Wow6432Node is the X86 node . All 32-bit applications will see this node as if it were the actual HKLM\Software. Only 64-bit applications (by default) will actually see HKLM\Software\Wow6432Node. This is all documented here: http://msdn.microsoft.com/en-us/library/ms724072%28VS.85%29.aspx.

    Can you post a snippet of logs where you are seeing errors?

    Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
    Wednesday, September 23, 2009 4:06 PM
  • The snippets are in the post before your post :)

    Ok, thanks for pointing that out.

    But those reg key do not exist on the SRS that SCCM is looking for. All and any reg keys for 'SMS' are in the HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\SMS\MPFDM\Inboxes\, not HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\MPFDM\Inboxes\.
    Wednesday, September 23, 2009 4:11 PM
  • Where they exist depends on the the application looking for them.

    64-bit apps will see HKLM\Software\Wow6432Node.

    32-bit apps will not HKLM\Software\Wow6432Node. This node is a virtual node that is redirected to HKLM\Software by windows for 32-bit apps.

    To see this in action, open the 32-bit regedit from c:\Windows\syswow64 -- you will not see HKLM\Software\Wow6432Node.

    In addition to the MSDN documentation, here's a KB that discusses this pretty extensively: http://support.microsoft.com/kb/305097.


    Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
    Wednesday, September 23, 2009 4:22 PM
  • Got-cha.

    There is still an issue with the way then that SCCM is installing and registering the SRS role on this x64 server.

    SCCM is a 32 bit app. SRS is looking for HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\MPFDM\Inboxes. The inboxes key is not present.

    Also, on the SRS site server there is no inboxes dir to begin with.

    Sorry if this is a silly question, but are the inbox dir and reg keys suppose to have been created and set by the SRS install, or another Role install?
    Wednesday, September 23, 2009 4:44 PM
  • SOLUTION:

    ASP.net was not properly registered.
    The following cmd, and then enabling ASP web extension solved the problem:

    C:\WINDOWS\microsoft.net\Framework64\v2.0.50727>aspnet_regiis -i
    Start installing ASP.NET (2.0.50727).
    .......................................
    Finished installing ASP.NET (2.0.50727).

    C:\WINDOWS\microsoft.net\Framework64\v2.0.50727>iisreset

    Attempting stop...
    Internet services successfully stopped
    Attempting start...
    Internet services successfully restarted

    C:\WINDOWS\microsoft.net\Framework64\v2.0.50727>

    • Proposed as answer by TorstenMMVP Thursday, September 24, 2009 7:12 AM
    • Marked as answer by BhaskarK - MSFT Friday, September 25, 2009 11:44 PM
    Wednesday, September 23, 2009 5:20 PM
  • Bud dy

    I am having the same issue, did you register ASP.net on the remote SQL server or the SCCM box?

    Cheers
    Wednesday, October 7, 2009 9:19 PM