Sebenzisa i-Windows Authentication noma i-SQL Server Ukuqinisekisa
I-SQL Server 2008 inikeza izindlela ezimbili zokudala ama-akhawunti womsebenzisi wedatha: ukuqinisekiswa kwe-Windows nokuqinisekiswa kwe-SQL Server. Kumodi yokuqinisekisa ye-Windows, ubela zonke izimvume ze-database kuma-akhawunti we-Windows. Lokhu kunenzuzo yokunikeza isipiliyoni esisodwa sokungena ngemvume kubasebenzisi nokululaza ukuphathwa kokuphepha. Ku- SQL Server (imodi exubile) ukuqinisekiswa, usengabela amalungelo kubasebenzisi be-Windows, kodwa ungakha futhi ama-akhawunti akhona kuphela kwisimo sevava yedatha.
Ungeza kanjani i-Akhawunti yedatha
- Vula SQL Server Management Studio .
- Xhuma kwi-SQL Server database lapho ufuna ukwakha ukungena ngemvume.
- Vula ifolda yezokuphepha .
- Chofoza ngakwesokudla kwifolda ye- Logins bese ukhetha Ukungena Okusha.
- Uma ufuna ukwabela amalungelo ku-akhawunti ye-Windows, khetha ukuqinisekiswa kwe-Windows . Uma ufuna ukwakha i-akhawunti ekhona kuphela ku-database, khetha ukuqinisekiswa kwe-SQL Server .
- Nikeza igama login ebhokisini lombhalo. Ungasebenzisa inkinobho yokudlulisa amehlo ukuze ukhethe i-akhawunti ekhona uma ukhetha u-Windows ukuqinisekiswa.
- Uma ukhethe ukuqinisekiswa kwe-SQL Server, kufanele unikeze iphasiwedi eqinile kokubili amabhokisi wephasiwedi ne- Confirmation .
- Yenza ngokwezifiso ulwazi oluzenzakalelayo nolwazi lwe-akhawunti, uma lufisa, usebenzisa amabhokisi ahlaselwa ngaphansi kwefasitela.
- Chofoza OK ukudala i-akhawunti.
Amathiphu
- Qinisekisa ukusebenzisa iphasiwedi eqinile uma udala ukungena ngemvume kwe-SQL Server.
- Uma ufuna ukususa i-akhawunti ekhona (usebenzisa ukuqinisekiswa kwe-SQL Server noma ukuqinisekiswa kwe-Windows), chofoza ngakwesokudla ku-akhawunti kuFolda ifolda bese ukhetha Susa.
- Ukudala i-akhawunti akudala izimvume zesisekelo sedatha. Isinyathelo esilandelayo senqubo ukwengeza izimvume ku-akhawunti.
- Ukuqinisekiswa kwe-SQL Server kuyatholakala kuphela uma ukhethe ukuqinisekiswa kwemodi exubile kwesibonelo sakho se-SQL Server.