Sebenzisa i-Windows Authentication okanye iSQL Server Ukuqinisekiswa
I-SQL Server 2008 inikeza iindlela ezimbini zokudala i-akhawunti yomsebenzisi wedatha: ukuqinisekiswa kwe-Windows kunye ne-SQL Server ukuqinisekiswa. Kwimo ye-Windows yoqinisekiso, unikezela zonke iimvume zeenkcukacha kwi-akhawunti ye-Windows. Oku kunenzuzo yokubonelela ngolwazi olulodwa kubasebenzisi kunye nokwenza lula ukulawula ukhuseleko. Kwi- SQL Server (imodeli edibeneyo) ukuqinisekiswa, unako ukunika amalungelo kubasebenzisi beWindows, kodwa unokwenza iakhawunti ezakho kuphela kumongo wesiphakeli sedatha.
Indlela yokongeza i-Akhawunti yedatha
- Vula i- SQL Server Management Studio .
- Xhuma kwi-SQL Server database apho ufuna ukwakha ukungena ngemvume.
- Vula ifolda yoKhuseleko .
- Chofoza ngakwesokudla kwifolda ye- Logins uze ukhethe Okungenayo .
- Ukuba ufuna ukunika amalungelo kwi-akhawunti ye-Windows, khetha uqinisekiso lwe-Windows . Ukuba ufuna ukudala i-akhawunti ekhoyo kwi database, khetha uqinisekiso lweSQL Server .
- Nika igama lokungena kwibhokisi yombhalo. Ungasebenzisa inkinobho ye- Browse ukukhetha i-akhawunti ekhoyo ukuba ukhetha ukuqinisekiswa kweWindows.
- Ukuba ukhethe ukuqinisekiswa kwe-SQL Server, kufuneka unikeze negama elichanekileyo kwiibhokisi zeNkcukacha zePhasiwedi kunye neNgcaciso .
- Yenza i-database engagqibekanga kunye nolwimi lwe-akhawunti, ukuba unqwenela, usebenzisa ibhokisi ehlayo phantsi kwefestile.
- Cofa u- OK ukudala i-akhawunti.
Iingcebiso
- Qinisekisa ukusebenzisa iphasiwedi eqinileyo xa udala ukungena ngemvume kweSQL Server.
- Ukuba ufuna ukususa i-akhawunti ekhoyo (usebenzisa iSiqinisekiso seSQL Server okanye ukuqinisekiswa kweWindows), nqakraza ngakwesokudla kwi-akhawunti kwiifolda ze-Logins uze ukhethe Susa.
- Ukudala i-akhawunti akuyi kudala iimvume zeenkcukacha. Isinyathelo esilandelayo senkqubo ukufaka iimvume kwi-akhawunti.
- Ukuqinisekiswa kweSQL Server kufumaneka kuphela xa ukhethe ukuqinisekiswa kwemodi edibeneyo kwimeko yakho yeSQL Server.