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:
- Click on Mixed Mode (SQL Server authentication and Windows
authentication)
- Enter Password and Confirm password is: kdk@123456
- 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.