{"id":114,"date":"2022-01-15T16:27:45","date_gmt":"2022-01-15T15:27:45","guid":{"rendered":"https:\/\/pohoda-mustek.cz\/navod\/?page_id=114"},"modified":"2022-05-05T21:35:54","modified_gmt":"2022-05-05T19:35:54","slug":"pripojeni-k-mssql-serveru-sql-autentifikace","status":"publish","type":"page","link":"https:\/\/pohoda-mustek.cz\/navod\/pripojeni-k-mssql-serveru-sql-autentifikace\/","title":{"rendered":"P\u0159ipojen\u00ed k MSSQL serveru, SQL autentifikace"},"content":{"rendered":"\n<p>Postup je komplikovan\u00fd ale robustn\u00ed a jeho v\u00fdhodou je men\u0161\u00ed z\u00e1vislost na nastaven\u00ed s\u00edt\u011b. P\u0159edpokladem je mo\u017enost spravovat MS-SQL server p\u0159es program Microsoft SQL Server Management Studio a SQL Server Configuration Manager. D\u00e1le propojen\u00ed PC na kter\u00e9m je instalov\u00e1n M\u016fstek se serverem na kter\u00e9m MS-SQL b\u011b\u017e\u00ed p\u0159es ve\u0159ejnou IP adresu nebo VPN. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Krok 1: Povolte TCP\/IP p\u0159ipojen\u00ed<\/h4>\n\n\n\n<p>P\u0159ipojen\u00ed povol\u00edte na stran\u011b MS-SQL serveru ke kter\u00e9mu se p\u0159ipojujete. K tomu pot\u0159ebujete SQL Server Configuration Manager. Jak jej otev\u0159\u00edt je pops\u00e1no <a href=\"https:\/\/www.mytecbits.com\/microsoft\/sql-server\/where-is-sql-server-configuration-manager\">zde.<\/a><\/p>\n\n\n\n<p>V kostce zadejte nap\u0159. p\u0159\u00edkaz compmgmt.msc k otev\u0159en\u00ed okna pro spr\u00e1vu po\u010d\u00edta\u010de, najd\u011bte slu\u017ebu SQL Server Network Configuration \/ Protocols for MSSQL . Vyberte TCP\/IP.<\/p>\n\n\n\n<p>V z\u00e1lo\u017ece Protocol povol\u00edte TCP\/IP protokol<\/p>\n\n\n\n<p>V z\u00e1lo\u017ece IP Addresses povol\u00edte port 1433<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"831\" height=\"678\" src=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image.png\" alt=\"\" class=\"wp-image-117\" srcset=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image.png 831w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-300x245.png 300w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-768x627.png 768w\" sizes=\"auto, (max-width: 831px) 100vw, 831px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Krok 2: Otestujte s\u00ed\u0165ov\u00e9 p\u0159ipojen\u00ed.<\/h4>\n\n\n\n<p>Test provedete na PC ze kter\u00e9ho se chcete p\u0159ipojovat. Server ke kter\u00e9mu se p\u0159ipojujete mus\u00ed b\u00fdt p\u0159\u00edstupn\u00fd na portu 1433, pokud tedy nen\u00ed MSSQL server nastaven na jin\u00fd port. P\u0159ipojen\u00ed lze otestovat spu\u0161t\u011bn\u00edm Power Shell&nbsp; a zad\u00e1n\u00ed p\u0159\u00edkazu ve tvaru<\/p>\n\n\n\n<p>Test-NetConnection &lt;ip_address&gt; -p &lt;port_number&gt;<\/p>\n\n\n\n<p>tedy nap\u0159.<\/p>\n\n\n\n<p>Test-NetConnection 192.168.10.50 -p 1433<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"430\" height=\"216\" src=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-1.png\" alt=\"\" class=\"wp-image-118\" srcset=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-1.png 430w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-1-300x151.png 300w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/figure>\n\n\n\n<p>V p\u0159\u00edkladu je pou\u017eita intern\u00ed&nbsp; IP adresa a propojen\u00ed je realizov\u00e1no p\u0159es VPN (nap\u0159 <a href=\"https:\/\/openvpn.net\/community-downloads\/\">Open VPN<\/a>).&nbsp; Probl\u00e9my mohou b\u00fdt s portem a to i v p\u0159\u00edpad\u011b ve\u0159ejn\u00e9 IP adresy &#8211; pokud je zav\u0159en\u00fd, mus\u00ed b\u00fdt ve firewall zad\u00e1na v\u00fdjimka.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Krok 3: Povolte SQL<\/h4>\n\n\n\n<p>Program Microsoft SQL Server Management Studio &#8211; klikn\u011bte prav\u00fdm tla\u010d\u00edtkem na n\u00e1zev serveru, vyberte Properties a povolte S<em>QL Server and Windows Authentication Mode<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-2-1024x504.png\" alt=\"\" class=\"wp-image-119\" srcset=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-2-1024x504.png 1024w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-2-300x148.png 300w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-2-768x378.png 768w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-2.png 1223w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Krok 4. Nastaven\u00ed u\u017eivatele<\/h4>\n\n\n\n<p>Program Microsoft SQL Server Management Studio :: Security :: Logins<\/p>\n\n\n\n<p>Zalo\u017ete nov\u00e9ho u\u017eivatele s heslem a povolenou SQL Server authentication<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"247\" src=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-3.png\" alt=\"\" class=\"wp-image-120\" srcset=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-3.png 729w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-3-300x102.png 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><\/figure>\n\n\n\n<p>na obr\u00e1zku naho\u0159e je vlevo vid\u011bt sekci User Mapping. P\u0159epn\u011bte do n\u00ed a nastavte u\u017eivateli pr\u00e1va nad datab\u00e1z\u00ed Pohody. Roli db_owner vyu\u017eijeme jen pro po\u010d\u00e1te\u010dn\u00ed testov\u00e1n\u00ed. Sou\u010dasn\u00e9 verzi m\u016fstku sta\u010d\u00ed role db_reader.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"647\" src=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-4.png\" alt=\"\" class=\"wp-image-121\" srcset=\"https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-4.png 700w, https:\/\/pohoda-mustek.cz\/navod\/wp-content\/uploads\/2022\/01\/image-4-300x277.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<p>TIP: U\u017eivatele otestujte t\u00edm \u017ee se pod n\u00edm p\u0159ihl\u00e1s\u00edte do manageru, p\u0159i prvn\u00edm p\u0159ihl\u00e1\u0161en\u00ed si program vy\u017e\u00e1d\u00e1 zm\u011bnu hesla.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Postup je komplikovan\u00fd ale robustn\u00ed a jeho v\u00fdhodou je men\u0161\u00ed z\u00e1vislost na nastaven\u00ed s\u00edt\u011b. P\u0159edpokladem je mo\u017enost spravovat MS-SQL server p\u0159es program Microsoft SQL Server Management Studio a SQL Server Configuration Manager. D\u00e1le propojen\u00ed PC na kter\u00e9m je instalov\u00e1n M\u016fstek se serverem na kter\u00e9m MS-SQL b\u011b\u017e\u00ed p\u0159es ve\u0159ejnou IP adresu nebo VPN. Krok 1: Povolte &hellip; <a href=\"https:\/\/pohoda-mustek.cz\/navod\/pripojeni-k-mssql-serveru-sql-autentifikace\/\" class=\"more-link\">Pokra\u010dov\u00e1n\u00ed textu <span class=\"screen-reader-text\">P\u0159ipojen\u00ed k MSSQL serveru, SQL autentifikace<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-114","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages\/114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":3,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages\/114\/revisions"}],"predecessor-version":[{"id":390,"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/pages\/114\/revisions\/390"}],"wp:attachment":[{"href":"https:\/\/pohoda-mustek.cz\/navod\/wp-json\/wp\/v2\/media?parent=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}