| Unable to install SQL Server Express "failed to install new SQL instance" (Manual Reinstall) |
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
- 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.
- In File Explorer, browse to the C:\Sage100Con\Downloads folder.
- In this folder right click on SQLEXPRADV_x64_ENU.exe and select Run as administrator. Click OK
- When the install window comes up, 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 2014 ***(see the below screenshot, if using SQL Server 2019)***. Click Next
- Check 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 (should populate with the name). Click Next
- 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 < >
- Type the word system 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 does not, then follow the steps below. It if does, skip to Step 13.
- 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 very similar - be sure to choose the correct one).
- Click OK
- Click Next
- 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.
- 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 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]
|
|