Umhlahlandlela Wokudala I-SQL Server 2012 Ama-Akhawunti Womsebenzisi

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:

  1. Vula SQL Server Management Studio.
  2. Xhuma kwi-SQL Server database lapho ufuna ukwakha ukungena ngemvume.
  3. Vula ifolda yezokuphepha .
  4. Chofoza ngakwesokudla kwifolda ye- Logins bese ukhetha Ukungena Okusha .
  5. Ukuze unikeze amalungelo ku-akhawunti ye-Windows, khetha ukuqinisekiswa kwe-Windows . Ukudala i-akhawunti ekhona ku-database kuphela, khetha ukuqinisekiswa kwe-SQL Server .
  6. Nikeza igama login ebhokisini lombhalo. Ungasebenzisa inkinobho Dlulisa amehlo ukukhetha i-akhawunti ekhona uma ukhetha i-Windows ukuqinisekiswa.
  7. Uma ukhethe ukuqinisekiswa kwe-SQL Server, kufanele unikeze iphasiwedi eqinile kokubili amabhokisi wephasiwedi ne- Confirmation .
  8. Yenza ngokwezifiso ulwazi oluzenzakalelayo nolwazi lwe-akhawunti, uma lufisa, usebenzisa amabhokisi ahlaselwa ngaphansi kwefasitela.
  9. 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:

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.