Indlela yokongeza umsebenzisi kwiziko leSQL Server
I-SQL Server 2012 inikeza uluhlu olubanzi lweempawu zokhuseleko ezenzelwe ukukhusela imfihlo, ukuthembeka kunye nokufumaneka kwedata egcinwe kwiinkcukacha zakho zenkampani. Omnye wemisebenzi ebalulekileyo abalawuli beenkcukacha abazenzayo kukuba kuphunyezwe ulawulo lokufikelela kwi-role-limit that limits the ability of users to retrieve and modify data in database ngaphandle kokuba babe neyeshishini elicacileyo kufuneka benze njalo. Oku kufuna ukuchongwa kwabasebenzisi ngabanye ngokusebenzisa ukusetyenziswa kweakhawunti yomsebenzisi.
I-SQL Server inikezela iindlela ezimbini zokudala i-akhawunti yomsebenzisi wedatha: ukuqinisekiswa kwe-Windows okanye imodeli exubileyo, exhasa ukuqinisekiswa kwe-Windows kunye ne-SQL Server. 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.
Ngokuqhelekileyo, kukulungele ukusebenzisa i-Windows imodareystration mode ngoba inciphisa iindawo eziyinkimbinkimbi kwindawo yakho. Ngokufumana umthombo omnye weakhawunti yomsebenzisi, unokuqiniseka ngakumbi ukuba abasebenzisi abashiya umbutho baxhaswe ngokupheleleyo. Nangona kunjalo, akusoloko kunokwenzeka ukuhlangabezana nazo zonke iimfuno zakho zokuqinisekisa ngeakhawunti yesizinda, ngoko unokufuna ukuzongezelela ngeengxelo zendawo zenzelwe ukusebenza kuphela ngeenkcukacha zeSQL Server.
Ukudala i-akhawunti ye-SQL Server 2012
Ukuba ufuna ukudala i-akhawunti ye-SQL Server xa usebenzisa ukuqinisekiswa kwemodi edibeneyo, landela le nkqubo ye-SQL Server 2012:
- 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 .
- Ukunika amalungelo kwi-akhawunti ye-Windows, khetha uqinisekiso lwe-Windows . Ukwenza i-akhawunti ekhoyo kwi database kuphela, khetha uqinisekiso lweSQL Server .
- Nika igama lokungena kwibhokisi yombhalo. Ungasebenzisa inkquthela ye- Khangela 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 zokudala iiAkhawunti ze-SQL Server 2012
Nazi ezinye izicwangciso omele uzilandele xa udala i-akhawunti yomsebenzisi we-SQL Server 2012:
- Qinisekisa ukusebenzisa iphasiwedi eqinileyo xa udala ukungena ngemvume kweSQL Server.
- Ukususa i-akhawunti ekhoyo (usebenzisa iSiqinisekiso seSQL Server okanye uqinisekiso lweWindows), nqakraza ngakwesokudla kwi-akhawunti kwifolda ye- Logins , kwaye ukhetha Susa .
- Ukudala i-akhawunti akuyi kudala iimvume zeenkcukacha . Isinyathelo esilandelayo senkqubo ukufaka iimvume kwi-akhawunti.
- Ukuqinisekiswa kweSQL Server kuyatholakala kuphela xa ukhethe ukuqinisekiswa kwemodi edibeneyo kwimeko yakho yeSQL Server.
- Naluphi na uhlobo lwenkcazo oyisebenzisayo, qiniseka ukudala ii-akhawunti kwaye unike amalungelo amalungelo omsebenzisi. Ulawulo loKhuseleko aluwona luhle kakhulu kwimisebenzi yolawulo lweenkcukacha, kodwa enye ufuna ukuba uqiniseke ukuba ulungile.
Qaphela: Eli nqaku lisebenza kwi-SQL Server 2012. Ukuba usebenzisa inguqulo yangaphambili yeSQL Server 2008, inqubo iyafana, kodwa qaphela ukuba iMicrosoft yeka inkxaso kwiSQL Server 2008 ngo-2014.