{"id":192049,"date":"2018-12-19T09:36:45","date_gmt":"2018-12-19T08:36:45","guid":{"rendered":"https:\/\/guide.jtl-software.com\/installation-of-microsoft-sql-server-express\/"},"modified":"2023-06-14T14:55:53","modified_gmt":"2023-06-14T12:55:53","slug":"installation-of-microsoft-sql-server-express","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/","title":{"rendered":"Installation of Microsoft SQL Server Express"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2,h3\" data-toc class=\"list-wawi\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center\" id=\"installation-of-microsoft-sql-server-express\">Installation of Microsoft SQL Server Express <span id='anchor-installation-of-microsoft-sql-server-express' data-href='#installation-of-microsoft-sql-server-express' class='far fa-link' data-anchor><\/span><\/h1><div class=\"custom-box\">\n\t<div class=\"d-flex align-items-center mb-4\">\n\t\t\t\t\t\t\t<span class=\"mr-3 fa-stack flex-shrink-0 fa-1x\">\n\t\t\t<span class=\"fas fa-circle fa-stack-2x text-shaftblue\"><\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 fas fa-clipboard-list text-white fa-stack-1x\"><\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\n\t\t<h3 class=\"mb-0 \" id=\"your-task-initial-situation\">Your task\/initial situation <span id='anchor-your-task-initial-situation' data-href='#your-task-initial-situation' class='far fa-link' data-anchor><\/span><\/h3>\t<\/div>\n\t<div class=\"box-content\">\n\t\tFor the operation of JTL-Wawi, we recommend the installation of at least Microsoft SQL Server 2014 Express, ideally you should use SQL Server 2017 Express. Normally, the SQL server is automatically installed during the database setup of JTL-Wawi. These instructions show you how to install this version manually. In other versions, individual dialogues or steps may differ slightly.\t<\/div>\n<\/div>\n\t<p>More information about databases can be found in the chapter<span style=\"color: #f68b25;\">&nbsp;<a style=\"color: #f68b25;\" title=\"Category:JTL-Wawi:Database\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/\">Managing the JTL-Wawi database<\/a><\/span>. You can also read the blog entry on the <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/www.jtl-software.de\/blog\/loesungen-von-jtl\/optimale-einrichtung-der-sql-datenbank\">Optimal setup of the SQL database<\/a><\/span>.<\/p>\n<h2 class=\"d-flex align-items-center\" id=\"system-requirements\">System requirements <span id='anchor-system-requirements' data-href='#system-requirements' class='far fa-link' data-anchor><\/span><\/h2>\t<p>SQL Server 2019 can be installed on 32-bit and 64-bit operating systems. You can find the installation files <a href=\"https:\/\/www.microsoft.com\/de-de\/sql-server\/sql-server-downloads\">here<\/a>.<\/p>\n<p><b>Please note that the installation file is approx. 1.4 GB in size.<\/b><\/p>\n<p>System requirements<\/p>\n<p><b>Supported operating systems:<\/b><br \/>\nWindows 10&nbsp;; Windows 8; Windows 8.1; Windows Server 2012; Windows Server 2012 R2; Windows Server 2016<\/p>\n<p><b>32-bit systems<\/b><br \/>\nComputer with Intel or compatible 1 GHz processor or faster (at least 2 GHz is recommended).<\/p>\n<p><b>64-bit systems<\/b><br \/>\n1.4 GHz processor or faster. At least 512 MB RAM is required (at least 2 GB is recommended). 4.2 GB available hard drive space.<\/p>\n<h2 class=\"d-flex align-items-center\" id=\"installation\">Installation <span id='anchor-installation' data-href='#installation' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tExecute the downloaded .exe file. The installer for the Microsoft SQL Server starts. Click <span class=\"highlight\">Download Media<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/medien-herunterladen-sql-server-installation.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/medien-herunterladen-sql-server-installation.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/medien-herunterladen-sql-server-installation.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/medien-herunterladen-sql-server-installation.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/medien-herunterladen-sql-server-installation-768x609.png 640w\" width=\"845\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"670\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/medien-herunterladen-sql-server-installation.png&quot;,&quot;w&quot;:845,&quot;h&quot;:670}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"2\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tSelect the <span class=\"highlight\">Express Core<\/span> package and click <span class=\"highlight\">Download<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/nur-sql-server-engine-sql-server-installation.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/nur-sql-server-engine-sql-server-installation.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/nur-sql-server-engine-sql-server-installation.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/nur-sql-server-engine-sql-server-installation.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/nur-sql-server-engine-sql-server-installation-768x609.png 640w\" width=\"845\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"670\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/nur-sql-server-engine-sql-server-installation.png&quot;,&quot;w&quot;:845,&quot;h&quot;:670}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"3\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tUnpack the downloaded package. After the files have been successfully unpacked, the installation begins. Select the menu item <span class=\"highlight\">New SQL server standalone installation<\/span> from the menu.<\/li><li >\n\tRead the licence terms and accept them by activating the check box <span class=\"highlight\">I accept the license terms and privacy statement<\/span>. Then click <span class=\"highlight\">Next<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/02SQLINST03.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/02SQLINST03.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/02SQLINST03.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/02SQLINST03.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/02SQLINST03-768x579.png 640w\" width=\"806\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"608\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/02SQLINST03.png&quot;,&quot;w&quot;:806,&quot;h&quot;:608}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"5\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tThe installation now checks whether your system supports the system requirements. After a successful test, click <span class=\"highlight\">Next<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/03SQLINST06.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/03SQLINST06.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/03SQLINST06.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/03SQLINST06.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/03SQLINST06-768x579.png 640w\" width=\"806\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"608\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/03SQLINST06.png&quot;,&quot;w&quot;:806,&quot;h&quot;:608}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"6\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tSelect the components to be installed. We do not recommend making any changes here. If you want to use the default directory for the installation, click&nbsp;<span class=\"highlight\">Next<\/span>.<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><strong>Please note:<\/strong><\/span> If possible, make sure that the installation path is not on the same hard drive as Windows or the database files. Read more on the topic <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/www.jtl-software.de\/blog\/loesungen-von-jtl\/optimale-einrichtung-der-sql-datenbank#die-hardware-grundlage\">here<\/a><\/span>.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/funktionsauswahl-sql-server-installation.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/funktionsauswahl-sql-server-installation.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/funktionsauswahl-sql-server-installation.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/funktionsauswahl-sql-server-installation.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/funktionsauswahl-sql-server-installation-768x598.png 640w\" width=\"820\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"639\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/funktionsauswahl-sql-server-installation.png&quot;,&quot;w&quot;:820,&quot;h&quot;:639}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"7\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tIn this dialogue box, select the option&nbsp;<span class=\"highlight\">Named Instance<\/span> and assign a name. Then click <span class=\"highlight\">Next<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/05SQLINST08.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/05SQLINST08.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/05SQLINST08.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/05SQLINST08.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/05SQLINST08-768x579.png 640w\" width=\"806\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"608\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/05SQLINST08.png&quot;,&quot;w&quot;:806,&quot;h&quot;:608}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"8\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tIn the <span class=\"highlight\">Server Configuration<\/span> dialogue box, switch to the <span class=\"highlight\">Collation<\/span> tab and check that the collation is correctly set to <strong>Latin1_General_CI_AS<\/strong>. If this is not the case, click <span class=\"highlight\">Customise<\/span> and select the correct option. Then click <span class=\"highlight\">Next<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/SQL_Server_Sortierung_1.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/SQL_Server_Sortierung_1.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/SQL_Server_Sortierung_1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/SQL_Server_Sortierung_1.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/SQL_Server_Sortierung_1-768x579.png 640w\" width=\"811\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"611\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/SQL_Server_Sortierung_1.png&quot;,&quot;w&quot;:811,&quot;h&quot;:611}\" class=\"img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/SQL-Server-Sortierung-kollokation-auswaehlen.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/SQL-Server-Sortierung-kollokation-auswaehlen.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/SQL-Server-Sortierung-kollokation-auswaehlen.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/SQL-Server-Sortierung-kollokation-auswaehlen.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/SQL-Server-Sortierung-kollokation-auswaehlen.png 640w\" width=\"701\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"493\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/SQL-Server-Sortierung-kollokation-auswaehlen.png&quot;,&quot;w&quot;:701,&quot;h&quot;:493}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"9\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tSelect the option&nbsp;<span class=\"highlight\">Mixed Mode<\/span>. Now assign a password for the system administrator (sa).<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><strong>Attention:<\/strong><\/span> <strong>Write down the password!<\/strong> If you lose or forget the password, there is no way to recover it. In a standard installation, JTL uses the password \u201csa04jT14\u201d; for SQL Server 2016, however, the password must be longer. Read more on the topic <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/www.jtl-software.de\/blog\/loesungen-von-jtl\/optimale-einrichtung-der-sql-datenbank#die-hardware-grundlage\">here<\/a><\/span>.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"10\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tClick <span class=\"highlight\">Next<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/07SQLINST10.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/07SQLINST10.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/07SQLINST10.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/07SQLINST10.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/07SQLINST10-768x579.png 640w\" width=\"806\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"608\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/07SQLINST10.png&quot;,&quot;w&quot;:806,&quot;h&quot;:608}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>The installation will now be carried out. This may take a while.<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/10SQLINST13.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/10SQLINST13.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/10SQLINST13.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/10SQLINST13.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/10SQLINST13-768x579.png 640w\" width=\"806\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"608\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/10SQLINST13.png&quot;,&quot;w&quot;:806,&quot;h&quot;:608}\" class=\"border-gray border-w-1 border mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"11\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tClick&nbsp;<span class=\"highlight\">Close<\/span> and restart your computer. The installation is now complete.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/11SQLINST15.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/11SQLINST15.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/11SQLINST15.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/11SQLINST15.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/11SQLINST15-768x579.png 640w\" width=\"806\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"608\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/11SQLINST15.png&quot;,&quot;w&quot;:806,&quot;h&quot;:608}\" class=\"border-gray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"mt-5 card\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-wawi\">\n\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t<span data-fa-transform=\"shrink-8\" class=\"fas fa-link fa-inverse\"><\/span>\n\t\t<\/span>\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"d-flex align-items-center hl-wawi h4\">Related topics<\/p>\n<ul class=\"list-reset list-icons list-custom-square list-wawi\">\n\t\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\" title=\"Executing SQL on the database\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tExecuting SQL on the database\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/optimal-sql-server-setup\/\" title=\"Optimal SQL server setup\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tOptimal SQL server setup\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/\" title=\"Tips for SQL server maintenance\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tTips for SQL server maintenance\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\" title=\"Securing the SQL server connection of JTL-Wawi with SSL\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tSecuring the SQL server connection of JTL-Wawi with SSL\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t<\/ul>\t<\/div>\n<\/div>[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":192322,"menu_order":739,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-192049","page","type-page","status-publish","hentry","pages_category-print-wawi-1-installation-en","pages_category-sql-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Installing Microsoft SQL Server Express for JTL-Wawi<\/title>\n<meta name=\"description\" content=\"In this tutorial you will learn how to install and configure a Microsoft SQL Server Express for JTL-Wawi.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing Microsoft SQL Server Express for JTL-Wawi\" \/>\n<meta property=\"og:description\" content=\"In this tutorial you will learn how to install and configure a Microsoft SQL Server Express for JTL-Wawi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T12:55:53+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/\",\"name\":\"Installing Microsoft SQL Server Express for JTL-Wawi\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2018-12-19T08:36:45+00:00\",\"dateModified\":\"2023-06-14T12:55:53+00:00\",\"description\":\"In this tutorial you will learn how to install and configure a Microsoft SQL Server Express for JTL-Wawi.\",\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Installing Microsoft SQL Server Express for JTL-Wawi","description":"In this tutorial you will learn how to install and configure a Microsoft SQL Server Express for JTL-Wawi.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/","og_locale":"en_US","og_type":"article","og_title":"Installing Microsoft SQL Server Express for JTL-Wawi","og_description":"In this tutorial you will learn how to install and configure a Microsoft SQL Server Express for JTL-Wawi.","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/","og_site_name":"JTL-Guide","article_modified_time":"2023-06-14T12:55:53+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/","name":"Installing Microsoft SQL Server Express for JTL-Wawi","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2018-12-19T08:36:45+00:00","dateModified":"2023-06-14T12:55:53+00:00","description":"In this tutorial you will learn how to install and configure a Microsoft SQL Server Express for JTL-Wawi.","inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/installation-of-microsoft-sql-server-express\/"]}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=192049"}],"version-history":[{"count":1,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192049\/revisions"}],"predecessor-version":[{"id":192064,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192049\/revisions\/192064"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192322"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=192049"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=192049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}