{"id":192025,"date":"2018-12-19T09:36:56","date_gmt":"2018-12-19T08:36:56","guid":{"rendered":"https:\/\/guide.jtl-software.com\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/"},"modified":"2023-06-14T14:55:43","modified_gmt":"2023-06-14T12:55:43","slug":"securing-the-sql-server-connection-of-jtl-wawi-with-ssl","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/","title":{"rendered":"Securing the SQL server connection of JTL-Wawi with SSL"},"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=\"securing-the-sql-server-connection-of-jtl-wawi-with-ssl\">Securing the SQL server connection of JTL-Wawi with SSL <span id='anchor-securing-the-sql-server-connection-of-jtl-wawi-with-ssl' data-href='#securing-the-sql-server-connection-of-jtl-wawi-with-ssl' 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\tYou are running an SQL server for JTL-Wawi that can be accessed via the internet. This is usually the case if you work remotely or access JTL-Wawi from multiple locations. The communication between JTL-Wawi and your SQL database is in plain text. This means that anyone who manages to access the data can also read your SQL database. To prevent this, you now want to encrypt the data via an SSL certificate.\t<\/div>\n<\/div>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\t\t<span class=\"mt-1 mr-3 fa-stack flex-shrink-0 fa-1x columnsize-fa-2x\">\n\t\t<span class=\"far fa-circle fa-stack-2x text-wawi\"><\/span>\n\t\n\t\t<span class=\"fas fa-search-plus text-wawi fa-stack-1x\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<b>Please note:<\/b> If you use the JTL-Wawi Database Hosting, your connection is already secured by SSL.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h2 class=\"d-flex align-items-center\" id=\"step-1-purchase-a-valid-ssl-certificate\">Step 1: Purchase a valid SSL certificate <span id='anchor-step-1-purchase-a-valid-ssl-certificate' data-href='#step-1-purchase-a-valid-ssl-certificate' class='far fa-link' data-anchor><\/span><\/h2>\t<p>First you need to purchase a valid SSL certificate. We recommend using one of the official Microsoft certifiers. There are free and fee-based solutions for SSL certificates. Every certificate is issued specifically for the server on which it is to be used later. It is therefore important that the server address you enter when you purchase the certificate is the address via which you access your server. Once you have purchased a certificate, proceed with Step 2.<\/p>\n<h2 class=\"d-flex align-items-center\" id=\"step-2-set-up-the-ssl-certificate-in-the-management-console\">Step 2: Set up the SSL certificate in the Management Console <span id='anchor-step-2-set-up-the-ssl-certificate-in-the-management-console' data-href='#step-2-set-up-the-ssl-certificate-in-the-management-console' class='far fa-link' data-anchor><\/span><\/h2>\t<p>Log into the computer on which the SQL server for JTL-Wawi is running.<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tOpen the Microsoft Windows Management Console. The quickest way to do this is to open the Start menu and enter\u00a0<span class=\"highlight\">mmc<\/span>.<\/li><li >\n\tIn the Management Console, go to the menu\u00a0<span class=\"highlight\">Datei<\/span>\u00a0(File) and select\u00a0<span class=\"highlight\">Snap-in hinzuf\u00fcgen\/entfernen<\/span>\u00a0(Add\/Remove snap-in).<\/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\/Jtl-wawi-installation-001-mmc-snap-in-hinzu.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-mmc-snap-in-hinzu.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-mmc-snap-in-hinzu.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-mmc-snap-in-hinzu-1024x667.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-mmc-snap-in-hinzu-768x500.png 640w\" width=\"1362\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"887\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-001-mmc-snap-in-hinzu.png&quot;,&quot;w&quot;:1362,&quot;h&quot;:887}\" 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\tSelect\u00a0<span class=\"highlight\">Zertifikate<\/span>\u00a0(Certificates) and click\u00a0<span class=\"highlight\">Hinzuf\u00fcgen<\/span>\u00a0(Add). Then close the window with\u00a0<span class=\"highlight\">OK<\/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\/Jtl-wawi-002-mmx-zertifikat-hinzu.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-mmx-zertifikat-hinzu.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-mmx-zertifikat-hinzu.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-mmx-zertifikat-hinzu.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-mmx-zertifikat-hinzu.png 640w\" width=\"743\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"477\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-002-mmx-zertifikat-hinzu.png&quot;,&quot;w&quot;:743,&quot;h&quot;:477}\" 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=\"4\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tUnder\u00a0<span class=\"highlight\">Konsolenstamm<\/span>\u00a0(Console root), select\u00a0<span class=\"highlight\">Zertifikate \u2013 Aktueller Benutzer<\/span>\u00a0(Certificates \u2013 Current user) and select the folder\u00a0<span class=\"highlight\">Eigene Zertifikate<\/span>\u00a0(Personal certificates).<\/li><li >\n\tRight-click on the pane\u00a0<span class=\"highlight\">Objekttyp<\/span>\u00a0(Object type) and select\u00a0<span class=\"highlight\">Alle Aufgaben &gt; Importieren<\/span>\u00a0(All tasks &gt; Import).<\/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\/Jtl-wawi-003-mmc-zertifikat-importieren.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-003-mmc-zertifikat-importieren.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-003-mmc-zertifikat-importieren.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-003-mmc-zertifikat-importieren-1024x667.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-003-mmc-zertifikat-importieren-768x500.png 640w\" width=\"1362\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"887\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-003-mmc-zertifikat-importieren.png&quot;,&quot;w&quot;:1362,&quot;h&quot;:887}\" 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\tAdd your certificate and click\u00a0<span class=\"highlight\">Weiter<\/span>\u00a0(Next) to complete the setup.<\/li><\/ol><h2 class=\"d-flex align-items-center\" id=\"step-3-set-up-the-ssl-certificate-in-the-sql-server-configuration-manager\">Step 3: Set up the SSL certificate in the SQL server configuration manager <span id='anchor-step-3-set-up-the-ssl-certificate-in-the-sql-server-configuration-manager' data-href='#step-3-set-up-the-ssl-certificate-in-the-sql-server-configuration-manager' class='far fa-link' data-anchor><\/span><\/h2>\t<p>You now need to set up the SSL certificate in the SQL server configuration manager. This is also performed on the computer on which the SQL server is running.<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tOpen the SQL server configuration manager for your version of Microsoft\u00a0SQL\u00a0Server via the Start menu.<\/li><li class=\"media-single-line\">\n\tClick on\u00a0<span class=\"highlight\">SQL-Server-Netzwerkkonfiguration<\/span>\u00a0(SQL Server Network Configuration).<\/li><li >\n\tRight-click on the entry with your SQL server and select the option\u00a0<span class=\"highlight\">Eigenschaften<\/span>\u00a0(Properties) in the context menu.<\/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\/Jtl-wawi-installation-001-sql-konfig-eigenschaften.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sql-konfig-eigenschaften.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sql-konfig-eigenschaften.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sql-konfig-eigenschaften.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sql-konfig-eigenschaften-768x580.png 640w\" width=\"946\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"715\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-001-sql-konfig-eigenschaften.png&quot;,&quot;w&quot;:946,&quot;h&quot;:715}\" class=\"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=\"4\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tA window opens. In this window, set the option\u00a0<span class=\"highlight\">Force encryption<\/span>\u00a0to\u00a0<span class=\"highlight\">Ja<\/span>\u00a0(Yes).<\/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\/Jtl-wawi-002-sql-konfig-force-encryption.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-sql-konfig-force-encryption.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-sql-konfig-force-encryption.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-sql-konfig-force-encryption.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-002-sql-konfig-force-encryption.png 640w\" width=\"412\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"473\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-002-sql-konfig-force-encryption.png&quot;,&quot;w&quot;:412,&quot;h&quot;:473}\" class=\"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\tGo to the tab\u00a0<span class=\"highlight\">Zertifikate<\/span>\u00a0(Certificates) and select your SSL certificate.<\/li><li class=\"media-single-line\">\n\tClose the window by clicking\u00a0<span class=\"highlight\">OK<\/span>.<\/li><li class=\"media-single-line\">\n\tRestart your SQL server. Your connection is now secure.<\/li><\/ol><h2 class=\"d-flex align-items-center\" id=\"tips-and-tricks-for-better-data-security\">Tips and tricks for better data security <span id='anchor-tips-and-tricks-for-better-data-security' data-href='#tips-and-tricks-for-better-data-security' class='far fa-link' data-anchor><\/span><\/h2>\t<p>There are other options available to increase data security alongside securing your connection to the SQL server with an SSL certificate<\/p>\n<h3 class=\"d-flex align-items-center\" id=\"different-sql-users\">Different SQL users <span id='anchor-different-sql-users' data-href='#different-sql-users' class='far fa-link' data-anchor><\/span><\/h3>\t<p>With the default setting, every JTL-Wawi user accesses the JTL-Wawi database via the same SQL user. We recommend creating a separate SQL user for each user, i.e. each employee. This offers several advantages:<\/p>\n<ul class=\"list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tWhen an employee leaves your business, you can simply disable their SQL access. This means that they can no longer access JTL-Wawi.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tYou can deactivate user sa. This user is frequently attacked on Microsoft SQL databases.\t<\/li><\/ul>\t<p>How to create new SQL users:<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tOn the computer on which the SQL server is running, open SQL Server Management Studio. If it is not installed on your computer, you can download it here:\u00a0<a class=\"external text\" href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-2017\"  target='_blank' rel='noopener noreferrer' rel=\"nofollow noopener noreferrer\">Microsoft download page<\/a>.<\/li><li >\n\tLog in to the JTL-Wawi SQL server. In the folder\u00a0<span class=\"highlight\">Sicherheit<\/span>\u00a0(Security), right-click on the folder\u00a0<span class=\"highlight\">Anmeldungen<\/span>\u00a0(Login) and select\u00a0<span class=\"highlight\">Neue Anmeldung<\/span>\u00a0(New login) in the context menu.<\/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\/Jtl-wawi-installation-001-ssl-verbindung-eigene-sql-benutzer-neue-anmeldung.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-ssl-verbindung-eigene-sql-benutzer-neue-anmeldung.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-ssl-verbindung-eigene-sql-benutzer-neue-anmeldung.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-ssl-verbindung-eigene-sql-benutzer-neue-anmeldung.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-ssl-verbindung-eigene-sql-benutzer-neue-anmeldung.png 640w\" width=\"603\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"384\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-001-ssl-verbindung-eigene-sql-benutzer-neue-anmeldung.png&quot;,&quot;w&quot;:603,&quot;h&quot;:384}\" 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\tEnter a\u00a0<span class=\"highlight\">Anmeldename<\/span>\u00a0(Login name) for the new user and select the option\u00a0<span class=\"highlight\">SQL-Server-Authentifizierung<\/span>\u00a0(SQL server authentication). Select a\u00a0<span class=\"highlight\">Kennwort<\/span>\u00a0(Password). Additionally, you can check the option\u00a0<span class=\"highlight\">Kennwortrichtlinie erzwingen<\/span>\u00a0(Enforce password policy). This means that the password must consist of at least 12 characters, including small and capital letters, numbers and special characters.<\/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\/Jtl-wawi-installation-002-ssl-neuer-sql-nutzer-allgemein.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-ssl-neuer-sql-nutzer-allgemein.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-ssl-neuer-sql-nutzer-allgemein.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-ssl-neuer-sql-nutzer-allgemein.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-ssl-neuer-sql-nutzer-allgemein.png 640w\" width=\"690\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"625\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-002-ssl-neuer-sql-nutzer-allgemein.png&quot;,&quot;w&quot;:690,&quot;h&quot;:625}\" class=\"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=\"4\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tUnder the menu item <span class=\"highlight\">Serverrollen<\/span> (Server roles), assign the desired role to the user. Here you can, for example, select <span class=\"highlight\">sysadmin<\/span>\u00a0if you want the user to have access to the database administration. If at least one user has\u00a0<span class=\"highlight\">sysadmin<\/span>\u00a0rights, user\u00a0<span class=\"highlight\">sa<\/span>\u00a0can later be deactivated (see below).<\/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\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png 640w\" width=\"690\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"625\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png&quot;,&quot;w&quot;:690,&quot;h&quot;:625}\" class=\"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 class=\"media-single-line\">\n\tClose the dialogue box by clicking\u00a0<span class=\"highlight\">OK<\/span>.<\/li><li >\n\tThen open JTL-Wawi on the user\u2019s\/your employee\u2019s computer and open the database administration.<\/li><li class=\"media-single-line\">\n\tClick\u00a0<span class=\"highlight\">Neues Profil<\/span>\u00a0(New profile).<\/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\/Jtl-wawi-installation-004-neues-sql-benutzerprofil.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-004-neues-sql-benutzerprofil.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-004-neues-sql-benutzerprofil.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-004-neues-sql-benutzerprofil-1024x549.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-004-neues-sql-benutzerprofil-768x412.png 640w\" width=\"1906\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"1022\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-004-neues-sql-benutzerprofil.png&quot;,&quot;w&quot;:1906,&quot;h&quot;:1022}\" 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\tEnter a profile name, a description and the name of your SQL server in the field <span class=\"highlight\">Servername<\/span> (Server name). Click <span class=\"highlight\">Weiter<\/span> (Next).<\/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\/Jtl-wawi-installation-005-neues-profil-anmeldedaten.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-005-neues-profil-anmeldedaten.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-005-neues-profil-anmeldedaten.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-005-neues-profil-anmeldedaten-1024x549.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-005-neues-profil-anmeldedaten-768x412.png 640w\" width=\"1906\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"1022\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-005-neues-profil-anmeldedaten.png&quot;,&quot;w&quot;:1906,&quot;h&quot;:1022}\" class=\"border-gray border-w-1 border-bottom 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\tEnter the\u00a0<span class=\"highlight\">Benutzer<\/span>\u00a0(User) and\u00a0<span class=\"highlight\">Passwort<\/span>\u00a0(Password) that you specified in Step 3 of these instructions. To continue, click\u00a0<span class=\"highlight\">Weiter<\/span>\u00a0(Next). The profile will now be created.<\/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\/Jtl-wawi-installation-006-anmeldedaten-neues-profil.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-006-anmeldedaten-neues-profil.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-006-anmeldedaten-neues-profil.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-006-anmeldedaten-neues-profil-1024x549.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-006-anmeldedaten-neues-profil-768x412.png 640w\" width=\"1906\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"1022\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-006-anmeldedaten-neues-profil.png&quot;,&quot;w&quot;:1906,&quot;h&quot;:1022}\" 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=\"10\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tThe user\/employee can now access the JTL-Wawi database with this profile. The user\/employee continues to use the login data specified in the user management of JTL-Wawi.<\/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\/Jtl-wawi-installation-007-neues-profil-login-in-jtl-wawi.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-007-neues-profil-login-in-jtl-wawi.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-007-neues-profil-login-in-jtl-wawi.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-007-neues-profil-login-in-jtl-wawi.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-007-neues-profil-login-in-jtl-wawi.png 640w\" width=\"474\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"480\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-007-neues-profil-login-in-jtl-wawi.png&quot;,&quot;w&quot;:474,&quot;h&quot;:480}\" 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<h3 class=\"d-flex align-items-center\" id=\"changing-sa-password\">Changing sa password <span id='anchor-changing-sa-password' data-href='#changing-sa-password' class='far fa-link' data-anchor><\/span><\/h3>\t<p>If you install the Microsoft\u00a0SQL\u00a0Server during the installation of JTL-Wawi, the default password is sa04jT14. This password is known to anyone who has used products from JTL-Software before. Therefore, we highly recommend choosing a password that is not similar to the default password.<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tLog in to Microsoft SQL-Server Management Studio as user\u00a0<span class=\"highlight\">sa<\/span>\u00a0.<\/li><li class=\"media-single-line\">\n\tExpand the folder\u00a0<span class=\"highlight\">Sicherheit &gt; Anmeldungen<\/span>\u00a0(Security &gt; Login).<\/li><li class=\"media-single-line\">\n\tRight-click on user\u00a0<span class=\"highlight\">sa<\/span>\u00a0and select\u00a0<span class=\"highlight\">Eigenschaften<\/span>\u00a0(Properties).<\/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\/Jtl-wawi-installation-001-sa-passwort-eigenschaften.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-passwort-eigenschaften.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-passwort-eigenschaften.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-passwort-eigenschaften.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-passwort-eigenschaften.png 640w\" width=\"600\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"696\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-001-sa-passwort-eigenschaften.png&quot;,&quot;w&quot;:600,&quot;h&quot;:696}\" 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=\"4\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tInto the field\u00a0<span class=\"highlight\">Kennwort<\/span>\u00a0(Password), enter the new password and confirm it.<\/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\/Jtl-wawi-installation-002-sa-passwort-anpassen.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-sa-passwort-anpassen.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-sa-passwort-anpassen.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-sa-passwort-anpassen.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-002-sa-passwort-anpassen.png 640w\" width=\"690\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"625\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-002-sa-passwort-anpassen.png&quot;,&quot;w&quot;:690,&quot;h&quot;:625}\" 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<h3 class=\"d-flex align-items-center h4\" id=\"deactivating-user-sa\">Deactivating user sa <span id='anchor-deactivating-user-sa' data-href='#deactivating-user-sa' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Once you have created other users with sysadmin rights, we recommend deactivating user\u00a0<span class=\"highlight\">sa<\/span>\u00a0completely. User\u00a0<span class=\"highlight\">sa<\/span>\u00a0is the default user for every Microsoft\u00a0SQL\u00a0Server. This makes it one of the most frequent points of attack on the database.<\/p>\n<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<b>Please note:<\/b>\u00a0Make absolutely sure that there is at least one other SQL database user with\u00a0<span class=\"highlight\">sysadmin<\/span>\u00a0rights. For further information on this, please see the instructions further up:\u00a0<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/#unterschiedliche-sql-benutzer\">Different SQL users<\/a>.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tLog in to Microsoft SQL-Server Management Studio as user\u00a0<span class=\"highlight\">sa<\/span>\u00a0.<\/li><li class=\"media-single-line\">\n\tExpand the folder\u00a0<span class=\"highlight\">Sicherheit &gt; Anmeldungen<\/span>\u00a0(Security &gt; Login).<\/li><li class=\"media-single-line\">\n\tRight-click on user\u00a0<span class=\"highlight\">sa<\/span>\u00a0and select\u00a0<span class=\"highlight\">Eigenschaften<\/span>\u00a0(Properties).<\/li><li >\n\tGo to the menu item\u00a0<span class=\"highlight\">Status<\/span>\u00a0and check\u00a0<span class=\"highlight\">Deaktiviert<\/span>\u00a0(Deactivated) under\u00a0<span class=\"highlight\">Anmeldename<\/span>\u00a0(Login name).<\/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\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png 640w\" width=\"690\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"625\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-installation-001-sa-nutzer-deaktivieren.png&quot;,&quot;w&quot;:690,&quot;h&quot;:625}\" class=\"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>User\u00a0<span class=\"highlight\">sa<\/span>\u00a0is now disabled. If you happen to need it again at some point in the future, log in with another user with sysadmin rights and repeat Steps 1\u20134. In the last step, choose the option\u00a0<span class=\"highlight\">Aktiviert<\/span>\u00a0(Enabled).<\/p>\n<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\/installation-of-microsoft-sql-server-express\/\" title=\"Installation of Microsoft SQL Server Express\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tInstallation of Microsoft SQL Server Express\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<\/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\/tips-for-sql-server-maintenance\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":192322,"menu_order":745,"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-192025","page","type-page","status-publish","hentry","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>Securing the SQL server connection of JTL-Wawi with SSL &#8211; JTL-Guide<\/title>\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\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Securing the SQL server connection of JTL-Wawi with SSL &#8211; JTL-Guide\" \/>\n<meta property=\"og:description\" content=\"[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;, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T12:55:43+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=\"14 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\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\",\"name\":\"Securing the SQL server connection of JTL-Wawi with SSL &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2018-12-19T08:36:56+00:00\",\"dateModified\":\"2023-06-14T12:55:43+00:00\",\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\"]}]},{\"@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":"Securing the SQL server connection of JTL-Wawi with SSL &#8211; JTL-Guide","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\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/","og_locale":"en_US","og_type":"article","og_title":"Securing the SQL server connection of JTL-Wawi with SSL &#8211; JTL-Guide","og_description":"[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;, [...]","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/","og_site_name":"JTL-Guide","article_modified_time":"2023-06-14T12:55:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/","name":"Securing the SQL server connection of JTL-Wawi with SSL &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2018-12-19T08:36:56+00:00","dateModified":"2023-06-14T12:55:43+00:00","inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/"]}]},{"@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\/192025","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=192025"}],"version-history":[{"count":1,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192025\/revisions"}],"predecessor-version":[{"id":192040,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192025\/revisions\/192040"}],"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=192025"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=192025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}