# 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/Cache/Images/B9569DBF8B528DE7DBCE2C52358FAB10A3384D2C.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/01-install-sql-local-DB.JPG "01-install-sql-local-DB.JPG") 
[![Zobraziť 01-install-sql-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/01-install-sql-local-DB.JPG "Zobraziť 01-install-sql-local-DB.JPG")

[![02-install-sql-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/4E0616410D388AD0E1B093252F7A0FD47044A1A5.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/02-install-sql-local-DB.JPG "02-install-sql-local-DB.JPG") 
[![Zobraziť 02-install-sql-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/02-install-sql-local-DB.JPG "Zobraziť 02-install-sql-local-DB.JPG")

[![03-install-sql-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/C2A4D5A6DC89DA10D0972CF4DBB306878DAE735B.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/03-install-sql-local-DB.JPG "03-install-sql-local-DB.JPG") 
[![Zobraziť 03-install-sql-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/03-install-sql-local-DB.JPG "Zobraziť 03-install-sql-local-DB.JPG")

[![04-install-sql-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/FE399D66810C1237657EC8AE16CDBEF0DA8B2CC1.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/04-install-sql-local-DB.JPG "04-install-sql-local-DB.JPG") 
[![Zobraziť 04-install-sql-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/04-install-sql-local-DB.JPG "Zobraziť 04-install-sql-local-DB.JPG")

[![05-install-sql-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/2306C157A0A5BC249A9E2D17FF6EA64DFBB35B59.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/05-install-sql-local-DB.JPG "05-install-sql-local-DB.JPG") 
[![Zobraziť 05-install-sql-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/05-install-sql-local-DB.JPG "Zobraziť 05-install-sql-local-DB.JPG")

[![06-install-sql-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/50B68C569B55AED4C1AE3790C4AC985F074E6483.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/06-install-sql-local-DB.JPG "06-install-sql-local-DB.JPG") 
[![Zobraziť 06-install-sql-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-sql-native-client/06-install-sql-local-DB.JPG "Zobraziť 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/Cache/Images/6E2FDEBD05DF5D4CD475BEE0DBAF8D5EEED3A276.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/01-Install-local-DB.JPG "01-Install-local-DB.JPG") 
[![Zobraziť 01-Install-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/01-Install-local-DB.JPG "Zobraziť 01-Install-local-DB.JPG")

[![02-Install-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/0217CE5F685A7834F13C69C418F63F5FCE8C438F.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/02-Install-local-DB.JPG "02-Install-local-DB.JPG") 
[![Zobraziť 02-Install-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/02-Install-local-DB.JPG "Zobraziť 02-Install-local-DB.JPG")

[![03-Install-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/1555945034740CE380DF85D296F5498A2736DB5F.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/03-Install-local-DB.JPG "03-Install-local-DB.JPG") 
[![Zobraziť 03-Install-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/03-Install-local-DB.JPG "Zobraziť 03-Install-local-DB.JPG")

[![04-Install-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/402352046AC27135312B22A9DDA0B89A2035F1BD.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/04-Install-local-DB.JPG "04-Install-local-DB.JPG") 
[![Zobraziť 04-Install-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/install-localdb/04-Install-local-DB.JPG "Zobraziť 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/Cache/Images/BEF71EE7F933328C3D8728D9E8232BA12FA19BA5.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/01-nastavenie-spojenia-na-databazu.JPG "01-nastavenie-spojenia-na-databazu.JPG") 
[![Zobraziť 01-nastavenie-spojenia-na-databazu.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/01-nastavenie-spojenia-na-databazu.JPG "Zobraziť 01-nastavenie-spojenia-na-databazu.JPG")

[![02-nastavenie-spojenia-na-databazu.JPG](https://www.ikelp.com/UserData/Cache/Images/820E648A3B5A0A8A4F9FFD57CC111186A8B851FD.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/02-nastavenie-spojenia-na-databazu.JPG "02-nastavenie-spojenia-na-databazu.JPG") 
[![Zobraziť 02-nastavenie-spojenia-na-databazu.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/pripojenie-na-databazu/02-nastavenie-spojenia-na-databazu.JPG "Zobraziť 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/Cache/Images/90E9B1625F8D36F77FC3952EDE9D2F6BDB4DB510.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/01-create-local-DB.JPG "01-create-local-DB.JPG") 
[![Zobraziť 01-create-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/01-create-local-DB.JPG "Zobraziť 01-create-local-DB.JPG")

[![02-create-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/D1099014109EA4F9F0DC62D9AC6AE184D31C997E.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/02-create-local-DB.JPG "02-create-local-DB.JPG") 
[![Zobraziť 02-create-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/02-create-local-DB.JPG "Zobraziť 02-create-local-DB.JPG")

[![03-create-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/4C3B0556639068EFDCB7F1252B62A0CB3C1EF312.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/03-create-local-DB.JPG "03-create-local-DB.JPG") 
[![Zobraziť 03-create-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/03-create-local-DB.JPG "Zobraziť 03-create-local-DB.JPG")

[![04-create-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/F78586148900375DA467881988F2C52DB69CA0FC.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/04-create-local-DB.JPG "04-create-local-DB.JPG") 
[![Zobraziť 04-create-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/04-create-local-DB.JPG "Zobraziť 04-create-local-DB.JPG")

[![05-create-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/3B4475DA135C94C5ED0CFD2841B1CAFE3A34FC0A.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/05-create-local-DB.JPG "05-create-local-DB.JPG") 
[![Zobraziť 05-create-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/05-create-local-DB.JPG "Zobraziť 05-create-local-DB.JPG")

[![06-create-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/C49D4D5564AA899CEE390D1CEC32913826992B00.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/06-create-local-DB.JPG "06-create-local-DB.JPG") 
[![Zobraziť 06-create-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/06-create-local-DB.JPG "Zobraziť 06-create-local-DB.JPG")

[![07-create-local-DB.JPG](https://www.ikelp.com/UserData/Cache/Images/7F5D3C3CD4860838F025FE8EC49AEE404106C610.JPG)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/07-create-local-DB.JPG "07-create-local-DB.JPG") 
[![Zobraziť 07-create-local-DB.JPG](https://www.ikelp.com/App_Themes/EzopTheme/Images/magnifier-zoom-in-16.png)](https://www.ikelp.com/userdata/pages/0uiwc2/vytvorenie-novej-databazy/07-create-local-DB.JPG "Zobraziť 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)