SQL Installation

Download SQL Server Express 2017

Click Here To Download

Select Custom installation and provide a Password for SQL(Default username is sa) as below.

To enable Server Network protocol

Click here  Refer more.

In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration. In the console pane, click Protocols for instance name

In the details pane, right-click TCP/IP to change, and then click Enable or Disable.

In the console pane, click SQL Server Services.

Select SQL server Browser-> Services-> Change start mode to automatic

After Starting SQL server browser by right clicking. In the details pane, right-click SQL Server (instance name), and then click Restart, to stop and restart the SQL Server service.

Go to Control panel -> Windows firewall-> Advanced settings-> Inbound rules -> New rule

Click here  Refer more.

Select Port -> Next

Provide Specific remote port as 1433

Click allow the connection -> Next -> Provide a name

Inbound rule is now created

Create an Outbound rule in the similar way

Click here Refer more

The SQLEXPRESS is now able to connect via LAN

Steps for connecting VMS from non-SQL PC to SQL Installed PC

Step 1: Create database in VMS on SQL installed PC

Open VMS->settings->general settings-> database settings -> Create database

After creating database, in Activate database click on Connection Test and Activate

Database is now created as vmsdbv2 on SQL Installed PC

Step 2 : Pinging from non-SQL PC to SQL installed PC

For Obtaining hostname of SQL installed PC

Open command prompt -> type 'hostname' then Enter

Click here Refer more

Open command prompt on non-SQL PC-> type 'ping hostname' and Enter

If pinging is working, Both PCs are connected.

If the step 2 fails (i.e., pinging failed from Non-SQL PC to SQL installed PC)

  • Make sure that both PCs are connected to a single LAN network.
  • Disable firewall blockings if enabled.
  • Check whether the network connections are up in SQL installed PC
Step 3 : Configuring Database of non-SQL PC to SQL installed PC

Open VMS->settings->general settings-> database settings

Provide server name as ‘hostname\SQLEXPRESS’

Select ‘SQL authentication’

Username and password

(Default username is ‘sa’)

After the Database name appears as 'vmsdbv2' click on 'connect test and activate'

Both devices VMS are now connected to one database of SQL installed PC.

If the Step 3 fails (i.e., unable to configure database from non-SQL PC)

  • Try giving IP address of SQL installed PC as server name instead of HOSTNAME\SQLEXPRESS.
  • Change the Server name in SQL installed PC as HOSTNAME\SQLEXPRESS instead of .\SQLEXPRESS.