I-SQL nge-VPN: iklayenti eliqondile noma isiteshi somsebenzi sangaphakathi?

Amathimba afuna i-SSMS kumakhompyutha awo aphathwayo, futhi isisombululo esisheshayo ukushicilela imbobo ye-SQL echibini le-VPN. Impendulo ehamba kancane ibuza ukuthi inqubo yeklayenti kufanele isebenze kuphi, ngoba ukufinyelela okuqondile kanye nesiteshi somsebenzi sangaphakathi kukhiqiza amakheli omthombo ahlukene, ukuthembela kwendawo yokuphela kanye nezindlela zedatha ezihlukene. Akukho kokubili okuphephile ngokuzenzekelayo, futhi ubulungu be-VPN bodwa abunqumi lutho. Qhathanisa imiklamo ngaphambi kokuba kube khona umthetho wemvume.

Izindlela ezimbili, amakheli amabili omthombo

Ekufinyeleleni okuqondile ikhompyutha ephathwayo ithwala ukulungiselelwa kweklayenti futhi izivulela ngokwayo ukuxhumana kwedathabheyisi. Esiteshini somsebenzi esikude ikhompyutha ephathwayo ivula isikhathi sedeskithophu, futhi isiteshi somsebenzi senza ukuxhumana kwe-SQL kusukela ekhelini laso. Ngakho-ke idathabheyisi ibona ichibi le-VPN noma isango elihunyushiwe kumklamo wokuqala, kanye nekheli lesiteshi somsebenzi kowesibili. Lowo mehluko unquma ukuthi imuphi umthetho we-firewall kanye naluphi ulwazi lwe-SQL olusebenza ngempela.

Ikhompyutha ephathwayo isalawula isikhathi esikude, ngakho-ke isiteshi somsebenzi asithathi indawo yokuqinisekisa umsebenzisi noma inqubomgomo yesikhathi.

Hlola lokho idathabheyisi ekubonayo ngempela

Ikheli lomthombo yinto okufanele ilinganiswe, hhayi ukuqagelwa kumdwebo. Lifunde ohlangothini lweseva lokuxhumana okusebenzayo.

Test-NetConnection sql.example.com -Port 1433
sqlcmd -S tcp:sql.example.com,1433 -N -d appdb -Q "select SUSER_SNAME() as login_name, DB_NAME() as db"

Ukuhlolwa kokuxhumana kufakazela ukuthi umlaleli wamukela i-TCP kuleyo nethiwekhi, kuyilapho umbuzo ufakazela ukuthi isikhathi safinyelela kuphi ukungena nakuphi idathabheyisi. Ukuze ubone ikheli elirekhodwe yiseva, buza sys.dm_exec_connections esikhathini samanje, okubuyisela ikheli leklayenti ngemva kwanoma yikuphi ukuhunyushwa. Uma lelo nani liyisango hhayi ikhompyutha ephathwayo, umthetho womsingathi ngomsebenzisi ngamunye awukwazi ukusebenza kumshini wedathabheyisi. Bhala inani elibonakele eceleni komklamo okhethiwe, ngoba ukuxhumana kabusha nezinguquko zechibi kuyilihambisa.

Vula umlaleli futhi akukho okunye

Vula kuphela isevisi edingwa ukusetshenziswa. I-1433 eyaziwayo iyimbobo yesimo esizenzakalelayo, hhayi inguquko yomhlaba wonke.

Get-NetTCPConnection -State Listen -LocalPort 1433

Izimo ezinamagama zivame ukulalela embotsheni eguquguqukayo, i-SQL Server Browser iphendula ukutholakala ku-UDP 1434, futhi lokho kuncika kuwukuchayeka okuhlukile okufanele kuthethekeliswe. Ukubophela imbobo engaguquki esimweni kususa isidingo se-Browser futhi kwenza imithetho ye-firewall izinze. Gcina ukuhlolwa kokubethela nesitifiketi osekuvele kwenziwa yiklayenti esikhundleni kokukucisha ukuze ukuhlolwa kuphumelele. Bese unikeza izindima zedathabheyisi zomthwalo womsebenzi esikhundleni sokwengeza lonke iqembu le-VPN endimeni yeseva.

Fakazela indlela evunyelwe kanye nengavunyelwe

Vula isikhathi esisha njengomsebenzisi ojwayelekile ogunyaziwe, futhi qinisekisa ubunikazi beseva, idathabheyisi kanye nokusebenza okudingekayo. Bese uqinisekisa ukukhishwa: umthombo noma i-akhawunti engaphandle kwenqubomgomo kufanele yehluleke ekuhlolweni okufanayo. Kumklamo wesiteshi somsebenzi, qinisekisa ukuthi ikhompyutha ephathwayo ayikwazi ukweqa umngcele ngokufinyelela idathabheyisi ngokuqondile. Ekufinyeleleni okuqondile, qinisekisa ukuthi umzila nomthetho womthombo kusasebenza ngemva kokuxhumana kabusha.

Rekhoda ukuthi iklayenti lisebenze kuphi, imuphi umthombo idathabheyisi ewubonile kanye nomthetho okuvumile. Lobo ubufakazi obuzocelwa ukubuyekezwa okulandelayo.