{"id":671,"date":"2026-10-07T15:46:58","date_gmt":"2026-10-07T13:46:58","guid":{"rendered":"https:\/\/datenquelle.at\/?page_id=671"},"modified":"2026-10-08T07:10:26","modified_gmt":"2026-10-08T05:10:26","slug":"sql-server-spojeni-selhalo","status":"publish","type":"page","link":"https:\/\/cz.datenquelle.at\/index.php\/sql-server-spojeni-selhalo\/","title":{"rendered":"SQL Server: spojen\u00ed selhalo"},"content":{"rendered":"<div class=\"et_pb_section_0 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_0 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_0 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_0 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-hero\" id=\"dq-main\"><div class=\"dq-wrap\"><nav class=\"dq-breadcrumbs\" aria-label=\"Drobe\u010dkov\u00e1 navigace\"><a href=\"https:\/\/cz.datenquelle.at\/\">\u00davod<\/a><span>\/<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/\">Chyby & \u0158e\u0161en\u00ed<\/a><span>\/<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/#datenbank\">P\u0159\u00edstup k datab\u00e1zi<\/a><\/nav><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>P\u0159\u00edstup k datab\u00e1zi<\/p><h1>SQL Server nen\u00ed dostupn\u00fd: spojen\u00ed selhalo<\/h1><p class=\"dq-lead\">Hl\u00e1\u0161en\u00ed \u201enetwork-related or instance-specific error\u201c nejprve ozna\u010duje ne\u00fasp\u011b\u0161n\u00e9 spojen\u00ed. Chyby 26, 40 nebo 53 mohou ukazovat na probl\u00e9m p\u0159i hled\u00e1n\u00ed nebo dosa\u017een\u00ed c\u00edle. Hl\u00e1\u0161en\u00ed \u201eLogin failed\u201c naopak pat\u0159\u00ed k p\u0159ihl\u00e1\u0161en\u00ed. O dal\u0161\u00edm kontroln\u00edm kroku rozhoduje \u00fapln\u00e9 hl\u00e1\u0161en\u00ed.<\/p><ol class=\"dq-help-flow\" aria-label=\"Cesta dat a kontroln\u00ed bod\"><li><span>Zdroj<\/span><strong>Pracovn\u00ed stanice nebo slu\u017eba<\/strong><\/li><li class=\"is-checkpoint\"><span>Ov\u011b\u0159it propojen\u00ed<\/span><strong>Server & Instance<\/strong><\/li><li><span>C\u00edl<\/span><strong>P\u0159ipojen\u00ed k datab\u00e1zi<\/strong><\/li><\/ol><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_1 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_1 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_1 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_1 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-body\"><div class=\"dq-wrap\"><div class=\"dq-help-layout\"><article class=\"dq-help-article\"><section class=\"dq-help-situation\"><h2>Jak se to projevuje v praxi<\/h2><p>ERP se spust\u00ed, ale po zm\u011bn\u011b serveru u\u017e nedos\u00e1hne na svou datab\u00e1zi. Jin\u00e9 aplikace mo\u017en\u00e1 st\u00e1le funguj\u00ed. Proto neprov\u011b\u0159ujeme obecn\u011b \u201es\u00ed\u0165\u201c, ale konkr\u00e9tn\u00ed spojen\u00ed t\u00e9to aplikace s jej\u00ed instanc\u00ed SQL Serveru.<\/p><\/section><section id=\"ursachen\"><h2>Rozli\u0161it typick\u00e9 p\u0159\u00ed\u010diny<\/h2><div class=\"dq-help-causes\"><div><h3>C\u00edl zm\u011bn\u011bn po p\u0159esunu<\/h3><p>N\u00e1zev serveru, instance nebo adresa p\u0159ipojen\u00ed mohou st\u00e1le odkazovat na star\u00e9 prost\u0159ed\u00ed.<\/p><\/div><div><h3>Jin\u00e1 s\u00ed\u0165ov\u00e1 cesta<\/h3><p>VPN, p\u0159eklad n\u00e1zv\u016f nebo povolen\u00e9 spojen\u00ed se mohou li\u0161it mezi kancel\u00e1\u0159\u00ed, ter\u00e9nem a slu\u017ebou na pozad\u00ed.<\/p><\/div><div><h3>P\u0159ihl\u00e1\u0161en\u00ed nebo p\u0159i\u0159azen\u00ed datab\u00e1ze<\/h3><p>Pokud je server dosa\u017een, m\u016f\u017ee dal\u0161\u00ed chybu vyvolat pou\u017eit\u00fd \u00fa\u010det nebo p\u0159\u00edstup ke konkr\u00e9tn\u00ed datab\u00e1zi.<\/p><\/div><\/div><\/section><section id=\"pruefen\"><h2>Co m\u016f\u017eete nejprve zkontrolovat<\/h2><ol class=\"dq-help-checks\"><li><h3>Zaznamenat hl\u00e1\u0161en\u00ed a dot\u010den\u00fd postup<\/h3><p>Zaznamenejte \u010d\u00edslo chyby, \u010das a zda se t\u00fdk\u00e1 v\u0161ech, nebo jen jednotliv\u00fdch pracovn\u00edch stanic.<\/p><\/li><li><h3>Porovnat o\u010dek\u00e1van\u00fd c\u00edl<\/h3><p>Porovnejte server a instanci se schv\u00e1lenou konfigurac\u00ed nebo funk\u010dn\u00ed pracovn\u00ed stanic\u00ed. Neotev\u00edrejte ve firewallu odhadnut\u00e9 porty.<\/p><\/li><li><h3>Vymezit posledn\u00ed zm\u011bnu<\/h3><p>\u0160lo o p\u0159esun serveru, zm\u011bnu VPN, nov\u00fd \u00fa\u010det nebo aktualizaci programu? S porovn\u00e1n\u00edm pomohou existuj\u00edc\u00ed protokoly.<\/p><\/li><\/ol><\/section><section id=\"tiefer\"><h2>Kdy\u017e je probl\u00e9m hlub\u0161\u00ed<\/h2><p>\u00dasp\u011b\u0161n\u00fd pokus o spojen\u00ed jin\u00fdm n\u00e1strojem je u\u017eite\u010dn\u00fd, ale nenahrazuje test skute\u010dn\u00e9ho programu a \u00fa\u010dtu. Rozli\u0161ujeme dosa\u017eitelnost, p\u0159ihl\u00e1\u0161en\u00ed, opr\u00e1vn\u011bn\u00ed a n\u00e1sledn\u00e9 zpracov\u00e1n\u00ed. Oprava tak m\u00ed\u0159\u00ed na spr\u00e1vn\u00e9 m\u00edsto.<\/p><div class=\"dq-help-details\"><details><summary>Ov\u011b\u0159it instanci, s\u00ed\u0165 a p\u0159ihl\u00e1\u0161en\u00ed odd\u011blen\u011b<\/summary><p>Pojmenovan\u00fd SQL Server m\u016f\u017ee pou\u017e\u00edvat jin\u00e9 parametry p\u0159ipojen\u00ed ne\u017e v\u00fdchoz\u00ed instance. Pot\u0159ebn\u00e1 konfigurace mus\u00ed vych\u00e1zet ze skute\u010dn\u00e9ho provozu. Zd\u00e1nliv\u011b vhodn\u00e9 nastaven\u00ed z jin\u00e9ho serveru nen\u00ed spolehliv\u00fdm v\u00fdchoz\u00edm bodem.<\/p><\/details><details><summary>Kdy\u017e se porucha vrac\u00ed<\/summary><p>Zaznamen\u00e1me c\u00edlov\u00fd syst\u00e9m, prov\u00e1d\u011bc\u00ed \u00fa\u010det, odpov\u011bdn\u00e9 osoby a posledn\u00ed zm\u011bny. Pokud v\u00edce aplikac\u00ed pou\u017e\u00edv\u00e1 stejn\u00fd server, jejich z\u00e1vislosti se zviditeln\u00ed. Z toho m\u016f\u017ee vzniknout \u0159\u00edzen\u00e1 migrace nebo stabiln\u00ed integra\u010dn\u00ed p\u0159\u00edstup.<\/p><\/details><\/div><\/section><section id=\"weiter\"><h2>Kdy d\u00e1v\u00e1 podpora smysl<\/h2><p>Pokud v\u00fdpadek postihuje v\u00edce program\u016f nebo se po p\u0159esunu trvale vrac\u00ed, vyplat\u00ed se spole\u010dn\u011b ov\u011b\u0159it aplikaci a infrastrukturu. Pro \u00favodn\u00ed rozhovor sta\u010d\u00ed \u010d\u00edslo chyby a popis zapojen\u00fdch syst\u00e9m\u016f.<\/p><a class=\"dq-help-service\" href=\"https:\/\/cz.datenquelle.at\/index.php\/propojeni-systemu\/\"><span>Vhodn\u00e9 \u0159e\u0161en\u00ed<\/span><strong>Vyjasnit propojen\u00ed existuj\u00edc\u00edch syst\u00e9m\u016f<\/strong><span class=\"dq-ui-arrow\" aria-hidden=\"true\"><\/span><\/a><aside class=\"dq-help-cross\"><p>Migrace server\u016f, VPN, s\u00ed\u0165 a pr\u016fb\u011b\u017en\u00e1 IT podpora pat\u0159\u00ed do zam\u011b\u0159en\u00ed DAXS na infrastrukturu a provoz.<\/p><a href=\"https:\/\/daxs.com\/\" rel=\"noopener\">Dal\u0161\u00ed informace u DAXS<span class=\"dq-ui-external\" aria-hidden=\"true\"><\/span><\/a><\/aside><\/section><section class=\"dq-help-sources\"><h2>Zdroje pro technickou orientaci<\/h2><ul><li><a href=\"https:\/\/learn.microsoft.com\/en-us\/troubleshoot\/sql\/database-engine\/connect\/network-related-or-instance-specific-error-occurred-while-establishing-connection\" rel=\"noopener\">Microsoft: S\u00ed\u0165ov\u00e9 chyby a chyby instance SQL Serveru<\/a><\/li><\/ul><p>Odborn\u011b ov\u011b\u0159eno 7. \u0159\u00edjna 2026. Informace v\u00fdrobc\u016f se vztahuj\u00ed k uveden\u00fdm produkt\u016fm; nenahrazuj\u00ed ov\u011b\u0159en\u00ed va\u0161\u00ed konkr\u00e9tn\u00ed konfigurace.<\/p><\/section><\/article><aside class=\"dq-help-toc\"><nav aria-label=\"Na t\u00e9to str\u00e1nce n\u00e1pov\u011bdy\"><span class=\"dq-kicker\">Na t\u00e9to str\u00e1nce<\/span><a href=\"#ursachen\">Typick\u00e9 p\u0159\u00ed\u010diny<\/a><a href=\"#pruefen\">Prvn\u00ed kontroly<\/a><a href=\"#tiefer\">Technick\u00e9 souvislosti<\/a><a href=\"#weiter\">Vhodn\u00e9 \u0159e\u0161en\u00ed<\/a><\/nav><div><span class=\"dq-kicker\">Souvisej\u00edc\u00ed probl\u00e9my<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/pristup-k-databazi-chyba-ssl-certifikatu\/\">P\u0159\u00edstup k datab\u00e1zi: chyba SSL certifik\u00e1tu<\/a><a href=\"https:\/\/cz.datenquelle.at\/index.php\/zdroj-dat-odbc-nenalezen-im002\/\">Zdroj dat ODBC nenalezen (IM002)<\/a><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/\">Na p\u0159ehled t\u00e9mat<\/a><\/div><\/aside><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_2 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_2 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_2 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_2 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-contact-section\"><div class=\"dq-wrap\"><div class=\"dq-help-contact\"><div><h2>Spole\u010dn\u011b vyjasnit dal\u0161\u00ed krok.<\/h2><p>Na za\u010d\u00e1tek sta\u010d\u00ed n\u00e1zvy program\u016f a stru\u010dn\u00fd popis probl\u00e9mu.<\/p><\/div><a class=\"dq-button\" href=\"https:\/\/cz.datenquelle.at\/index.php\/proberme-vas-problem-s-daty\/\" aria-haspopup=\"dialog\" aria-controls=\"dq-booking-modal\" data-dq-booking>Domluvit \u00favodn\u00ed rozhovor<\/a><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Posu\u010fte chyby spojen\u00ed SQL Serveru po zm\u011bn\u00e1ch s\u00edt\u011b, serveru nebo programu. Postupn\u011b rozli\u0161te c\u00edl, dosa\u017eitelnost a p\u0159ihl\u00e1\u0161en\u00ed.<\/p>\n","protected":false},"author":2,"featured_media":709,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-671","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/comments?post=671"}],"version-history":[{"count":4,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/671\/revisions"}],"predecessor-version":[{"id":814,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/671\/revisions\/814"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media\/709"}],"wp:attachment":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media?parent=671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}