| 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.
- Make sure you're logged in with a local admin account, 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.
- Choose 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.
- When prompted, deselect the items outlined in red as they're not required for Sage 100 Contractor.
 - Choose the option for Name instance.
- Type SAGE100CON in the field and click in the Instance ID: field.
NOTE: The name of the SQL instance will populate the field. - Click Next.
- Click the picklist arrow in the Account Name box on the Server Configuration, SQL Server Database Engine line.
- Click the < > symbol.
- 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.
- Click the Customize button.
- Select SQL_Latin1_General_CP1_CI_AS from the SQL collation picklist.
- Click OK.
- Click Next.
- On the next screen, select Mixed Mode.
- Enter the "sa" or SQL Administrator password.
NOTE: This password must be at least eight characters long and begin with a letter, include a number, and a special character. - 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 and close the installation window.
- Open and log in to Database Administration for Sage 100 Contractor.
[BCB:154:Chat 100 Contractor US:ECB] |
|