Instructions for installing SQL Server 2014

Before installing SQL Server, be sure to install the update package .NET Framework 2.0 and .NET Framework 3.5 Service Pack 1. After opening the link, the file "dotnetfx35setup" will automatically begin downloading. Run it to install the update.

To install SQL Server, go to the Microsoft website. Select the desired language for SQL Server, considering that it should match the language of your operating system. We recommend choosing the English version since, in this case, the operating system language does not matter.

After selecting the language, click the "Download" button. A list of installer options will open. Choose one of the installers according to your system's bit version. For 64-bit systems, select "ExpressAdv64BIT\SQLEXPRADV_x64_ENU.exe", and for 32-bit systems, select "ExpressAdv32BIT\SQLEXPRADV_x86_ENU.exe". Scroll down and start the download.

Run the installer file with administrator rights and confirm granting the program access to your computer. A window for selecting the folder to unpack temporary files will appear. Click "OK" to unpack all files into the current folder.

Creating a New SQL Server

After the installation process is complete, the SQL Server installation center window will open. Go to the "Installation" section and select "New SQL Server stand-alone installation" to create a new SQL Server instance.

Confirm acceptance of the Microsoft license agreement and continue with the installation.

Global Rules Check

A window will open to check the necessary conditions for installing SQL Server. If errors occur, they need to be resolved before continuing with the installation. After resolving all errors, click the "Re-run" button to re-check, or re-run the SQL Server installer. Below is a list that may help in passing problematic steps.

Check for updates for your operating system, which may include the necessary components you need.

• Setup administrator — Ensure that you are using an account with administrator rights to perform the SQL Server installation.

• Setup account privileges — Configure the privileges of the account that will be used for SQL Server. The account should have appropriate rights for reading and writing to the registry, creating directories, and accessing system resources.

• Restart computer — Restart your computer to apply all changes made after installing updates or configuring system settings.

• Windows Management Instrumentation (WMI) service — Ensure that the Windows Management Instrumentation (WMI) service is running. This can be checked through 'services.msc' or the command line with the command "net start winmgmt".

• Consistency validation for SQL Server registry keys — Perform a consistency check of SQL Server registry keys. In the SQL Server installation center, select the Maintenance tab > choose the Repair option to run the repair wizard.

• Long path names to files on SQL Server installation media — Ensure that there are no excessively long paths to files on the SQL Server installation media, which may cause errors during installation. Paths should be shorter than 260 characters.

• SQL Server Setup Product Incompatibility — Check the compatibility of the SQL Server product with the operating system on the Microsoft website in the "System Requirements" section.

• .NET 2.0 and .NET 3.5 Service Pack 1 update for Windows 2008 — Ensure that the update .NET Framework 2.0 and .NET Framework 3.5 Service Pack 1 is installed on your system.

• Edition WOW64 platform — Check if SQL Server is being installed on the WOW64 (Windows-on-Windows 64-bit) platform. This is important for compatibility and proper functioning of 32-bit applications on a 64-bit system.

Installing Additional Components

Select "Database Engine Services" and "Management Tools – Basic and Complete". Click "Next" to start the installation.

Setting SQL Server Instance Name and Services

Optionally, you can set a custom name for the SQL instance. To do this, select "Named instance" and enter the desired name in Latin letters twice, as shown in the image.

For the "Database Engine" and "Browser" services, set the startup type to "Automatic".

Configuring Authentication Mode and SQL Server Access

Set the authentication mode to "Mixed Mode" and set a password that will be used for the Torgsoft application owner (sa) user. Knowing the password for the "sa" user, you will be able to gain full access to the Torgsoft application or SQL Server instance from any server user.

If no user is specified in the "Specify SQL Server administrators" field, add your own by clicking the "Add Current User" button. You can also grant access to other users or groups of users through the "Add" button. Added users, even without the "sa" user password, will be able to gain full access to the SQL Server instance.

Clicking "Next" will start the process of creating a new SQL Server instance. Wait for the installation process to complete, which may take some time. After it completes, a list of results for installing the necessary components will be displayed. In case of an error, check the correctness of all previous steps. If necessary, you can always contact our technical support department.

At this stage, SQL Server is ready for use. To configure its operation in a local network, use the guide for configuring the Torgsoft application in a local network.