Microsoft SQL Server 2016 inopa vatungamiri mazvisarudzo maviri ekushandisa nzira iyo hurongwa huchavimbisa vashandisi: Windows verification mode kana mode yakavhiringidzika.
Windows authentication zvinoreva kuti SQL Server inosimbisa ushumiri hwomunhu achishandisa chete zita rake reWindows nephasiwedi. Kana mushumiri atovimbiswa neWindows system, SQL Server haina kukumbira password.
Mixed mode inoreva kuti SQL Server inobatsira zvose maWindows authentication uye SQL Server kuvimbiswa. SQL Server kuvimbiswa kunogadzira user logins isina chokuita neWindows.
Kutendeseka Basics
Kutendeseka ndiyo nzira yekusimbisa musikana kana kuti kombiyuta. Nzira yacho inowanzo ine nhanho ina:
- Mushandisi anoita chirevo chekuzivikanwa, kazhinji nekupa zita rekushandisa.
- Izvo sangano rinoshungurudza mushumiri kuratidza kuti ndiani. Dambudziko rinowanzozivikanwa ndekukumbira kwephasiwedi.
- Mushandisi anopindura dambudziko kuburikidza nekupa uchapupu hwakakumbirwa, kazhinji password.
- Icho chinosimbisa kuti mushandisi akapa hupupuriro hunogamuchirwa, semuenzaniso, kutarisa pasi password kune database yepasiwedi kana kushandisa centralized authentication server.
Nokuda kwekukurukurirana kweSQL Server kuvimbisa nzira, chinonyanya kukosha chiri mudanho rechina pamusoro apa: pfungwa iyo iyo inoongorora hutano hwomunhu hwehuzivi. Chisarudzo chekodzero yekugadzirisa chinotarisa kuti SQL Server inosvika kupi kuongorora pasi password.
Pamusoro peSQL Server Kuvimbiswa Madziro
Ngationgororei miviri miviri zvishoma zvakare:
Windows authentication mode inoda vashandisi kupa vhesi yeWindows yakakodzera uye password kuti iwane server ye database. Kana iyi nzira yakasarudzwa, SQL Server inodzivisa SQL Server-specific login functionality, uye unhu hunoshandiswa nemunhu hunosimbiswa chete kuburikidza neavo yeWindows. Iyi nzira dzimwe nguva inonzi inoshandiswa kuchengetedzwa nekuda kwekuchengetedzwa kweSQL Server paWindows kwekuvimbiswa.
Mixed authentication mode inobvumira kushandiswa kwezviyeuchidzo zveWindows asi inowedzera neavo vemuSquL Server user accounts iyo mutungamiri anosika uye anochengetedza mukati meSQL Server. Zita remushandisi nephasiwedi yomunhu wese zviri zviviri zvakachengetwa muSQL Server, uye vashandi vanofanira kubvumidzwa zvakare nguva dzose pavanosangana.
Kusarudza Chiratidzo Chekutendesa
Nzira yakanakisisa yeMicrosoft yekukurudzira ndeyokushandisa Windows kuvimbiswa mode kana zvichibvira. Chinobatsiro chikuru ndechekuti kushandiswa kwemamiriro aya kunokubvumira kuisa kuwandisa kwekambani yekufambisa kwebasa rako rose munzvimbo imwechete: Active Directory. Izvi zvinoshamisa kuderedza mikana yekukanganisa kana kutarisira. Nemhaka yokuti unhu hunoshandiswa nemushandisi hunosimbiswa neWindows, zvakananga Windows user uye maakaunti eboka zvinogona kugadzirirwa kupinda muSQL Server. Zvakare, Windows kuvimbiswa inoshandisa kuvharidzira kwekutendesa vashandisi veSQL Server.
SQL Server kuvimbiswa, kune rumwe rutivi, inobvumira mazita emasikati nemapepwords kuti apararire mukati memutambo, achiita kuti vasanyanya kuchengeteka. Iyi nzira inogona kuva sarudzo yakanaka, zvisinei, kana vashandisi vachibatanidza kubva kune dzimwe nzvimbo dzisina kuvimbwa nadzo kana kana zvichida zvidzidzo zvisiri pasi zvakachengeteka zviri kushandiswa, zvakadai sa ASP.NET.
Semuenzaniso, funga mamiriro ezvinhu umo mutongi wekuchengetedzwa kwemashoko anovimba nesangano rako nemashoko asina kunaka. Kana ukashandisa Windows authentication mode, kubvumira kuti kushandiswa kwemushandisi kunoitika kamwe chete paunodzima kana kubvisa DBA Active Active account.
Kana ukashandisa kuvimbiswa kwevimbiso yemafungiro, iwe haufaniri kuvhara DBA yeWindows account, asi iwe unofanirwa kuvhara kuburikidza nemunharaunda yevashandisi mazita pane imwe nheyo ye database kuti uone kuti hapana maakare ega aripo umo DBA inogona kuziva password. Ndiyo basa rakawanda!
Mukupfupisa, nzira yaunosarudza inokanganisa zvose zvehutano hwekuchengeteka uye nyore kwekuchengetedza zvinyorwa zvemasangano ako.