locked
WSUS on Server 2012R2 with SCCM 2012 R2 RRS feed

  • Question

  • I was trying to get this to work on my test lab. I got WSUS on separate box running on Windows Server 2012 R2 with SQL 2012 Standard SP1 database on separate box (SUSDB).

    I want to use SCCM 2012 R2 to do patching instead of using WSUS on my separate box. I've been struggling to make it work with my SCCM 2012 R2 (has SQL 2012 Standard SP1 CU3) box running on Windows Server 2012 R2

    No more what I did, either configuring with WID or Database on my SCCM 2012 R2, it never get it to work! This is so frustrating!!! :(

    Now, I think it got worse, I couldn't even fix it (no google information) regarding this error below:

    Fatal Error: Unable to open the physical file "C:\Windows\WID\Data\SUSDB.mdf". Operating system error 2
    Could not restart database "SUSDB". Reverting to the previous status.

    I really appreciated if someone could address this.

    Thanks,
    Reza

    • Moved by Lawrence Garvin Tuesday, December 24, 2013 6:48 PM Configuring a SUP on ConfigMgr2012
    Tuesday, December 24, 2013 5:14 AM

Answers

  • It's really not a ConfigMgr question, its Windows Server question.

    When installing WSUS on a remote SQL it's important that you unselect "WID database", and select "Database" during the installation (Role Services). This will allow you to specify the SQL Server you wish to use.

    So I'd recommend that you uninstall WSUS from the remote server and try again.

    Since this is a dedicated server (in a lab), you could also just build a new server.


    Ronni Pedersen | Microsoft MVP - ConfigMgr | Blogs: www.ronnipedersen.com/ and www.SCUG.dk/ | Twitter @ronnipedersen

    • Proposed as answer by Joyce L Monday, December 30, 2013 5:55 AM
    • Marked as answer by Joyce L Tuesday, December 31, 2013 7:56 AM
    Thursday, December 26, 2013 9:45 PM