Yuav ua li cas ntxiv ib tus neeg siv rau SQL SQL database
SQL neeg rau zaub mov 2012 muab ntau hom kev ruaj ntseg uas tsim los tiv thaiv tsis pub leej twg paub, kev ntseeg, thiab muaj cov ntaub ntawv khaws tseg cia rau hauv koj cov ntaub ntawv ua lag luam. Ib qho tseem ceeb tshaj plaws uas cov thawj xibfwb ua tau yog qhov kev ua raws li txoj kev tswj xyuas uas txwv cov peev xwm ntawm cov neeg siv los nrhiav thiab kho cov ntaub ntawv hauv lub database tshwj tsis yog tias lawv muaj kev lag luam yuav tsum ua li ntawd. Qhov no yuav tsum tau qhia txog cov neeg siv los ntawm kev siv cov npe neeg siv.
SQL neeg rau zaub mov muab ob txoj kev los tsim database neeg siv nyiaj: Qhov tseeb ntawm Windows lossis hom sib xyaw, uas txhawb qhov rais authentication thiab SQL neeg authentication. Nyob rau hauv qhov rais authentication hom, koj muab tag nrho cov database permissions mus rau qhov rais nyiaj. Qhov no muaj qhov kom zoo ntawm kev muab ib qho kev kos npe-rau cov neeg siv thiab simplifying kev ruaj ntseg tswj. Hauv SQL neeg rau zaub mov (mixed hom) authentication, koj tuaj yeem tseem muab cai rau cov neeg siv qhov rais, tab sis koj tuaj yeem tsim cov nyiaj uas muaj nyob hauv cov ntsiab lus ntawm cov ntaub ntawv database.
Feem ntau hais lus, nws yog qhov zoo tshaj plaws los siv qhov kev pab tshawb qhov rais vim tias nws txo cov txheej ntawm qhov nyuaj hauv koj cheeb tsam. Los ntawm muaj ib qhov chaw ntawm cov neeg siv nyiaj, koj tuaj yeem ntseeg tias cov neeg uas tawm hauv lub koom haum no muaj kev tso cai tag nrho. Txawm li cas los xij, nws tsis yog ib txwm ua tau raws li tag nrho koj cov kev xav tau nrog tus account, ces koj yuav tsum tau ntxiv rau lawv cov nyiaj hauv zos tsim los ua haujlwm nrog SQL neeg rau zaub mov databases.
Tsim kom muaj SQL neeg rau zaub mov 2012 Account
Yog hais tias koj xav tau los ua SQL account tus account thaum siv hom hom authentication, ua raws li cov txheej txheem rau SQL tus neeg rau zaub mov 2012:
- Qhib SQL neeg rau zaub mov Management Studio.
- Txuas mus rau SQL neeg rau zaub mov database qhov twg koj xav tsim ib tus ID nkag mus.
- Qhib cov ntawv ceev xwm txheej.
- Txoj cai-nias rau ntawm Logins nplaub tshev thiab xaiv Tshiab ID nkag mus .
- Txhawm rau tso cai rau tus account hauv Windows, xaiv qhov kev tiv thaiv ntawm Windows . Los tsim ib qho nyiaj uas muaj tshwm sim nyob rau hauv cov database, xaiv SQL neeg rau zaub mov authentication .
- Muab lub npe nkag rau hauv lub thawv ntawv. Koj siv tau Xauj khawm los xaiv ib tus account uas twb muaj lawm yog tias koj xaiv qhov Windows authentication.
- Yog tias koj xaiv SQL neeg authentication, koj yuav tsum tau muab ib lo lus zais muaj zog hauv ob lub Password thiab Kev Pom Zoo cov thawv ntawv.
- Customize lub neej ntawd database thiab lus rau tus as khauj, yog tias xav tau, siv cov thawv ntawv hauv qab ntawm qhov rais.
- Nyem OK los tsim cov nyiaj.
Lub tswv yim rau Tsim SQL Server 2012 Accounts
Nov yog qee cov lus qhia koj yuav tsum ua raws li thaum tsim SQL Server 2012 neeg siv nyiaj:
- Nco ntsoov siv tus password tshiab yog tias koj tsim kom muaj SQL neeg rau npe nkag.
- Tshem tawm ib tus account uas twb muaj lawm (siv SQL authentication los yog qhov rais authentication), txoj cai-nias ntawm tus account hauv phau ntawv Logins , thiab xaiv Delete .
- Tsim ib tus as khauj tsis tsim database permissions . Cov kauj ruam tom ntej ntawm tus txheej txheem yog ntxiv cov kev tso cai rau tus account.
- SQL neeg rau zaub mov authentication yog muaj tsuas yog tias koj tau xaiv mixed hom authentication rau koj tus SQL neeg rau zaub mov.
- Xijpeem hom authentication koj siv, nco ntsoov tsim nyiaj thiab muab cob qhia cov neeg siv nrog kev saib xyuas. Kev ruaj ntseg tswj tsis yog qhov zoo tshaj plaws ntawm cov thawj tswj xyuas kev ua hauj lwm hauv database, tab sis nws yog ib qho uas koj xav kom tau txais txoj cai.
Lus cim: Tsab ntawv no siv rau SQL neeg rau zaub mov 2012. Yog tias koj tab tom siv tus txheejtxheem dhau SQL SQL 2008, cov txheej txheem yog tib yam, tab sis yuav tsum paub tias Microsoft tsis muaj kev txhawb rau SQL Server 2008 hauv 2014.