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

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


Solution:

Please follow the steps below to install the Microsoft SQL Server 2008 R2 Express with KDK Instance for TDS application:
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.