Why install SQL manually?
Installation of SQL Server usually happens when you are setting up Webgility Desktop for the very time or migrating your Webgility Desktop to a new machine. In most of the cases Webgility Desktop Software is able to instal the SQL Server by itself but there are some scenarios permissions on the machine, third party security, etc which might disrupt the installation of the SQL Server. So this article with guide you on how to download and install the latest version of the SQL Server 2022
Note: You will need to verify the system requirements before starting the installation process. Follow the steps in this helpful article on System Requirements for SQL Server 2022
Steps to Install the SQL Server
1). Download the SQL Server 2022 Express Edition installer directly from Microsoft here,
2). Run the setup file, it will ask you to select the installation type, select “Custom” then click on “Install” The setup will download the required files.
3). Once the download is completed, it will launch the setup wizard for “SQL Server Installation Center” so you need to select “New SQL Server Stand-alone installation or add features to an existing installation” on the first step accept the License Terms, click on next, skip the Microsoft update option and click on next.
4). In the next step of installation, Install Rules some users might see a Firewall Warning when SQL runs the Configuration Report. In order to fix it, navigate to Control Panel go to System and Security click on Windows Defender Firewall and Turn Windows Defender Firewall On or Off, turn off Firewall for all the Network Settings.
5). On the next step Uncheck Azure Extension for SQL Server then click on next. Under Feature Selection, select only: Database Engine Services, SQL Server Replication & Local DB and click on next.
6). In the next step we need to change the Named Instance to Unify, press TAB on the keyboard which will automatically change the Instance ID name and click on Next.
Note: If you’re updating the SQL version to 2022 then you can use Unify New as an Instance name.
7). In Server Configuration step, make sure the startup type is Automatic for SQL Server Database Engine & Browser then click on Next. Select Mixed Mode Authentication and Authentication with the username "sa" and the password “Webgility2011” then click Next.
8). Once the installation is finished, the setup wizard will give a Succeeded prompt, click on okay and close the SQL Installation Centre.
If the problem persists, contact Webgility Support for further assistance.