Installing SQL Server Management Studio

To manage the LoMag database outside the LoMag environment, it is essential to download and install Microsoft SQL Server Management Studio. Download the software by clicking here. Select your preferred language and click "Dowonload" option.

After pressing the "Download" button, the website will show you the list of proposed files. Choose either 'ENU\x86\SQLEXPR_x86_ENU.exe' or 'ENU\x86\SQLEXPR32_x86_ENU.exe' file depending on system's requirement. In our case, we have downloaded the ENU\x86\SQLEXPR_x86_ENU.exe file.

The right side of windows shows the total size and selected file.

After downloading the "SQLManagementStudio_x86_ENU.exe" file, double-click it to start the installation. The installation of the installer will begin (this may take few minutes).

After starting the installer, start the installation process by clicking on "New SQL server stand-alone installation or add features to an existing installation" option.

In the first step, the update for SQL Server will be checked. If an update is detected, it will be installed, then click "Next". In the absence of a new SQL Server update, we also go further by clicking "Next".

Before starting the installation, read and accept the terms of the software license and click the next button.

In the next step, we choose the preferred type of SQL server instance. In this step, we select "Add features to an existing instance of SQL Server 2012", and the name of the "SQLEXPRESS" instance. Click the "Next" option.

In the next window, click the "Select all" button to select the installation of all the features of SQL Server 2012.

The next window will display information about error reporting, you can skip this step by clicking "Next" button.

Finally the installation process starts. It takes few minutes to complete the installation procedure.

After the successful installation. The software will inform about its statuses. Finish the installation process through the "Close" button.

After this we have to maintain a connection between software and server. And we have already discussed in our previous manual the required steps for establishing the connection between LoMag software and Microsoft SQL Server Studio.