Sage 100

 View Only

  • 1.  Error 0x80040e14 during Premium migration... KB 76993 doesn't have the easy answer listed.

    Posted 12-03-2021 16:43

    FYI.  From an upgrade last month... posting here in case it helps someone else.

     "Error Number : 0x80040e14 Description: Cannot open backup device E:\Program Files\Microsoft SQL Server\.....\MAS_SYSTEM.bak. Operating system error 2(The system cannot find the file specified). Setup will now terminate."

     Scenario:

    • Server 1 has source Sage (2018 Premium) and source SQL.
    • Server 1 is also new Sage (2021 Premium) server.
    • Server 2 is new SQL server.
    • Plenty of disk space on both servers.

     SQL service (source and destination) is running using a domain login SageAdmin account, which is a local admin to both servers.

    I can backup from SSMS on source system authenticated using "sa" account, directly to the \\server2\e$\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MAS_SYSTEM.bak file, no errors, so I know the service account permissions are correct, but the migration's copy / restore fails. 

    The backup does not get copied by the migration program for some reason.  (Not even Run As Admin helps).  Very odd.

     Easy fix… do the backups manually (from source SQL to destination system's DATA folder) before starting the migration.

     When done be sure to clean up the manually created .bak files in the destination data folder… the migration tool does not.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------


  • 2.  RE: Error 0x80040e14 during Premium migration... KB 76993 doesn't have the easy answer listed.

    Posted 12-07-2023 21:55

    @Kevin Moyes I'm getting this same error but it displaying a operating system error 5 instead 2 like the one you have listed above. SQL is installed on the E drive (E:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL2016\MSSQL\Data) instead of the C drive where the migration is looking for it. How do I get around this?



    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    ------------------------------



  • 3.  RE: Error 0x80040e14 during Premium migration... KB 76993 doesn't have the easy answer listed.

    Posted 12-08-2023 09:42

    To resolve an error 5, I determine which user account is running the SQL Server instance under Windows Services (services.msc) and then give that user account explicit NTFS permissions to your E: drive location.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 4.  RE: Error 0x80040e14 during Premium migration... KB 76993 doesn't have the easy answer listed.

    Posted 12-08-2023 13:20

    Thank you @Steve Iwanowski. I will follow up with their IT group.



    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    ------------------------------

    Original Message


  • 5.  RE: Error 0x80040e14 during Premium migration... KB 76993 doesn't have the easy answer listed.

    Posted 12-08-2023 14:56

    My usual setup has both the source and destination SQL instances running with domain logins, where those domain logins have local admin permissions to the servers.  Local service accounts cannot access C$/D$/E$ admin shares, which are used by the migration program.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content