MSSQL Installation Process

How to install Microsoft SQL Server 2008 R2 Express Edition with KDK instance for TDS / eXBace (On - Premise) application

Please follow the steps below to install the Microsoft SQL Server 2008 R2 Express with KDK Instance for TDS application:
Open website  :   MSSQL LINK
If it is 64-bit then download "SQLEXPR_x64_ENU.exe" or if it is 32-bit      download "SQLEXPR_x86_ENU.exe". (To check system configuration, right click on My Computer --> Properties)
Double click on the downloaded exe file.

Step 1:      Click on “New installation or add features to an existing installation”. 

            

Step 2:      Click on “I accept the license terms” and Next.

            

Step 3:      Click on “Select All” and Next.

            

Step 4:      Click on “Select All” and Next.
Step 5:      In Named Instance “KDKSQL8” and Next.

            

Step 6:      Changed Startup Type Disabled to Automatic and then click on Next.

            

Step 7:
  1. Click on Mixed Mode (SQL Server authentication and Windows authentication)
  2. Enter Password and Confirm password is: kdk@123456
  3. In specify SQL Server administrators click on Add Button Type Everyone here and click on Next Button.
            

Step 8:      After then click on Next and then again click on Next Button.
Step 9:      At the end click on Close Button.

This will install the Microsoft SQL Server 2008 R2 Express with kdk instance on your system you can check the same in system Start --> All Programs.