{"id":790,"date":"2026-10-07T15:46:58","date_gmt":"2026-10-07T13:46:58","guid":{"rendered":"https:\/\/datenquelle.at\/?page_id=790"},"modified":"2026-10-08T07:10:59","modified_gmt":"2026-10-08T05:10:59","slug":"sql-server-sikertelen-kapcsolat","status":"publish","type":"page","link":"https:\/\/hu.datenquelle.at\/index.php\/sql-server-sikertelen-kapcsolat\/","title":{"rendered":"SQL Server: sikertelen kapcsolat"},"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=\"Morzsanavig\u00e1ci\u00f3\"><a href=\"https:\/\/hu.datenquelle.at\/\">Kezd\u0151lap<\/a><span>\/<\/span><a href=\"https:\/\/hu.datenquelle.at\/index.php\/hibak-es-megoldasok-az-adataihoz\/\">Hib\u00e1k & Megold\u00e1sok<\/a><span>\/<\/span><a href=\"https:\/\/hu.datenquelle.at\/index.php\/hibak-es-megoldasok-az-adataihoz\/#datenbank\">Adatb\u00e1zis-hozz\u00e1f\u00e9r\u00e9s<\/a><\/nav><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>Adatb\u00e1zis-hozz\u00e1f\u00e9r\u00e9s<\/p><h1>SQL Server nem el\u00e9rhet\u0151: sikertelen kapcsolat<\/h1><p class=\"dq-lead\">A \u201enetwork-related or instance-specific error\u201d \u00fczenet els\u0151k\u00e9nt sikertelen kapcsolatot jelez. A 26-os, 40-es vagy 53-as hiba a c\u00e9l megtal\u00e1l\u00e1s\u00e1nak vagy el\u00e9r\u00e9s\u00e9nek probl\u00e9m\u00e1j\u00e1ra utalhat. A \u201eLogin failed\u201d ezzel szemben a bejelentkez\u00e9shez tartozik. A teljes \u00fczenet hat\u00e1rozza meg a k\u00f6vetkez\u0151 ellen\u0151rz\u00e9si l\u00e9p\u00e9st.<\/p><ol class=\"dq-help-flow\" aria-label=\"Adat\u00fat \u00e9s ellen\u0151rz\u00e9si pont\"><li><span>Forr\u00e1s<\/span><strong>Munka\u00e1llom\u00e1s vagy szolg\u00e1ltat\u00e1s<\/strong><\/li><li class=\"is-checkpoint\"><span>A kapcsolat ellen\u0151rz\u00e9se<\/span><strong>Kiszolg\u00e1l\u00f3 & P\u00e9ld\u00e1ny<\/strong><\/li><li><span>C\u00e9l<\/span><strong>Adatb\u00e1zis-kapcsolat<\/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>\u00cdgy jelenik meg a mindennapokban<\/h2><p>Az ERP elindul, de egy szervercsere ut\u00e1n nem \u00e9ri el az adatb\u00e1zis\u00e1t. M\u00e1s alkalmaz\u00e1sok m\u00e9g m\u0171k\u00f6dhetnek. Ez\u00e9rt nem \u00e1ltal\u00e1ban \u201ea h\u00e1l\u00f3zatot\u201d vizsg\u00e1ljuk, hanem ennek az alkalmaz\u00e1snak a kapcsolat\u00e1t a saj\u00e1t SQL Server-p\u00e9ld\u00e1ny\u00e1val.<\/p><\/section><section id=\"ursachen\"><h2>Tipikus okok elk\u00fcl\u00f6n\u00edt\u00e9se<\/h2><div class=\"dq-help-causes\"><div><h3>K\u00f6lt\u00f6z\u00e9s ut\u00e1n m\u00f3dosult c\u00e9l<\/h3><p>A kiszolg\u00e1l\u00f3n\u00e9v, p\u00e9ld\u00e1ny vagy kapcsolati c\u00edm m\u00e9g a r\u00e9gi k\u00f6rnyezetre mutathat.<\/p><\/div><div><h3>Elt\u00e9r\u0151 h\u00e1l\u00f3zati \u00fat<\/h3><p>A VPN, n\u00e9vfelold\u00e1s vagy enged\u00e9lyezett kapcsolat elt\u00e9rhet az iroda, a terepi munka \u00e9s a h\u00e1tt\u00e9rszolg\u00e1ltat\u00e1s k\u00f6z\u00f6tt.<\/p><\/div><div><h3>Bejelentkez\u00e9s vagy adatb\u00e1zis-hozz\u00e1rendel\u00e9s<\/h3><p>Ha a kiszolg\u00e1l\u00f3 el\u00e9rhet\u0151, a haszn\u00e1lt fi\u00f3k vagy a konkr\u00e9t adatb\u00e1zishoz val\u00f3 hozz\u00e1f\u00e9r\u00e9s okozhatja a k\u00f6vetkez\u0151 hib\u00e1t.<\/p><\/div><\/div><\/section><section id=\"pruefen\"><h2>Amit el\u0151sz\u00f6r ellen\u0151rizhet<\/h2><ol class=\"dq-help-checks\"><li><h3>\u00dczenet \u00e9s \u00e9rintett folyamat r\u00f6gz\u00edt\u00e9se<\/h3><p>Jegyezze fel a hibasz\u00e1mot, az id\u0151pontot \u00e9s azt, hogy minden vagy csak egyes munka\u00e1llom\u00e1sok \u00e9rintettek-e.<\/p><\/li><li><h3>Elv\u00e1rt c\u00e9l \u00f6sszehasonl\u00edt\u00e1sa<\/h3><p>Hasonl\u00edtsa \u00f6ssze a kiszolg\u00e1l\u00f3t \u00e9s p\u00e9ld\u00e1nyt a j\u00f3v\u00e1hagyott konfigur\u00e1ci\u00f3val vagy egy m\u0171k\u00f6d\u0151 munka\u00e1llom\u00e1ssal. Ne nyisson meg kital\u00e1lt portokat a t\u0171zfalon.<\/p><\/li><li><h3>Az utols\u00f3 v\u00e1ltoz\u00e1s k\u00f6r\u00fclhat\u00e1rol\u00e1sa<\/h3><p>Kiszolg\u00e1l\u00f3k\u00f6lt\u00f6z\u00e9s, VPN-csere, \u00faj fi\u00f3k vagy programfriss\u00edt\u00e9s t\u00f6rt\u00e9nt? A megl\u00e9v\u0151 napl\u00f3k seg\u00edtenek az \u00f6sszehasonl\u00edt\u00e1sban.<\/p><\/li><\/ol><\/section><section id=\"tiefer\"><h2>Ha m\u00e9lyebben van a probl\u00e9ma<\/h2><p>Egy m\u00e1sik eszk\u00f6zzel v\u00e9gzett sikeres kapcsol\u00f3d\u00e1s hasznos, de nem helyettes\u00edti a t\u00e9nyleges program \u00e9s fi\u00f3k tesztj\u00e9t. Elk\u00fcl\u00f6n\u00edtj\u00fck az el\u00e9rhet\u0151s\u00e9get, a bejelentkez\u00e9st, a jogosults\u00e1gokat \u00e9s az ezt k\u00f6vet\u0151 feldolgoz\u00e1st. \u00cdgy a jav\u00edt\u00e1s a megfelel\u0151 helyre ir\u00e1nyul.<\/p><div class=\"dq-help-details\"><details><summary>P\u00e9ld\u00e1ny, h\u00e1l\u00f3zat \u00e9s bejelentkez\u00e9s k\u00fcl\u00f6n ellen\u0151rz\u00e9se<\/summary><p>Egy n\u00e9vvel ell\u00e1tott SQL Server m\u00e1s kapcsolati param\u00e9tereket haszn\u00e1lhat, mint egy alap\u00e9rtelmezett p\u00e9ld\u00e1ny. A sz\u00fcks\u00e9ges konfigur\u00e1ci\u00f3nak a t\u00e9nyleges m\u0171k\u00f6d\u00e9sb\u0151l kell sz\u00e1rmaznia. Egy m\u00e1sik kiszolg\u00e1l\u00f3 l\u00e1tsz\u00f3lag megfelel\u0151 be\u00e1ll\u00edt\u00e1sa nem megb\u00edzhat\u00f3 kiindul\u00f3pont.<\/p><\/details><details><summary>Ha visszat\u00e9r a hiba<\/summary><p>R\u00f6gz\u00edtj\u00fck a c\u00e9lrendszert, a v\u00e9grehajt\u00f3 fi\u00f3kot, a felel\u0151s\u00f6ket \u00e9s az utols\u00f3 v\u00e1ltoz\u00e1sokat. Ha t\u00f6bb alkalmaz\u00e1s ugyanazt a kiszolg\u00e1l\u00f3t haszn\u00e1lja, f\u00fcgg\u0151s\u00e9geik l\u00e1that\u00f3v\u00e1 v\u00e1lnak. Ebb\u0151l ellen\u0151rz\u00f6tt migr\u00e1ci\u00f3 vagy stabil integr\u00e1ci\u00f3s hozz\u00e1f\u00e9r\u00e9s alakulhat ki.<\/p><\/details><\/div><\/section><section id=\"weiter\"><h2>Mikor hasznos a seg\u00edts\u00e9g<\/h2><p>Ha a kies\u00e9s t\u00f6bb programot \u00e9rint vagy k\u00f6lt\u00f6z\u00e9s ut\u00e1n tart\u00f3san visszat\u00e9r, \u00e9rdemes egy\u00fctt vizsg\u00e1lni az alkalmaz\u00e1st \u00e9s az infrastrukt\u00far\u00e1t. Az els\u0151 megbesz\u00e9l\u00e9shez el\u00e9g a hibasz\u00e1m \u00e9s az \u00e9rintett rendszerek le\u00edr\u00e1sa.<\/p><a class=\"dq-help-service\" href=\"https:\/\/hu.datenquelle.at\/index.php\/rendszerek-osszekapcsolasa\/\"><span>A megfelel\u0151 megold\u00e1s<\/span><strong>Megl\u00e9v\u0151 rendszerek k\u00f6z\u00f6tti kapcsolatok tiszt\u00e1z\u00e1sa<\/strong><span class=\"dq-ui-arrow\" aria-hidden=\"true\"><\/span><\/a><aside class=\"dq-help-cross\"><p>A szervermigr\u00e1ci\u00f3, VPN, h\u00e1l\u00f3zat \u00e9s folyamatos IT-t\u00e1mogat\u00e1s a DAXS infrastrukt\u00fara- \u00e9s \u00fczemeltet\u00e9si szakter\u00fclet\u00e9hez tartozik.<\/p><a href=\"https:\/\/daxs.com\/\" rel=\"noopener\">Tov\u00e1bbi inform\u00e1ci\u00f3k a DAXS-n\u00e1l<span class=\"dq-ui-external\" aria-hidden=\"true\"><\/span><\/a><\/aside><\/section><section class=\"dq-help-sources\"><h2>Forr\u00e1sok a m\u0171szaki eligaz\u00edt\u00e1shoz<\/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: H\u00e1l\u00f3zati \u00e9s p\u00e9ld\u00e1nyhib\u00e1k az SQL Servern\u00e9l<\/a><\/li><\/ul><p>Szakmailag ellen\u0151rizve: 2026. okt\u00f3ber 7. A gy\u00e1rt\u00f3i adatok az adott term\u00e9kekre vonatkoznak; nem helyettes\u00edtik az \u00d6n konkr\u00e9t konfigur\u00e1ci\u00f3j\u00e1nak ellen\u0151rz\u00e9s\u00e9t.<\/p><\/section><\/article><aside class=\"dq-help-toc\"><nav aria-label=\"Ezen a s\u00fag\u00f3oldalon\"><span class=\"dq-kicker\">Ezen az oldalon<\/span><a href=\"#ursachen\">Tipikus okok<\/a><a href=\"#pruefen\">Els\u0151 ellen\u0151rz\u00e9sek<\/a><a href=\"#tiefer\">M\u0171szaki \u00f6sszef\u00fcgg\u00e9sek<\/a><a href=\"#weiter\">Megfelel\u0151 megold\u00e1s<\/a><\/nav><div><span class=\"dq-kicker\">Kapcsol\u00f3d\u00f3 probl\u00e9m\u00e1k<\/span><a href=\"https:\/\/hu.datenquelle.at\/index.php\/adatbazis-hozzaferes-ssl-tanusitvanyhiba\/\">Adatb\u00e1zis-hozz\u00e1f\u00e9r\u00e9s: SSL-tan\u00fas\u00edtv\u00e1nyhiba<\/a><a href=\"https:\/\/hu.datenquelle.at\/index.php\/odbc-adatforras-nem-talalhato-im002\/\">ODBC-adatforr\u00e1s nem tal\u00e1lhat\u00f3 (IM002)<\/a><a href=\"https:\/\/hu.datenquelle.at\/index.php\/hibak-es-megoldasok-az-adataihoz\/\">Ugr\u00e1s a t\u00e9m\u00e1k \u00e1ttekint\u00e9s\u00e9hez<\/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>K\u00f6z\u00f6sen tiszt\u00e1zni a k\u00f6vetkez\u0151 l\u00e9p\u00e9st.<\/h2><p>Indul\u00e1sk\u00e9nt el\u00e9g a programok neve \u00e9s egy r\u00f6vid probl\u00e9male\u00edr\u00e1s.<\/p><\/div><a class=\"dq-button\" href=\"https:\/\/hu.datenquelle.at\/index.php\/adatproblema-megbeszelese\/\" aria-haspopup=\"dialog\" aria-controls=\"dq-booking-modal\" data-dq-booking>Els\u0151 megbesz\u00e9l\u00e9s egyeztet\u00e9se<\/a><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>SQL Server-kapcsolati hib\u00e1k \u00e9rtelmez\u00e9se h\u00e1l\u00f3zat-, kiszolg\u00e1l\u00f3- vagy programv\u00e1ltoz\u00e1sok ut\u00e1n. C\u00e9l, el\u00e9rhet\u0151s\u00e9g \u00e9s bejelentkez\u00e9s l\u00e9p\u00e9senk\u00e9nti elk\u00fcl\u00f6n\u00edt\u00e9se.<\/p>\n","protected":false},"author":2,"featured_media":828,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-790","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/comments?post=790"}],"version-history":[{"count":4,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/790\/revisions"}],"predecessor-version":[{"id":908,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/790\/revisions\/908"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media\/828"}],"wp:attachment":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media?parent=790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}