locked
Site Migration/Recovery to new hardware RRS feed

  • Question

  • I'm trying to move my site to a new server. The old machine is shut down, I renamed the new server to the old server name and gave it the same ip. I installed SCCM 2012 r2 and chose to recover site from backup and that all goes fine until it tries to reconnect to the SQL server which resides on a separate machine. It connects fine, but I get the following error: 

    INFO: Resetting the installed hotfixes status on local SQL server xxx.xxxx.xxxx.  $$<Configuration Manager Setup><07-22-2015 12:38:20.768+300><thread=4796 (0x12BC)>
    INFO: Reset the installed hotfixes status on xxx.xxxx.xxx.  $$<Configuration Manager Setup><07-22-2015 12:38:20.799+300><thread=4796 (0x12BC)>
    INFO: Registered type SMS_ACCESS for xxx.xxx.xxx CM_HH0  $$<Configuration Manager Setup><07-22-2015 12:38:20.799+300><thread=4796 (0x12BC)>
    INFO: SQL Connection succeeded. Connection: SMS_ACCESS, Type: Secure  $$<Configuration Manager Setup><07-22-2015 12:38:20.815+300><thread=4796 (0x12BC)>
    INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure  $$<Configuration Manager Setup><07-22-2015 12:38:21.018+300><thread=4796 (0x12BC)>
    *** if not exists (select * from AccountActionType where ActionID = 1) insert into AccountActionType(ActionID, Action) values (1, 'SyncProfiles')  $$<Configuration Manager Setup><07-22-2015 12:38:21.034+300><thread=4796 (0x12BC)>
    *** [42S02][208][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'AccountActionType'.  $$<Configuration Manager Setup><07-22-2015 12:38:21.034+300><thread=4796 (0x12BC)>
    ERROR: SQL Server error: [42S02][208][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'AccountActionType'.  $$<Configuration Manager Setup><07-22-2015 12:38:21.049+300><thread=4796 (0x12BC)>
    INFO: Executing SQL Server command: <if not exists (select * from AccountActionType where ActionID = 1) insert into AccountActionType(ActionID, Action) values (1, 'SyncProfiles')>  $$<Configuration Manager Setup><07-22-2015 12:38:21.065+300><thread=4796 (0x12BC)>
    ERROR: Failed to execute query: if not exists (select * from AccountActionType where ActionID = 1) insert into AccountActionType(ActionID, Action) values (1, 'SyncProfiles')  $$<Configuration Manager Setup><07-22-2015 12:38:21.065+300><thread=4796 (0x12BC)>

    The SCCM server is a local admin on the SQL server as is the user account used to install SCCM 2012 r2. 

    Any suggestions would be greatly appreciated. 


    • Edited by nella1974 Wednesday, July 22, 2015 7:16 PM removed FQDN
    Wednesday, July 22, 2015 6:10 PM

All replies

  • Hello,

    Did you backup your database via SQL backup?

    Have you tried to retore site database?


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, July 27, 2015 5:04 AM
  • I have the same problem - did you find a solution?
    Wednesday, January 6, 2016 10:23 AM
  • What about the user account that you're doing the restore with? Is that sysadmin in SQL?

    Have you attempted the last option on this page:

    https://stevethompsonmvp.wordpress.com/2014/02/24/configmgr-2012-site-backup-and-recovery-overview/


    Nickolaj Andersen | www.scconfigmgr.com | @NickolajA

    Wednesday, January 6, 2016 11:33 AM
  • I have the same problem - did you find a solution?
    Can you please answer both Daniel and Nickolaj questions.  Without those answer it is hard for anyone to help you.

    Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

    Wednesday, January 6, 2016 2:35 PM
  • I think the problem is caused by using different build from your old SCCM server. I had the same error and went through by using the same build installer.
    • Proposed as answer by George Micro Thursday, July 7, 2016 2:15 PM
    • Unproposed as answer by George Micro Friday, September 30, 2016 1:08 PM
    Thursday, July 7, 2016 2:15 PM