How to Manually Install SQL 2019 for Webgility Desktop
Why install SQL manually?
If Webgility has encountered an issue installing the SQL server automatically, the SQL server must be installed manually.
System Requirements for SQL Server 2019 (click here)
Steps to Install the SQL Server
1). Download the SQL Server 2019 express edition installer directly from Microsoft, here.
2). Run the installer file, it will ask you to select the installation type so select “Custom” and then click on “Install”. This will start the download of the setup for SQL Server 2019. The download will take about 3-4 minutes depending on your internet connection speed.
3). Once the download is complete it will launch the wizard for “SQL Server Installation Center” so you need to select “New SQL Server Stand-alone installation or add features to an existing installation”.
4). Then it will ask you to accept the terms. Check the box for “I accept the license terms and privacy statement” and click on Next. Then click on Next again so it will start checking for the updates. Once it is done you can click on Next again and it will run another scan and verify the install rules then click on Next again.
5). You should now see the Feature Selection window, make sure to uncheck the boxes for “Machine learning Services” as well as “language & Full Text Semantix Extractions” and then click on Next so it will direct you to the Instance Configuration window.
6). Once you are on the Instance Configuration window you can name the database instance by updating the Named Instance field with “WEBGILITY” (the instance ID field will auto-populate with the same name). Once done click on Next.
7). Now you will see the Server Configuration window. You will need to select “Automatic” for the SQL Server Browser under the “Startup Type” column and then select Next.
8). Next you will see the “Database Engine Configuration” window, now you will need to select “Mixed Mode” and as soon as you are done it will show you two fields to update a password. So make sure to update “Webgility2011” in both fields and then click on Next.
9). Now you will see the final installation stage which should take around 5-10 minutes. Once done it will return with a message “Succeeded” for all the feature components of the SQL Server 2019. Now you may click on Close and then Close the background window for the SQL Server Installation Center.