locked
Moved Site DB and SUSDB to new SQL Server - WSUS service stops after a few minutes RRS feed

  • Question

  • I successfully moved the Site DB from being hosted on the SCM 2012 R2 server SQL to a new 2014 SQL server. This went without issue. After getting the SCCM DB moved I wanted to move the WSUS DB. I followed the directions on this post: http://blogs.technet.com/b/mwiles/archive/2011/06/17/how-to-move-the-wsus-database.aspx and all went well with the move.

    The WSUS service starts and then after about 2-3 minutes, it stops. There's nothing apparent in the event log, just that the service terminated unexpectedly and will be restarted in 6000ms. Any ideas on what I need to check to figure out what's up with the WSUS.

    Could I uninstall the WSUS component and basically start from scratch? This is a small installation and that actually wouldn't be a problem to do.

    -BH


    • Edited by Bryan Heusmann Sunday, February 28, 2016 1:53 AM Update Title
    Sunday, February 28, 2016 1:53 AM

All replies

  • Some investigation into the Event Logs. I looked at the login's and security on the SQL server and all was associated and set as it should be (I'm assuming).

    On the SQL Server, I'm assuming when the WSUS service starts and then stops. Application Log: Login failed for user 'Domain\SCCM_Server$'. Reason: Failed to open the explicitly specified database 'SUSDB'. [CLIENT: 10.0.10.13]

    On the SCCM server, which I can no longer open the ConfigManager Console. Application log: Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'CM_SKI'. [CLIENT: <local machine>]

    -BH

    Sunday, February 28, 2016 2:07 AM
  • Hi

    For your SCCM DB move . did you follow this guide?? https://blogs.technet.microsoft.com/configurationmgr/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server/

    For the WSUS DB - has you verified that the correct security is set?

    Kind regards

    Per Larsen

    Twitter: @PerLarsen1975 | Blog: osddeployment.wordpress.com
    If this post is helpful please vote it as Helpful or click Mark for answer.

    Sunday, February 28, 2016 7:47 AM
  • Hi

    For your SCCM DB move . did you follow this guide?? https://blogs.technet.microsoft.com/configurationmgr/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server/

    For the WSUS DB - has you verified that the correct security is set?

    Kind regards

    Per Larsen

    Twitter: @PerLarsen1975 | Blog: osddeployment.wordpress.com
    If this post is helpful please vote it as Helpful or click Mark for answer.

    Yes, that's the exact guide I followed for the SCCM DB move. After the Site DB was moved, I was able to log into and open the SCCM console after both servers rebooted, I checked things out and all seemed good. I then proceeded to move the SUSDB and that's when I think things stopped working.

    I verified the security on the DB's were the same, even adding the machine account as some have suggested in other posts.

    -BH

    Sunday, February 28, 2016 6:02 PM