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.

    • Related Articles

    • eXBace Installation process

      eXBace - XBRL Solutions, significantly improves the efficiency and effectiveness of the business reporting processes of an organization. eXBace ( XBRL Solutions ) is a solution for converting and filing Financial Information of the Company in XBRL ...

    • SQL SERVER || "Could not find the Database Engine startup handle" error while installing SQL Server 2008 R2 SP2 Express Edition

      To rectify the error, follow these steps: Begin by securely backing up the data from the TDS Software to ensure no loss of crucial information. Completely uninstall Microsoft SQL Server, including all its instances and related files. After ...

    • How to configure eXBace (On Premise/Desktop) Software

      Please Follow the steps below: Step 1: Install eXBace Setup - https://www.kdksoftware.com/Downloads/Spectrum/eXbaceWeb.exe file. ( Process - eXBace Installation Process ) Install MICROSOFT SQL SERVER 2008 R2 SP2 express edition file. (Process - MSSQL ...

    • SQL SERVER || Attempted to perform an unauthorized operation

      Error While Installing SQL SERVER 2008 R2 SP2 Express Edition: - "Attempted to perform an unauthorized operation". Resolution To resolve this problem, use following method : If you're running 64-bit Windows 10, version 20H2 (19042.xxx), you must ...

    • SQL SERVER || Fusion Active Template Library (ATL)

      Error While Installing SQL SERVER 2008 R2 SP2 Express Edition – Fusion Active Template Library (ATL) Resolution : Solution 1: To resolve this problem, use the following methods: Disable Antivirus and Firewall as well until SQL Server Installation. In ...