Shandisa Windows Authentication kana SQL Server Kutendeseka
SQL Server 2008 inopa nzira mbiri dzekusika database user user: Windows kuvimbisa uye SQL Server kuvimbiswa. MuWearning authentication mode, iwe unopa ma permissions ose epa database kuWindows account. Izvi zvinobatsira pakuratidza chiitiko chimwe chete-pane chiitiko kune vashandisi uye nyore nyore kuchengetedza. MuSQL Server (maitiro akavhenganiswa) kuvimbiswa, iwe unogona kugovera kodzero kune vashandisi veWindows, asi unogonawo kugadzira zvigaro zviripo chete mumamiriro ekuchengetedza database.
Nzira Yokuwedzera Nayo Akaunti yeDabhuku
- Vhura SQL Server Management Studio .
- Gungano kuSquL Server database apo iwe unoda kugadzira login.
- Vhura Security folder.
- Kanda -kona pane Login folder uye sarudza Chatinyore .
- Kana iwe uchida kugovera kodzero kune eWindows, sarudza Windows kuvimbiswa . Kana iwe uchida kugadzira kambani inowanikwa mu database chete, sarudza SQL Server kuvimbiswa .
- Ipa zita rekutarisa mumutauro webhokisi. Iwe unogona kushandisa bhatani reKutsvaga kuti usarudze kero iripo kana ukasarudza Windows kuvimbiswa.
- Kana ukasarudza SQL Server kuvimbiswa, unofanirwa kupawo shoko rakasimba mune zvose Password uye Confirmation text boxes.
- Ita zvinyorwa zvinyorwa zvisiri izvo uye mutauro wekambani, kana uchida, uchishandisa mabhokisi ekuderedza pasi pasi pehwindo.
- Dzvanya OK kuti uite iyo nhoroondo.
Mazano
- Iva nechokwadi chekushandisa izwi rakasimba kana urikusika SQL Server login.
- Kana iwe uchida kubvisa kero iripo (uchishandisa SQL Server kuvimbiswa kana Windows kuvimbiswa), chino-chengetedza pane account mu Login folder uye sarudza Futa.
- Kugadzira kambani hakuiti zvibvumirano zvepa database. Nhanho inotevera yegadziriro iyi ndeyokuwedzera mavhosi ku-akhawunti.
- SQL Server kuvimbiswa inowanikwa chete kana iwe wakasarudza kuenzanirana nemagetsi ekutenderera SQL Server yako.