SQL Server Installation Has Failed or Been Cancelled - Unable to Automatically Install SQL

This message will occur when Microsoft SQL Server cannot install successfully due to one of the following reasons:

• A restart may be required for system changes to apply.
• WMI (Windows Management Instrumentation) corruption.
• Enabled UAC (User Account Control) and/or anti-virus software.
• User account may not have Administrator privileges.
• Computer name and user name are the same.
• Multiple Administrator accounts are logged in.
• Insufficient permissions set on Greatland Corporation and Microsoft SQL Server folders.

Restart Computer

1. Restart the computer to apply any system changes that may have been made by Microsoft SQL Server.
2. Run the Yearli installation.

Verify WMI Is Functioning

1. Access the Windows Run window by pressing the Windows key and the R key on your keyboard.
2. Type "msinfo32" without the quotes in the Open field.
3. Click OK.
4. If the System Information screen displays, go to the next section.
5. If the following error displays, "Cannot access the Windows Management Instrumentation software.  Windows Management files may be moved or missing.", this would suggest that there is corruption with the WMI. This error will need to be resolved by an IT technician before the software can be successfully installed.

Disable UAC and Anti-Virus Software

1. Disable the User Account Control (UAC).
   • To disable UAC:
     1. Access the Windows Run window by pressing the Windows key and the R key on the keyboard.
     2. Type "useraccountcontrolsettings" without the quotes in the Open field.
     3. Click OK.
     4. Drag the slider to the Never Notify option.
     5. Click OK.
2. Restart the computer.
3. Disable the anti-virus software.
4. Run the Yearli installation.

Check Account Privileges

Local Administrator privileges are required when running or installing the Yearli software.

1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
2. Type "compmgmt.msc" without the quotes in the Open field.
3. Click OK.
4. In the Computer Management screen, expand Local Users and Groups.
5. Click on Groups.
6. In the list on the right double click on Administrators.
7. Verify that the active user account is listed in the Members section.

Verify the Computer Name and the User Name Are Different

Changing the computer name and/or user name could affect how network resources work.

1. Access the Windows Run window by pressing the Windows key and the R key on your keyboard at the same time.
2. Type "msinfo32" without the quotes in the Open field.
3. Click OK.
4. On the System Information screen, verify that the System Name (computer name) and User name are different.
5. If they are different skip to the next section. If they are the same, it will be required to change one of the names.
   • To change the computer name:
     1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
     2. Type "sysdm.cpl" without the quotes in the Open field.
     3. Click OK.
     4. Click Change.
     5. Change the value in the Computer name field.
     6. Click OK.
     7. Restart the machine to apply the change.
   • To change the user name:
     1. Go to the Start menu.
     2. Click on Control Panel.
     3. Select User Accounts.
     4. Select Change your account name.
     5. Make the necessary changes and click Change Name.
     6. Log off the current user account and then log back in for changes to take effect.
     7. Press the Windows key on the keyboard.
     8. Type "users" without the quotes.
     9. Select User Accounts.
     10. Select Change your account name.
     11. Make the necessary changes and click Change Name.
     12. Log off the current user account and then log back in for changes to take effect.
     13. Select User Accounts.
     14. Select Change your account name.
     15. Make the necessary changes and click Change Name.
     16. Log off the current user account and then log back in for changes to take effect.
6. Run the Yearli installation.

Verify Only One Administrator Is Logged In

1. Right click on the Taskbar at the bottom of the screen.
2. Click Start Task Manager or Task Manager.
3. If Windows 10 or 11, click More details. If not, proceed to the next step.
4. Click on the Users tab.
5. Verify that only one Administrator account is logged in.
6. Log off any additional Administrator accounts, if needed.

Adjust Permissions on Greatland Corporation and Microsoft SQL Server Folders

Adjust Permissions for the Greatland Corporation Folder

1. Navigate to C:\Program Files or Program Files (x86).
2. Right-click on the Greatland Corporation folder and select Properties.
3. Click on the Security tab.
4. Click on Edit to change permissions.
5. Click Add.
6. Type "network service" without the quotes and click Check Names.
7. Click OK.
8. Click Add.
9. Enter the user name for the account currently logged in and click Check Names.
10. Click OK.
11. Adjust the following Groups and Users permissions as identified:
    • Administrator (User) - Full Control.
    • Administrators (Group) - Full Control.
    • Users (Group) - Modify.
    • Network Service (Group) - Modify.
    • User name logged in - Modify.
12. Click Apply to save changes.
13. Close the Permissions and Properties windows.

Adjust Permissions for the Microsoft SQL Server Folder

1. Navigate to C:\Program Files or Program Files (x86).
2. Right-click on the Microsoft SQL Server folder and select Properties.
3. Click on the Security tab.
4. Click on Edit to change permissions.
5. Click Add.
6. Type "network service" without the quotes and click Check Names.
7. Click OK.
8. Click Add.
9. Enter the user name for the account currently logged in and click Check Names.
10. Click OK.
11. Adjust the following Groups and Users permissions as identified:
    • Administrator (User) - Full Control.
    • Administrators (Group) - Full Control.
    • Users (Group) - Modify.
    • Network Service (Group) - Modify.
    • User name logged in - Modify.
12. Click Apply to save changes.
13. Close the Permissions and Properties windows.

Once both sets of permissions have been changed, run the installer again.