Unable to install SQL Server Express "failed to install new SQL instance" (Manual Reinstall)
Description
Cause

The Server Database Engine lists an account that does not have the permissions needed for the install to complete successfully.

Resolution
[BCB:2:Database warning:ECB]
[BCB:3:Network warning:ECB]


Manually reinstall using the System account

  1. Before using this article, ensure you have ruled out the .Net framework.  Ensure the .NET Framework 3.5 and 4.8 items are enabled.  Also, ensure sure a local computer administrator login account and not an MSN account or passport account is utilized.
  2. In File Explorer, browse to the C:\Sage100Con\Downloads folder.
  3. In this folder right click on SQLEXPRADV_x64_ENU.exe and select Run as administrator. Click OK
  4. When the install window comes up, click New SQL Server stand-alone installation.....
  5. When the pre-checker is finished, click Next
  6. Choose the option Perform a new installation of SQL Server 2014 ***(see the below screenshot, if using SQL Server 2019)***. Click Next
  7. Check the box to accept license terms and click Next
  8. Click Select All then click Next
  9. Choose the option for Name instance. Type SAGE100CON in the field, then click in the Instance ID: field (should populate with the name). Click Next
  10. On the Server Configuration page, on the line that reads SQL Server Database Engine click the dropdown arrow in the Account Name box, then select < >
  11. Type the word system and click OK.
  12. Click the Collation tab (next to the Service Accounts tab).
  13. The collation should read exactly SQL_Latin1_General_CP1_CI_AS. If it does not, then follow the steps below. It if does, skip to Step 13.
    1. Click the Customize button
    2. From the SQL collation dropdown selection window in the middle, scroll down and select SQL_Latin1_General_CP1_CI_AS (the selections look very similar - be sure to choose the correct one).
    3. Click OK
  14. Click Next
  15. On the next screen, select Mixed Mode. Type in an 'sa' password (must begin with a letter and be at least 6 characters). This will be the 'sa' (SQL administrator) password.
  16. Click Add Current User
  17. Click Next, then Next again.
  18. Continue through the rest of the installation (this will take several minutes)
  19. When the installation is complete, click Close, then close the installation window
  20. Test connecting to the new SAGE100CON SQL Server instance in Database Administration

Note - If using SQL Server 2019 or later you may be prompted for these options, be sure to UN-check the highlighted options below. They are not needed with our product. Use all other default selections throughout the installation with this exception.***


[BCB:154:Chat 100 Contractor US:ECB]








Steps to duplicate
Related Solutions

Upgrade SQL Server Express using Database Administration for Sage 100 Contractor