Gwiritsani ntchito Windows Authentication kapena SQL Server Kuvomerezeka
SQL Server 2008 imapereka njira ziwiri zogwiritsira ntchito makasitomala ogwiritsa ntchito malo osungirako: Windows kutsimikiziridwa ndi SQL Server kutsimikiziridwa. Mu Windows mawonekedwe ovomerezeka, mumapereka mavoti onse achinsinsi ku akaunti za Windows. Izi zili ndi ubwino wopereka chithunzi chokhazikika kwa ogwiritsa ntchito ndi kuchepetsa kukonza chitetezo. Mu SQL Server (mawonekedwe osakanikirana) kutsimikiziridwa, mutha kupereka mwayi kwa ogwiritsa ntchito Windows, koma mungathe kukhazikitsa akaunti zomwe zilipo mndandanda wa seva.
Mmene Mungapangire Akaunti ya Database
- Tsegulani SQL Server Management Studio .
- Gwiritsani ntchito deta ya SQL Server pamene mukufuna kulumikiza.
- Tsegulani foda yamtendere.
- Dinani kumene pa tsamba la Logins ndikusankha Chatsopano.
- Ngati mukufuna kupereka ufulu pa akaunti ya Windows, sankhani mawonekedwe a Windows . Ngati mukufuna kupanga akaunti yomwe ilipo mu database, sankhani kutsimikizira SQL Server .
- Perekani dzina lolowetsamo mu bokosi lolemba. Mungagwiritse ntchito botani Yoyang'ana kusankha akaunti yomwe ilipo ngati mutasankha mawonekedwe a Windows.
- Ngati munasankha kutsimikiziridwa kwa SQL Server, muyeneranso kupereka chinsinsi champhamvu m'mawonekedwe achinsinsi ndi Ovomerezeka .
- Sungani makaunti osasinthika ndi chinenero cha akaunti, ngati mukufuna, pogwiritsa ntchito bokosi lakutsikira pansi pazenera.
- Dinani OK kuti mupange akaunti.
Malangizo
- Onetsetsani kuti mugwiritse ntchito mawu achinsinsi ngati mukulenga lolowera SQL Server.
- Ngati mukufuna kuchotsa akaunti yomwe ilipo (pogwiritsira ntchito kutsimikiziridwa kwa SQL Server kapena kutsimikiziridwa kwa Windows), dinani pomwepa pa akaunti mu Logins folder ndipo sankhani Chotsani.
- Kukhazikitsa akaunti sikupanga zilolezo zachinsinsi. Gawo lotsatira la ndondomekoyi ndi kuwonjezera zilolezo ku akaunti.
- Kuvomerezeka kwa SQL Server kumapezeka pokhapokha ngati mwasankha zovomerezeka zowonjezera pa SQL Server chitsanzo.