Creating second SQL Server database instance

After completing setup work for the migration process, create a second SQL Server database instance to store the Sage 100 company data from the source server. This allows all data to reside on the new Sage Partner Cloud SQL Server and eliminates the need for access to the source server.

To create a second SQL Server database instance

  1. In File Explorer, browse to C:\SQLServerFull.
  2. Double-click setup.exe to start the SQL Server Installation Center.
  3. In the SQL Server Installation Center, click Installation on the left side of the screen.
  4. At the top of the screen, click New SQL Server standalone installation or add features to existing installation.
  5. In the SQL Server 2022 Setup window, at the Product Update screen, install the SQL Server updates if necessary and click Next.
  6. At the Install Rules screen, click Next.
  7. At the Installation Type screen, select the Perform a new installation of SQL Server 2022 option and click Next.
  8. At the Edition screen, select the edition to install. If you’re entering a product key, select the applicable SQL Server license check box. Click Next.
  9. At the License Terms screen, select the I accept the license terms and Privacy Statement check box, and click Next.
  10. At the Feature Selection screen:
    1. Select the Database Engine Services check box.
    2. At the Instance root directory field, click the ellipsis (…) button and browse to data drive E:\SourceDB in the Browse for Folder window and click OK.
    3. Click Next.
  11. At the Instance Configuration screen:
    1. At the Named instance field, enter SourceDB.
    2. The Instance ID field defaults to SourceDB and data drive E:\SourceDB is populated. Click Next.
  12. At the Server Configuration screen, click Next.
  13. At the Database Engine Configuration screen:
    1. In the Authentication Mode section, select the Mixed Mode (SQL Server authentication and Windows authentication) option.
    2. Enter a password for the SQL Server system administrator (sa) account and confirm the password.

      Note: We recommend using the same password as the Sage Partner Cloud SQL Server password. Take note of the password because you will enter it when running the Parallel Migration Wizard.

    3. At the Specify SQL Server administrators section, click Add Current User.
    4. Click Next.
  14. At the Ready to Install screen, review your selections and then click Install. The installation process can take over 5 minutes.
  15. The Complete screen notifies you of the successful installation. Click Close to exit the SQL Server Installation Center.

After completing the steps above, see Extracting backup ZIP files from the source server.