I-Microsoft SQL Server 2016 inikezela ngabalawuli ababini ukhetho lokuphumeza indlela inkqubo yokuqinisekisa ngayo abasebenzisi: Imodi yokuqinisekiswa kweWindows okanye imodeli yokuqinisekisiweyo yokuxutywa.
Ukuqinisekiswa kweWindows kuthetha ukuba iSQL Server iqinisekisa ubunikazi bomsebenzisi usebenzisa kuphela igama lomsebenzisi kunye nephasiwedi yakhe. Ukuba umsebenzisi sele uqinisekisiwe yinkqubo yeWindows, iSQL Server ayifuni iphasiwedi.
Imodeli edibeneyo ithetha ukuba i-SQL Server inika zombini ukuqinisekiswa kwe-Windows kunye ne-SQL Server. Ukuqinisekiswa kwe-SQL Server kudala umsebenzisi ongena kwi-Windows.
Isiseko soBungqina
Ukuqinisekiswa yinkqubo yokuqinisekisa umsebenzisi okanye ubunikazi besazisi. Inkqubo ngokuqhelekileyo iqukethe amanyathelo amane:
- Umsebenzisi wenza ibango yesazisi, ngokuqhelekileyo ngokubonelela igama lomsebenzisi.
- Inkqubo inomngeni umsebenzisi ukufakazela ubungqina bakhe. Umngeni onzima kakhulu ngumyalelo wephasiwedi.
- Umsebenzisi uphendula kumngeni ngokubonelela ubungqina obuceliwe, ngokuqhelekileyo iphasiwedi.
- Inkqubo iqinisekisa ukuba umsebenzisi unikezele ubungqina obamkelekileyo, umzekelo, ukukhangela iphasiwedi ngokubhekiselele kwisiseko sephasiwedi yangasese okanye usebenzisa iseva yokuqinisekisiweyo yangaphakathi.
Ukuxubusha kwethu ngeendlela zokuqinisekiswa kwe-SQL Server, ingongoma ebalulekileyo kwisinyathelo sesine ngasentla: ingongoma apho inkqubo iqinisekisa ubungqina bokubazisi. Ukhetho lwemodi yokuqinisekisa luchaza apho i- SQL Server iya khona ukuqinisekisa iphasiwedi yomsebenzisi.
Mayelana neModyuli yokuQinisekisa yeSQL Server
Makhe sihlolisise le ndlela emibini ngokuqhubekayo:
Imodi yokuqinisekiswa yeWindows ifuna abasebenzisi ukubonelela igama lomsebenzisi we-Windows kunye nephasiwedi ukufikelela kumncedisi wesiseko sedatha. Ukuba le ndlela ikhethiweyo, i-SQL Server ikhubaza ukusebenza kwe-SQL Server-log-specific, kwaye ubunikazi bomsebenzisi buqinisekiswe kuphela kwi-akhawunti yakhe ye-Windows. Ngamanye amaxesha imimoya ibizwa ngokuba yokhuseleko oluhlangeneyo ngenxa yokuxhomekeka kweSQL Server kwi-Windows yokuqinisekiswa.
Imodeli yokuqinisekisiweyo edibeneyo ivumela ukusetyenziswa kweenkcukacha ze-Windows kodwa izongezelela ngeakhawunti yomsebenzisi waseSQL Server ukuba umlawuli udale kwaye agcine ngaphakathi kwi-SQL Server. Igama lomsebenzisi kunye nephasiwedi zombini zigcinwe kwi-SQL Server, kwaye abasebenzisi kufuneka baqinisekiswe kwakhona xa bexhuma.
Ukukhetha Imodi Yokuqinisekisa
Isiphakamiso esihle kakhulu seMicrosoft ukusetyenziswa kwimodi yokugunyaza yeWindows xa kunokwenzeka. Inzuzo eyintloko kukuba ukusebenzisa le mode kukuvumela ukuba ugxininise ukulawulwa kweakhawunti yakho kweshishini elilodwa: I-Active Directory. Oku kunciphisa kakhulu amathuba okuphambuka okanye ukujonga. Ngenxa yokuba ubunikazi bomsebenzisi buqinisekiswa yiWindows, umsebenzisi othile we-Windows kunye neakhawunti yeqela angalungiswa ukuba angene kwiSQL Server. Ukuqhubela phambili, i-Windows authentication isebenzisa ukubethela ukuqinisekisa abasebenzisi beSQL Server.
Ukuqinisekiswa kwe-SQL Server, ngakolunye uhlangothi, kuvumela amagama abasebenzisi kunye namaphasiwedi ukuba adluliselwe kuyo yonxibelelwano, okwenza bavikeleke kakhulu. Le ndlela ingaba yinto efanelekileyo, nangona kunjalo, ukuba abasebenzisi baxhuma kwiimimandla ezahlukileyo ezingaxhomekiyo okanye xa kunokwenzeka ukuba izicelo ezisetyenziswayo ze-Intanethi zingasetyenziswanga, njenge-ASP.NET.
Ngokomzekelo, cinga imeko apho umlawuli wesiseko sedata esithembekileyo eshiya intlangano yakho kwimimiselo engathandekiyo. Ukuba usebenzisa i-Windows mode yokuqinisekisa, ukuphikisa ukuba ukufikelela komsebenzisi kwenzeka ngokuzenzekelayo xa ukhubaza okanye ususe i-akhawunti ye-Active Directory ye-DBA.
Ukuba usebenzisa imodyuli yokuxhaswa kwemimandla, awufunanga kuphela ukukhubaza i-akhawunti ye-Windows ye-DBA, kodwa kufuneka udibanise uluhlu lwabasebenzisi basekuhlaleni kwi-server yonxibelelwano nganye ukuqinisekisa ukuba akukho iakhawunti yendawo apho i-DBA ingazi khona iphasiwedi. Lo msebenzi omningi!
Isishwankathelo, imo oyikhethayo ichaphazela zombini inqanaba lokhuseleko kunye nokulula kokugcinwa kweenkcukacha zoluntu.