Indlela yokwengeza umsebenzisi kwi-SQL Server database
I-SQL Server 2012 inikeza izici eziningi zokuphepha ezihloselwe ukuvikela imfihlo, ubuqotho, nokutholakala kolwazi olugcinwe kumininingwane yolwazi lakho lebhizinisi. Omunye wemisebenzi ebaluleke kakhulu abaphathi be-database abawenzayo ukuqaliswa kokulawulwa kokufinyelela okubambe iqhaza okunciphisa ikhono labasebenzisi ukuthola futhi ukuguqula idatha ku-database ngaphandle uma benesidingo esicacile sokuthi benze kanjalo. Lokhu kudinga ukuhlonza abasebenzisi ngabanye ngokusebenzisa ukusetshenziswa kwama-akhawunti womsebenzisi.
I-SQL Server inikeza izindlela ezimbili zokudala ama-akhawunti womsebenzisi wedatha: ukuqinisekiswa kwe-Windows noma imodi exubekile, esekela 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 kanye nokwenza lula ukuphathwa kokuphepha. Ku-SQL Server (imodi exubile) ukuqinisekiswa, usengabela amalungelo kubasebenzisi be-Windows, kodwa ungakha futhi ama-akhawunti akhona kuphela kwisimo sevava yedatha.
Ngokuvamile, kungcono ukusebenzisa i-Windows yokuqinisekisa imodi ngoba kunciphisa izingqimba zobunzima emvelweni wakho. Ngokwenza umthombo owodwa we-akhawunti yomsebenzisi, ungaqiniseka ngokwengeziwe ukuthi abasebenzisi abashiya inhlangano bahlinzekelwe ngokugcwele. Noma kunjalo, akunakwenzeka njalo ukuhlangabezana nazo zonke izidingo zakho zokuqinisekisa nge-akhawunti yesizinda, ngakho-ke ungase udinge ukuwafaka nge-akhawunti yendawo eyenzelwe ukusebenza kuphela nge-SQL Server yolwazi.
Ukudala i-akhawunti ye-SQL Server 2012
Uma udinga ukudala i-akhawunti ye-SQL Server uma usebenzisa ukuqinisekiswa kwemodi exubile, landela le nqubo ye-SQL Server 2012:
- 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 .
- Ukuze unikeze amalungelo ku-akhawunti ye-Windows, khetha ukuqinisekiswa kwe-Windows . Ukudala i-akhawunti ekhona ku-database kuphela, khetha ukuqinisekiswa kwe-SQL Server .
- Nikeza igama login ebhokisini lombhalo. Ungasebenzisa inkinobho Dlulisa amehlo ukukhetha i-akhawunti ekhona uma ukhetha i-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 okudala ama-akhawunti we-SQL Server 2012
Nawa amanye amathiphu okufanele uwalandele uma udala ama-akhawunti womsebenzisi we-SQL Server 2012:
- Qinisekisa ukusebenzisa iphasiwedi eqinile uma udala ukungena ngemvume kwe-SQL Server.
- Ukuze ususe i-akhawunti ekhona (usebenzisa ukuqinisekiswa kwe-SQL Server noma i-Windows ukuqinisekiswa), 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 exhunyiwe yesibonelo sakho se-SQL Server.
- Noma ngabe iyiphi imodi yokuqinisekisa oyisebenzisayo, qiniseka ukuthi udala ama-akhawunti futhi unakekele amalungelo omsebenzisi ngokunakekelwa. Ukuphathwa kwezokuphepha akuyona into enhle kunazo zonke yokuphatha imisebenzi yedatha, kodwa yilokho ofuna ukuqiniseka ukuthi uthola khona.
Qaphela: Lesi sihloko sisebenza ku-SQL Server 2012. Uma usebenzisa inguqulo yokuqala yeSQL Server 2008, inqubo iyafana, kodwa qaphela ukuthi iMicrosoft yeka ukusekelwa kwe-SQL Server 2008 ngo-2014.