Mmene mungapangire wosuta ku deta ya SQL Server
SQL Server 2012 imapereka zinthu zosiyanasiyana zotetezedwa zomwe zimapangidwira kuteteza chinsinsi, umphumphu, ndi kupezeka kwa deta zomwe zasungidwa muzinthu zogulitsa ntchito. Imodzi mwa ntchito zofunika kwambiri zomwe ogwira ntchito yosungirako mabuku akugwira ndi kukhazikitsa njira zowunikira zowonjezera zomwe zimachepetsa luso la ogwiritsa ntchito kuti alandire ndikusintha deta m'datala pokhapokha ngati ali ndi bizinesi yoyenera kuti achite zimenezo. Izi zimafuna kudziwika kwa ogwiritsa ntchito pogwiritsa ntchito mayina omwe amagwiritsidwa ntchito.
SQL Server imapereka njira ziwiri zopangira ma akaunti a osungirako malo: Windows kutsimikiziridwa kapena mawonekedwe osakanikirana, omwe amathandiza kutsimikizira Windows ndi SQL Server kutsimikizira. Mu Windows mawonekedwe ovomerezeka, mumapereka mavoti onse achinsinsi ku akaunti za Windows. Izi zili ndi ubwino wopereka chithunzi chokhazikika kwa ogwiritsa ntchito komanso kuchepetsa kusamalira chitetezo. Mu SQL Server (mawonekedwe osakanikirana) kutsimikiziridwa, mutha kupereka mwayi kwa ogwiritsa ntchito Windows, koma mungathe kukhazikitsa akaunti zomwe zilipo mndandanda wa seva.
Nthawi zambiri, ndi bwino kugwiritsa ntchito mawonekedwe a mawindo a Windows chifukwa amachepetsa zigawo zovuta kumvetsa. Pokhala ndi magwero amodzi a akaunti, mungakhale otsimikiza kwambiri kuti ogwiritsa ntchito omwe achoka m'bungwe akukonzekera bwino. Komabe, sizingatheke kuti mukwaniritse zofunikira zanu zonse zowonjezereka ndizomwe mukufuna kulamulira, kotero mungafunikire kuwonjezera izo ndi akaunti zapafupi zomwe zimagwiritsidwa ntchito ndi SQL Server.
Kupanga Akaunti ya SQL Server 2012
Ngati mukufuna kupanga SQL Server pomwe mukugwiritsira ntchito mawonekedwe osakanikirana, tsatirani njira iyi kwa SQL Server 2012:
- Tsegulani SQL Server Management Studio.
- Gwiritsani ntchito deta ya SQL Server pamene mukufuna kulumikiza.
- Tsegulani foda yamtendere.
- Dinani kumene pa tsamba la Logins ndikusankha Chatsopano .
- Kuti mupatse ufulu ku akaunti ya Windows, sankhani mazenera a Windows . Pofuna kukhazikitsa akaunti yomwe ilipo mu database, sankhani SQL Server kutsimikizira .
- Perekani dzina lolowetsamo mu bokosi lolemba. Mungagwiritse ntchito BUKHU LOPHUNZITSIRA kusankha akaunti yomwe ilipo ngati mwasankha mawonekedwe a Windows.
- Ngati munasankha kutsimikiziridwa kwa SQL Server, muyeneranso kupereka chinsinsi champhamvu m'mawonekedwe achinsinsi ndi Ovomerezeka .
- Sungani makaunti osasinthika ndi chinenero cha akaunti, ngati mukufuna, pogwiritsa ntchito bokosi lakutsikira pansi pazenera.
- Dinani OK kuti mupange akaunti.
Malangizo Okhazikitsa SQL Server 2012 Nkhani
Nazi malangizo omwe muyenera kutsatira pamene mukupanga akaunti za SQL Server 2012:
- Onetsetsani kuti mugwiritse ntchito mawu achinsinsi ngati mukulenga lolowera SQL Server.
- Kuchotsa akaunti yomwe ilipo (pogwiritsa ntchito kutsimikiziridwa kwa SQL Server kapena mawonekedwe a Windows), dinani pomwepa pa akaunti mu Logins folder , ndipo sankhani Chotsani .
- Kukhazikitsa akaunti sikupanga zilolezo zachinsinsi . Gawo lotsatira la ndondomekoyi ndi kuwonjezera zilolezo ku akaunti.
- Kuvomerezeka kwa SQL Server kumapezeka pokhapokha ngati mwasankha kutsimikiziridwa kwa mawonekedwe a SQL Server.
- Chilichonse chovomerezeka chomwe mumagwiritsa ntchito, onetsetsani kuti mukupanga akaunti ndikupatsani mwayi wogwiritsa ntchito mosamala. Kusungira chitetezo sizomwe zimakhala zokongola kwambiri pazinthu zothandizira ma database, koma ndi chimodzi chimene mukufuna kuti mutsimikize bwino.
Zindikirani: Nkhaniyi ikugwiritsidwa ntchito ku SQL Server 2012. Ngati mukugwiritsa ntchito SQL Server 2008 yoyamba, ndondomekoyi ndi yofanana, koma dziwani kuti Microsoft inasiya kuthandizira SQL Server 2008 mu 2014.