Nzira yekuwedzera sei mudzidzi kune imwe nhamba yeSQL Server
SQL Server 2012 inopa huwandu hwakawanda hwehuchengetedzwa hwakagadzirirwa kuchengetedza zvakavanzika, kuvimbika, uye kuwanikwa kwedhesi rakachengetwa mubhizimusi rako. Chimwe chezvinhu zvakakosha izvo vashandi vepa database vanoita ndekushandiswa kwebato-based access control iyo inogadzirisa kukwanisa kwevashandisi kugadzirisa uye kugadzirisa dheta mu database kunze kwekuti vane bhizimisi rakananga rinofanira kudaro. Izvi zvinoda kuzivikanwa kwevashandisi mumwe nomumwe kuburikidza nekushandiswa kwezita rainzi user accounts.
SQL Server inopa nzira mbiri dzekusika database user user: Windows kuvimbiswa kana kuchanganidzwa mode, iyo inotsigira Windows kuvimbiswa uye SQL Server kuvimbiswa. MuWearning authentication mode, iwe unopa ma permissions ose epa database kuWindows account. Izvi zvinobatsira pakuratidza ruzivo rumwe chete rwevashandisi uye yekuita kuti kuchengetedza kuchengetedzwa. MuSQL Server (maitiro akavhenganiswa) kuvimbiswa, iwe unogona kugovera kodzero kune vashandisi veWindows, asi unogonawo kugadzira zvigaro zviripo chete mumamiriro ekuchengetedza database.
Kazhinji kutaura, zvakanakisisa kushandisa Windows kuvimbiswa nenzira nokuti inoderedza zvikamu zvekuoma kunzwisisa mukati mako. Nokuva nemunhu mumwe chete wemashandisi emarenda, unogona kuva nechivimbo chekuti vashandisi vanobva mu sangano vanonyatsorongedzerwa. Zvisinei, haisi nguva dzose kugona zvese zvekutendesa zvidikanwi nekambani dzekambani, kuitira kuti iwe unogona kuwedzera kuwedzera navo neakaunti dzekwangwani dzakagadzirirwa kushanda chete neSQL Server databases.
Kugadzira SQL Server 2012 Account
Kana iwe uchida kugadzira SQL Server account paunoshandisa kuvimbiswa kwemaitiro, tevera iyi nzira yeSQL Server 2012:
- Vhura SQL Server Management Studio.
- Gungano kuSquL Server database apo iwe unoda kugadzira login.
- Vhura Security folder.
- Kanda -kona pane Login folder uye sarudza Chatinyore .
- Kugovera kodzero yeAppa yeWindows, sarudza maWindows authentication . Kugadzira kambani inowanikwa mu database chete, sarudza SQL Server kuvimbiswa .
- Ipa zita rekutarisa mumutauro webhokisi. Iwe unogona kushandisa bhatani reKutsvaga kuti usarudze nhoroondo iripo kana ukasarudza Windows kuvimbiswa.
- Kana ukasarudza SQL Server kuvimbiswa, unofanirwa kupawo shoko rakasimba mune zvose Password uye Confirmation text boxes.
- Ita zvinyorwa zvinyorwa zvisiri izvo uye mutauro wekambani, kana uchida, uchishandisa mabhokisi ekuderedza pasi pasi pehwindo.
- Dzvanya OK kuti uite iyo nhoroondo.
Mazano ekugadzira SQL Server 2012 Maaka
Heano mamwe mazano maunofanira kutevera pawakasika SQL Server 2012 user user accounts:
- Iva nechokwadi chekushandisa izwi rakasimba kana urikusika SQL Server login.
- Kuti ubvise kero iripo (uchishandisa SQL Server kuvimbiswa kana Windows kuvimbiswa), penya -kanda pane account mu Login folder, uye sarudza Bvisa .
- Kugadzira kambani hakuiti zvibvumirano zvepa database . Nhanho inotevera yegadziriro iyi ndeyokuwedzera mavhosi ku-akhawunti.
- SQL Server kuvimbiswa inowanikwa chete kana iwe wakasarudza kuenzaniswa kwemagariro ekutenderera SQL Server yako.
- Chero chipi zvacho chekutendesa maitiro iwe unoshandisa, iva nechokwadi chekuumba zvigaro uye shandisa kodzero dzevashandi nekutarisira. Kuchengetedzwa kwekuchengetedza haisi iyo inonakidza ye database yekubata mabasa, asi ndiyo imwe yaunoda kuve yakanyatsove yakarurama.
Cherechedza: Nyaya ino inoshanda kuSQL Server 2012. Kana uri kushandisa shanduro yekare SQL Server 2008, nzira yacho yakafanana, asi zive kuti Microsoft yakasiya kutsigirwa kweSQL Server 2008 muna 2014.