Ukukhetha indlela yokuqinisekisa ye-SQL Server

I-Microsoft SQL Server 2016 inikeza abaphathi izinqumo ezimbili zokusebenzisa indlela uhlelo oluzoqinisekisa ngayo abasebenzisi: Imodi yokuqinisekisa i-Windows noma imodi yokufakazela ubuqiniso.

Ukuqinisekiswa kweWindows kusho ukuthi iSQL Server iqinisekisa ubunikazi bomsebenzisi usebenzisa kuphela igama lomsebenzisi le-Windows nephasiwedi. Uma umsebenzisi esevele eqinisekisiwe uhlelo lwe-Windows, i-SQL Server ayifuni iphasiwedi.

Imodi exubile isho ukuthi iSQL Server inika kokubili ukuqinisekiswa kwe-Windows nokuqinisekiswa kwe-SQL Server. Ukuqinisekiswa kwe-SQL Server kudala umsebenzisi ukungena okungahambisani ne-Windows.

Ukusekela Okuyisisekelo

Ukuqinisekiswa yinqubo yokuqinisekisa umsebenzisi noma ikhompiyutha. Inqubo ngokuvamile iqukethe izinyathelo ezine:

  1. Umsebenzisi wenza isimangalo sobunikazi, ngokuvamile ngokunikeza igama lomsebenzisi.
  2. Isistimu inselele umsebenzisi ukufakazela ukuthi ungubani. Inselele evame kakhulu kuyisicelo sephasiwedi.
  3. Umsebenzisi uphendula enselele ngokunikeza ubufakazi obuceliwe, ngokuvamile iphasiwedi.
  4. Uhlelo luqinisekisa ukuthi umsebenzisi unikeze ubufakazi obamukelekayo, ngokwesibonelo, ukuhlola iphasiwedi ngokumelene nedatha yephasiwedi yendawo noma ukusebenzisa iseva yokugunyaza yangaphakathi.

Mayelana nengxoxo yethu ngezimpawu zokuqinisekisa ze-SQL Server, iphuzu elibucayi lisesiteji sesine ngenhla: iphuzu lapho uhlelo luqinisekisa ubufakazi bomsebenzisi bokuthi ungubani. Ukukhethwa kwemodi yokuqinisekisa kugunyaza ukuthi i-SQL Server iya kuphi ukuqinisekisa iphasiwedi yomsebenzisi.

Mayelana namamodeli wokuqinisekiswa kwe-SQL Server

Ake sihlole lezi zindlela ezimbili kancane kancane:

Imodi yokuqinisekisa ye-Windows idinga abasebenzisi ukuthi banikeze igama lomsebenzisi le-Windows elivumelekile ukuze bafinyelele kwisiphakeli sedatha. Uma le medi ikhethiwe, iSQL Server ikhubaza ukusebenza kwe-SQL Server-login ethize, futhi ubunikazi bomsebenzisi buqinisekisiwe kuphela nge-akhawunti yakhe ye-Windows. Le meya ngezinye izikhathi ibizwa ngokuthi ukuvikeleka okuhlanganisiwe ngenxa yokuxhomekeka kwe-SQL Server ku-Windows yokuqinisekiswa.

Imodi yokuqinisekiswa ehlanganisiwe ivumela ukusetshenziswa kwezingqinamba ze-Windows kepha iwafaka nge- akhawunti yendawo yomsebenzisi we-SQL Server ukuthi umlawuli udala futhi agcine ngaphakathi kwe-SQL Server. Igama lomsebenzisi nephasiwedi yomsebenzisi ligcinwe ku-SQL Server, futhi abasebenzisi kumele baphinde baqinisekiswe njalo uma bexhuma.

Ukukhetha indlela yokuqinisekisa

Isiphakamiso esihle kakhulu seMicrosoft ukusebenzisa imodi yokuqinisekisa iWindows noma nini lapho kungenzeka khona. Inzuzo eyinhloko ukuthi ukusebenzisa le meyi kukuvumela ukuthi uhlanganise ukuphathwa kwe-akhawunti yonke ibhizinisi lakho endaweni eyodwa: Active Directory. Lokhu kunciphisa kakhulu amathuba okuphutha noma ukubhekwa. Ngoba ubunikazi bomsebenzisi buqinisekiswa yi-Windows, i-Windows yomsebenzisi kanye nama-akhawunti weqembu angalungiswa ukungena ngemvume ku-SQL Server. Ngaphezu kwalokho, ukuqinisekiswa kwe-Windows isebenzisa ukubethela ukuze kuqinisekiswe abasebenzisi be-SQL Server.

Ukuqinisekiswa kwe-SQL Server, ngakolunye uhlangothi, kuvumela abasebenzisi bamagama namaphasiwedi ukuthi adluliselwe kuyo yonke inethiwekhi, okwenza bavikeleke kancane. Le medi ingaba yisinqumo esihle, noma kunjalo, uma abasebenzisi bexhumeka ezizindeni ezihlukene ezingezona ezithembekile noma uma kungenzeka izinhlelo zokusebenza ze-intanethi eziphephile zingasetshenziswa, njenge-ASP.NET.

Isibonelo, cabanga ngesimo lapho umlawuli wesigcinalwazi esithembekile eshiya inhlangano yakho ngemigomo engathandeki. Uma usebenzisa i-Windows yokuqinisekisa imodi, ukuphikisana nokufinyelela komsebenzisi kwenzeka ngokuzenzakalelayo uma ukhubaza noma ususa i-akhawunti ye-Active Directory ye-DBA.

Uma usebenzisa imodi yokugunyaza ehlanganisiwe, akudingeki nje ukuthi ukhubaze i-akhawunti ye-Windows ye-DBA, kodwa futhi udinga ukunqoba ngokusebenzisa uhlu lwabasebenzisi bendawo kuseva ngayinye yedatha ukuqinisekisa ukuthi akukho ma-akhawunti wendawo okukhona lapho i-DBA ingazi khona iphasiwedi. Lona umsebenzi omningi!

Ngokufingqa, imodi oyikhethayo ithinta kokubili izinga lokuphepha futhi kulula ukugcinwa kolwazi lwakho lwenhlangano.