| Error: "Unable to install failed to install new SQL instance" (Manual Reinstall) |
Cause | The login account to install the SQL Server Database Engine doesn't have the necessary permissions to complete the installation. |
Resolution | Manually reinstall SQL Server 2019 using the System account - Verify that the Microsoft .NET Framework 3.5 and 4.8 items are installed and enabled on the machine.
- Verify you're logged in to the machine with a Windows local computer administrator account and not an MSN or passport account.
- Open Windows File Explorer.
- Browse to the C:\Sage100Con\Downloads folder.
- In this folder, right-click on SQLEXPRADV_x64_ENU.exe. Select Run as administrator. Click OK.
- When the installation window appears, click New SQL Server stand-alone installation.
- When the pre-checker is finished, click Next.
- Choose the option "Perform a new installation of SQL Server 2019." Click Next.
- Select the box to accept license terms and click Next.
- Click Select All then click Next.
- Choose the option for Name instance. Type SAGE100CON in the field then click in the Instance ID: field (This populates the name of the SQL instance). Click Next.
- On the Server Configuration page line that reads SQL Server Database Engine click the dropdown arrow in the Account Name box, then select < >.
- Type the word "System" (without the quotes) and click OK.
- Click the Collation tab, next to the Service Accounts tab.
- The collation should read exactly SQL_Latin1_General_CP1_CI_AS. If it doesn't, then follow the steps below. If it does, skip to Step 18.
- Click the Customize button.
- From the SQL collation dropdown selection window in the middle, scroll down and select SQL_Latin1_General_CP1_CI_AS (the selections look similar. Be sure to choose the correct one).
- Click OK.
- Click Next.
- On the next screen, select Mixed Mode. Type in a "sa" (SQL Administrator) password. This password must be at least eight characters long begin with a letter and include a number and a special character. This password will be the '"sa"' or "SQL Administrator" password for Database Administration for Sage 100 Contractor password.
- Click Add Current User.
- Click Next, then Next again.
- Continue through the rest of the installation (this will take several minutes).
- When the installation is complete, click Close, then close the installation window.
- Test connecting to the new SAGE100CON SQL Server instance by opening and logging into Database Administration for Sage 100 Contractor.
NOTE: When prompted, deselect the items outlined in red as they're not required for Sage 100 Contractor. Use all other default selections throughout the installation.  [BCB:154:Chat 100 Contractor US:ECB] |
|