STEP 1:   Download the  Microsoft SQL Express 2014 server

 

 

STEP 2:  Install it on the  server-computer on which KAPA Server will be installed , following the instructions below:

 

a) On the initial below window, click on "New installation or add features to an existing installation "

 

Be careful not to select the second option ( Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008)

as you might accidentally upgrade an existing SQL server and cause other already installed applications not to work

 

 


   

1.jpg

   





 

   
    b) Select the " I accept the licence terms" checkbox and click Next


 

2.jpg




- Click Next


3.jpg



- Click Next


4.jpg


 

 

 

  

 c) Do not make any changes to the Features options and just click Next


 

5.jpg


 

 

 

 

d)  In the Instance Configuration dialog , select "Named Instance" and type "Kapa32Server". Then click Next.

 

 

7.jpg






e)  In the Server Configuration Dialog, change the account name for SQL Server Database Engine . Type      “NT AUTHORITY\SYSTEM” and click Next.

 

8.jpg



       


f) In the Database Engine Configuration dialog, select " Mixed Mode ( SQL Server authentication and  Windows authentication) " option and enter password " kapa32 " . Click Next to continue.

 

 

9.jpg


 



g)  Installation will begin

 

10.jpg




h) Finally, you will get a completion confirmation window for the SQL Server setup, just click Close to exit the  setup and finish.

 

 

 

11.jpg






STEP 3:  Next, please follow the instructions below  to configure the SQL EXPRESS 2014 Server in order to  install the KAPA server on it.



a)  Go to Start -> Programs -> Microsoft SQL Server 2014 -> Configuration Tools -> SQL Server  Configuration Manager   and run it

 

 

blob1477922319178.png


 

b) Once open , click on SQL Server Services and confirm that the states of  "SQL Server (KAPA32SERVER) " and "SQL Server Browser" is  " Running "

 

 


blob1476361059841.png

 



c)  Go to SQL Server Network Configuration -> Protocols for KAPA32SERVER. You will find : "Named Pipes" and "TCP/IP" protocols disabled. You need to enable them.

 

   

 

 blob1476361675569.png

 

 

 

 

    - Right click on them and select " Enable". You should see their Status turn to "Enabled"

 

  

 

blob1476362023615.png


blob1476362216639.png

  

 

d) Now you need to configure the  TCP\IP protocol. Double Click on it to open it's configuration window and go to IP Addresses tab.



 blob1476363203376.png

 

- On "IP1" and "IPAll" options, you must make sure that the "TCP Dynamic Ports" filed is blank ( delete the zero) and on their TCP Port field , type " 1433" . Then click " Apply"   



 blob1476363360073.png

 

 

  - Click OK on the prompt window that will appear

 

blob1476363585458.png 

 

   e) Go to SQL Server Services and on the right side of the screen, right click on "SQL Server (KAPA32SERVER) " and "SQL Server Browser" and click on restart, one at a time.


blob1477922618206.png


 

- When both Services have been restarted, you can close the SQL Server Configuration Manager as the  configuration for KAPA setup is complete.