Siv Windows Qhov Chaw Taw Qhia Tawm lossis Cov Ntawv Cim ID SQL (SQL Server Authentication)
SQL Server 2008 muab ob txoj kev rau kev tsim database neeg siv nyiaj: 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 dua yog muab ib qho kev kos npe-rau cov neeg siv thiab simpligating kev tswj kev ruaj ntseg. Hauv SQL neeg rau zaub mov (mixed hom) authentication, koj tuaj yeem tseem muab cai rau cov neeg siv qhov rais, tiam sis koj tuaj yeem tsim cov nyiaj uas muaj nyob hauv cov ntsiab lus teb ntawm cov ntaub ntawv database.
Yuav ua li cas ntxiv ib tus account Database
- 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 .
- Yog tias koj xav muab txoj cai rau lub account hauv Windows, xaiv qhov Windows authentication . Yog tias koj xav tsim ib qho nyiaj uas muaj tshwm sim nyob rau hauv database, xaiv SQL neeg rau zaub mov authentication .
- Muab lub npe nkag rau hauv lub thawv ntawv. Koj tuaj yeem siv lub Xauj khawm kom 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
- Nco ntsoov siv tus password tshiab yog tias koj tsim kom muaj SQL neeg rau npe nkag.
- Yog tias koj xav kom tshem tawm ib tus account uas twb muaj lawm (siv SQL authentication los yog qhov rais authentication), txoj cai-nias rau ntawm tus account hauv cov nplaub tshev 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 tsuas muaj yog tias koj tau xaiv mixed hom authentication rau koj tus SQL neeg rau zaub mov.