Cha, iyunithi yokuxhumana ayikwazi ukuqala umhubhe wakho we-VPN

Onjiniyela basaqhubeka nokufuna indawo lapho iyunithi yokuxhumana, i-JDBC URL noma umugqa ku-tnsnames.ora ikhetha i-VPN. Leyo ndawo ayikho. Umhubhe wakhiwa uhlelo lokusebenza noma iklayenti lomhlinzeki elibhalisa i-adaptha ebonakalayo, futhi yonke ilabhulali yesizindalwazi engaphezulu kwayo isebenzisa ungqimba lwesokhethi oluvelayo. Iyunithi yokuxhumana isho i-host, i-port kanye nobufakazi, futhi yilokho kuphela isilulumagama.

Inganekwane: iyunithi yokuxhumana ingakhetha umhubhe

Umshayeli uvula isokhethi ye-TCP ku-host naku-port. Akanayo i-API yokuphakamisa umhubhe, akanayo inkambu yephrofayili yomhubhe, futhi akanayo indlela yokuqinisekisa kusango le-VPN.

Yingakho amathuluzi aziphatha ngokufanayo uma umzila usukhona. I-SSMS, i-DBeaver, i-Eclipse Data Tools ne-sqlcmd evamile zenza sengathi iseva isekunethiwekhi yasendaweni, ngoba ngokombono wesokhethi injalo. I-adaptha ebonakalayo yenza i-subnet yesizindalwazi ifinyeleleke, futhi umshayeli akakwazi ukuthi kwenzeka kanjani.

Lokhu futhi kuchaza ukuthi kungani iyunithi yokuxhumana ingakwazi ukulungisa umhubhe owile. Uma isixhumanisi sifa, umshayeli ubika isikhathi siphelile noma iphutha elijwayelekile lenethiwekhi, futhi ikhodi yohlelo elithatha lokho njengenkinga yombuzo iphinda ungqimba olungalungile unomphela.

Phakamisa umhubhe ngaphambi kokuthi umshayeli usebenze

Xhuma i-VPN ezingeni lohlelo lokusebenza, ulandela imiyalelo yomhlinzeki noma yethimba lenethiwekhi, bese uvula ithuluzi. Ngokomkhuba lokho kusho ukuthi umzila oya ku-subnet yesizindalwazi ukhona ngaphambi kokuthi umshayeli uxazulule igama le-host.

Gcina ukugadwa komhubhe ngaphandle kohlelo. Isevisi ye-PHP noma ye-Java ezama ukuziphakamisela isixhumanisi ngokwayo ifaka ukuziphatha komhlinzeki oyedwa kukhodi yebhizinisi, futhi konke ukushintshwa kokwehluleka kuba ukukhishwa kohlelo. Umbheki ophethe umhubhe, owugadayo futhi owuqalayo kabusha uyindaba ehlukile emzileni wombuzo.

Hlola umzila ngaphambi kokusola umshayeli: uma i-host ingaxazululeki noma i-port ingaphenduli kusuka ku-shell, awekho iyunithi yokuxhumana ezoshintsha lokho.

Inganekwane: ukwehluleka kokuqinisekisa kwe-Windows kusho ukuthi umzila uphukile

Ukuqinisekisa kwe-Windows nge-VPN kuvame ukwehluleka ngephutha elibonakala njengokuphazamiseka kwenethiwekhi, kuyilapho umzila ulungile. Uma i-akhawunti ingeyesinye isizinda futhi ikhompyutha ephathekayo ingakwazi ukujoyina, qala iklayenti ngobufakazi obucacile esikhundleni sobunikazi besikhathi sedeskithophu.

runas /noprofile /netonly /user:CORP\dbreader "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

Isishintshi se-/netonly sigcina lobo bufakazi kuphela ekuqinisekiseni okukude. Qinisekisa ukuthi iseva ithole ini ngempela nge-SELECT SUSER_SNAME() esikhundleni sokwethemba ingxoxo yokuxhuma. Kubikwa ukuthi ukugcina ubufakazi bekheli leseva ku-Windows Credential Manager kuyasebenza ku-SSMS kodwa hhayi njalo kwisevisi esebenza ngaphansi kwenye i-akhawunti, ngakho hlola ukuthi inqubo isebenzisa ubuphi ubunikazi ngaphambi kokushintsha ukungena.

Ukubambezeleka kuguqula isikhombisi saseceleni kweseva sibe isikhathi esiphelile

Isikhombisi saseceleni kweseva sicela isizindalwazi ukuthi sigcine umphumela futhi siwulethe kancane kancane, lokho kuguqula umphumela omkhulu ube ukuhamba nokubuya okuncane okuningi. Ku-LAN lokho kushibhile. Ngomhubhe onezinguquko eziyishumi zemiliyisekhondi zokubambezeleka okwengeziwe, umbuzo ofanayo ungadlula isikhathi somyalelo ngaphandle kokudlulisa idatha eningi.

Shintshela kusikhombisi saseceleni komklayenti, noma khulisa usayizi wokulanda futhi uhlanganise imigqa ngamaqembu, futhi inani lokuhamba nokubuya liyancipha. Umgoqo yinani lokushintshana, hhayi ijubane legama lesixhumanisi, ngakho ukukala ukudlula kuzokudukisa kuyilapho ukukala ukuhamba nokubuya kungakudubisi. Hlola ngesethi enkulu yemiphumela abasebenzisi bakho abayidonsayo ngempela, hhayi ngombuzo womugqa owodwa obuya ngokushesha. Uma isikhathi siphela sisuka kodwa singanyamalali, khulisa kanyekanye isikhathi somyalelo nosayizi wokulanda bese ukala futhi.

Izibalo ezifanayo ziyasebenza kuma-ORM akhulumayo nakuwo wonke umklayenti okhipha isitatimende esisodwa ngomugqa. Uma uhlelo lombuzo lulungile futhi ukudluliswa kukuncane, bala ukushintshana kwenethiwekhi ngaphambi kokulungisa isizindalwazi.

Hlola i-port, i-instance kanye nesihlungi sasendaweni

I-instance enegama ilalela ku-port eguqukayo, ngakho qinisekisa i-port esikhundleni sokucabanga ukuthi ngu-1433. Ku-instance ezenzakalelayo inani lingafundwa kunani lokubhalisa le-TcpPort ngaphansi kokhiye we-SuperSocketNetLib wale instance. Nge-Oracle, qinisekisa ukuthi i-host ku-tnsnames.ora iyaxazululeka, ikheli liyaphendula futhi i-port yomlaleli ivunyelwe; u-1521 uyizingozele ejwayelekile, akusona isiqinisekiso.

Bese ukhipha uhlu lokufinyelela lombhubhe uqobo futhi, ekugcineni, i-antivirus yasendaweni noma i-firewall ye-host evimba ukuxhumana ngisho nomklayenti neseseva kuyimishini eyodwa. Rekhoda isigaba esihlulekayo ngaphambi kokushintsha ukumiswa, ngoba ukuxazululwa kwamagama, ukufinyeleleka kwe-TCP kanye ne-TLS noma ukungena kwehluleka ngayinye ngomlayezo ohlukile.

Bhala isigaba ethikithini. Uma kungenjalo umuntu olandelayo uzophinda aseshe iyunithi yokuxhumana efanayo eyaqala konke.