I-Excel iya ku-SQL Server yomlingani ngaphandle kokwethemba kwesizinda

Incwadi yokusebenza ye-Excel evula ithebula ku-SQL Server yenyu yesinye idinga izinto ezintathu okuvame ukukhulunywa ngazo njengento eyodwa: ubunikazi obamukelwa iseva, ukuthutha okuqinisekiswa iklayenti, kanye nomzila wenethiwekhi ovunyelwa yizinhlangothi zombili. Ukwethemba kwesizinda kuyindlela eyodwa yokwanelisa okokuqala, futhi kuyindlela ebanzi kunazo zonke. I-TLS yanelisa okwesibili futhi ayisho lutho ngokokuqala. Umzila wanelisa okwesithathu futhi awuvikeli lutho ngokwawo.

Ukwehlukanisa lezi zinto ezintathu kwenza ispredishithi ibe yisicelo esincane esingabuyekezwa esikhundleni sobudlelwano bezokuphatha.

Izinqumo ezintathu umbuzo ozifihlayo

Ubunikazi ngubani idathabhethi ecabanga ukuthi uyena: i-akhawunti ye-Windows evela esizindeni esithembekile, ukungena kwe-SQL ngokwephasiwedi yayo, noma ubunikazi obusekelwe kusitifiketi. Ukuthutha ukuthi ingabe iseshini ibethelwe futhi ingabe iklayenti ihlola uchungechunge lwesitifiketi seseva. Umzila ukuthi amaphakethe afinyelela kanjani kumlaleli, okungaba i-VPN, isixhumanisi sangasese noma iphuzu lokugcina lomphakathi elinemikhawulo yefayela lomlilo. Ngakunye kuhlala endaweni ehlukile futhi ngakunye kungahluleka ngokwakho.

Ukwethemba kwehlathi kuphendula okokuqala ngokubanzi futhi kuwubudlelwano phakathi kwezinhlangano, hhayi isilungiselelo sencwadi yokusebenza eyodwa. Futhi akubethelanga lutho, okuyamangaza labo ababecabanga ukuthi ukwethemba yikho ukulawula kokuphepha.

Ubunikazi ngaphandle kokwethemba kwehlathi

I-akhawunti elungiselelwe ngamabomu endaweni eqondiwe ingakwazi ukwanelisa imfuneko encane ngaphandle kokwethemba, inqobo nje uma uhlelo lokusebenza lweklayenti lungayisebenzisa. Ukuqinisekiswa kwe-SQL kungenye impendulo evamile lapho inqubomgomo ivuma: ukungena kuthwala umjikelezo wayo wokuphila kwemibhalo yobufakazi futhi akuhlanganyeli neziphinde futhi akukhiqizi ukuqinisekiswa okuhlanganisiwe kwe-Windows. Ubunikazi obusekelwe kusitifiketi noma kuthokheni iyindlela yesithathu ezinkundleni ezintsha. Noma yini oyikhethayo, nika kuphela izimvume zedathabhethi incwadi yokusebenza ewadinga ngempela.

Khetha i-akhawunti ezinikezelwe kunokungena komuntu siqu kothile. Imibhalo yobufakazi eyabiwe kusipredishithi iyinkinga yokusekelwa elindele ukwenzeka, futhi i-akhawunti enegama yenza kube nokwenzeka ukuhoxiswa lapho iphrojekthi iphela.

Ukubethela yebo, kodwa sithembe isitifiketi?

Nge-ODBC Driver 18, Encrypt=Yes;TrustServerCertificate=No icela iseshini ebethelwe esihlolwa ngempela isitifiketi sayo. I-string yokuxhumana kumele ibize iseva esihlanganiswa yisitifiketi, futhi iklayenti kumele ithembe uchungechunge lwayo. I-Driver 18 futhi ibethela ngokuzenzakalela, ngokungafani nezinguqulo zangaphambili, ngakho i-string endala yokuxhumana ingase manje ixoxisane nge-TLS ngaphandle kokusho. Izilungiselelo ezicacile zenza inqubomgomo ehlosiwe ibonakale kuyo yonke imishini, okubalulekile lapho abantu abaningi benakekela incwadi yokusebenza efanayo.

TrustServerCertificate=Yes iyabethela futhi yeqe ukuqinisekisa, okungeyona indlela yokulungisa elinganayo yokungafani kwegama noma uchungechunge olungathembekile. Isusa uphawu obeluzokutshela ukuthi iklayenti lifinyelele iphuzu lokugcina elingalungile, ngakho lungisa isitifiketi noma igama.

Ukuphoqelela ohlangothini lweseva kuwukulawula okuhlukile. Uma ukubethela kufanele kusebenze kuyo yonke iklayenti, lungiselela futhi uqinisekise isilungiselelo sokuphoqelela ukubethela seseva, ngoba i-string eyodwa yokuxhumana ebambisana ayiphoqeleli lutho.

Umzila wenethiwekhi awuwona ukuvikelwa

Umlaleli wangasese ofinyelelwa nge-VPN unciphisa ukuchayeka, futhi i-VPN kumele ithwale imizila efanele yendawo ekuyiwa kuyo neyokubuya ukuze lokho kusebenze. Ithambeka elisebenzayo alisusi isidingo sokuqinisekisa noma ukuqinisekiswa kwesitifiketi, futhi i-TLS ayikhawuleli ukuthi yiziphi izinhlelo ezikude ezingazama ukuxhumana. Lokhu kuyimibono emithathu ehlukene: ukuxhawulana kwe-TLS, ukungena kwe-VPN kanye nombuzo ogunyaziwe. Owesithathu kuphela ofakazayo ukuthi incwadi yokusebenza ifunde idatha eyayivunyelwe ukuyifunda.

Ngakho mela isinqamuleli sokuphendula umbuzo wokwethemba ngokudalula idathabhethi ku-inthanethi. Impendulo encane ivamise ukuba i-akhawunti ezinikezelwe, ukubethela okuqinisekisiwe kanye nomzila owodwa ogunyaziwe, ngokulandela lokho.

Qinisekisa ngohlelo olujwayelekile lwe-Excel: ubunikazi obamukelwe, izimvume ezisebenzayo kanye nokubethela okuxoxiwe ngakho, ngakunye ngokubuka kweseshini kweseva uqobo.