# Inštalácia aplikácie iKelp Jedáleň SQL s lokálnou databázou

1. Stiahnite a nainštalujte aktuálnu verziu aplikácie iKelp Jedáleň:
    - Z webovej stránky [Stiahnuť iKelp Jedáleň 2.6.x](https://www.ikelp.com/jedalen/aktualizacie-jedalen?epid=293).
2. Nainštalujte NativeClient podľa verzie OS Windows. Inštalačný balíček je možné prevziať tu:
    - https://www.microsoft.com/en-us/download/details.aspx?id=50402

[![01-install-sql-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/01-install-sql-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/01-install-sql-local-DB.JPG "01-install-sql-local-DB.JPG")

[![02-install-sql-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/02-install-sql-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/02-install-sql-local-DB.JPG "02-install-sql-local-DB.JPG")

[![03-install-sql-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/03-install-sql-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/03-install-sql-local-DB.JPG "03-install-sql-local-DB.JPG")

[![04-install-sql-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/04-install-sql-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/04-install-sql-local-DB.JPG "04-install-sql-local-DB.JPG")

[![05-install-sql-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/05-install-sql-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/05-install-sql-local-DB.JPG "05-install-sql-local-DB.JPG")

[![06-install-sql-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/06-install-sql-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/06-install-sql-local-DB.JPG "06-install-sql-local-DB.JPG")

3. Nainštalujte SQL Local DB podľa verzie OS Windows.

    - Stiahnite si inštalačný balíček [TU](https://download.microsoft.com/download/E/F/2/EF23C21D-7860-4F05-88CE-39AA114B014B/SqlLocalDB.msi).

[![01-Install-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/01-Install-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/01-Install-local-DB.JPG "01-Install-local-DB.JPG")

[![02-Install-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/02-Install-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/02-Install-local-DB.JPG "02-Install-local-DB.JPG")

[![03-Install-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/03-Install-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/03-Install-local-DB.JPG "03-Install-local-DB.JPG")

[![04-Install-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/04-Install-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/04-Install-local-DB.JPG "04-Install-local-DB.JPG")

4. Spustenie aplikácie iKelp Jedáleň s parametrom pre nastavenia spojenia na DB Server:

    1. Kliknite pravým tlačidlom na ikonu aplikácie na pracovnej ploche.
    2. Z ponuky vyberte možnosť Vlastnosti.
    3. V poli Cieľ, doplňte parameter /setup ("C:\Program Files (x86)\iKelp\Jedalen\jedalen.exe" /setup).
    4. Kliknite na tlačidlo Použiť a OK.

[![01-nastavenie-spojenia-na-databazu.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/01-nastavenie-spojenia-na-databazu.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/01-nastavenie-spojenia-na-databazu.JPG "01-nastavenie-spojenia-na-databazu.JPG")

[![02-nastavenie-spojenia-na-databazu.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/02-nastavenie-spojenia-na-databazu.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/02-nastavenie-spojenia-na-databazu.JPG "02-nastavenie-spojenia-na-databazu.JPG")

5. Nastavenie spojenia na DB Server:

    1. Spustite aplikáciu iKelp Jedáleň.
    2. Kliknite na záložku Databázy.
    3. Kliknite na tlačidlo Pridať.
    4. V poli Data provider vyberte možnosť: SQL LocalDB
    5. Kliknite na tlačidlo Vytvoriť.
    6. Tlačidlom OK potvrďte vytvorenie novej databázy.
    7. Kliknite na tlačidlo Uložiť.

[![01-create-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/01-create-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/01-create-local-DB.JPG "01-create-local-DB.JPG")

[![02-create-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/02-create-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/02-create-local-DB.JPG "02-create-local-DB.JPG")

[![03-create-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/03-create-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/03-create-local-DB.JPG "03-create-local-DB.JPG")

[![04-create-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/04-create-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/04-create-local-DB.JPG "04-create-local-DB.JPG")

[![05-create-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/05-create-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/05-create-local-DB.JPG "05-create-local-DB.JPG")

[![06-create-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/06-create-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/06-create-local-DB.JPG "06-create-local-DB.JPG")

[![07-create-local-DB.JPG](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/07-create-local-DB.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/07-create-local-DB.JPG "07-create-local-DB.JPG")

6. Vymažte parameter /setup z ikony pre spustenie aplikácie.

7. Spustite aplikáciu iKelp Jedáleň, pre prihlásenie použite prihlasovacie meno a heslo "admin".

###### Súvisiace návody

- [Migrácia (prechod) z verzie 2.4.xx na iKelp Jedáleň Ex](https://www.ikelp.com/jedalen/navody/navody-jedalen/navody-jedalen-nastavenia/migracia-prechod-z-verzie-2.4.xx-na-ikelp-jedalen-ex?epid=2411)
- [Obnova databázy zo zálohy v iKelp Jedáleň Ex](https://www.ikelp.com/jedalen/navody/navody-jedalen/navody-jedalen-nastavenia/obnova-databazy-zo-zalohy-v-ikelp-jedalen-ex?epid=3261)

![Write by Author / Vytvorené](https://www.ikelp.com/App_Themes/EzopTheme/Images/pen_16.png) by
    
      Ing. Lukáš Krajčír