Yadda za a ƙara mai amfani zuwa Database SQL Server
SQL Server 2012 yana samar da fannoni masu yawa na tsare-tsaren tsaro waɗanda aka tsara don kare sirri, mutunci, da samuwa na bayanai da aka adana a cikin bayanan yanar gizo naka. Ɗaya daga cikin manyan ayyukan da masu gudanar da bayanai na yanar gizon ke gudanarwa shine aiwatar da jagorancin damar samun damar shiga wanda ya ƙayyade iyawar masu amfani don dawowa da kuma canza bayanai a cikin database har sai sun sami buƙatar buƙataccen buƙata don yin haka. Wannan yana buƙatar ganewa na masu amfani da juna ta hanyar amfani da asusun masu amfani masu suna.
SQL Server yana samar da hanyoyi guda biyu don ƙirƙirar asusun masu amfani da bayanai: Faɗakarwar Windows ko yanayin haɗaka, wanda ke goyan bayan ƙwaƙwalwar Windows da ƙwaƙwalwar SQL Server. A cikin hanyar tabbatar da Windows, kun sanya dukkanin izinin bayanan yanar gizo zuwa asusun Windows. Wannan yana da amfani da samar da kwarewa guda ɗaya ga masu amfani da kuma sauƙaƙe kulawar tsaro. A SQL Server (mixed mode) Tantance kalmar sirri, za ka iya har yanzu sanya hakkin to Windows masu amfani, amma kuma za ka iya ƙirƙirar asusun da cewa kasance kawai a cikin mahallin uwar garken database.
Kullum magana, yana da kyau a yi amfani da yanayin ƙwaƙwalwa ta Windows domin ya rage layin da ke da mahimmanci a cikin yanayinka. Ta hanyar samun asalin tushen asusun mai amfani, za ka iya zama da tabbacin cewa masu amfani waɗanda suka bar kungiyar suna cikakke-tanadi. Duk da haka, ba kullum zai yiwu ba don saduwa da duk bukatun ka na ainihi tare da asusun ajiya, saboda haka ƙila za ka buƙaci don ƙila su da asusun gida waɗanda aka tsara don aiki kawai tare da bayanan SQL Server.
Samar da wani SQL Server 2012 Account
Idan kana buƙatar ƙirƙirar asusun SQL Server lokacin amfani da alhakin halayyar gaskiyar, bin wannan tsari na SQL Server 2012:
- Bude Gidan Gidan Ayyuka na SQL Server.
- Haɗa zuwa SQL Server database inda kake son ƙirƙirar shiga.
- Bude fayil ɗin Tsaro .
- Danna-dama a kan fayil ɗin Logins kuma zaɓi Sabuwar Sabuwar .
- Don sanya hakkoki ga wani asusun Windows, zaɓi Faɗakarwar Windows . Don ƙirƙirar asusun dake wanzu kawai a cikin database, zaɓi Saitunan SQL Server .
- Samar da sunan mai shiga cikin akwatin rubutu. Kuna iya amfani da maɓallin Bincike don zaɓar lissafin da ke ciki idan ka zabi Fidilwar Windows.
- Idan ka zaɓi kalmar sirri na SQL Server, dole ne ka samar da kalmar sirri mai ƙarfi a cikin akwatin saƙo da kuma Tabbacin Tabbacin .
- Shirya asusun da ke da asali da harshe don asusun, idan ana so, ta amfani da akwatunan da aka saukar a kasa na taga.
- Danna Ya yi don ƙirƙirar asusun.
Tips for Samar da SQL Server 2012 Asusun
Ga wasu matakai da ya kamata ku bi a yayin ƙirƙirar asusun masu amfani da SQL Server 2012:
- Tabbatar yin amfani da kalmar sirri mai ƙarfi idan kana ƙirƙirar wani adireshin SQL Server.
- Don cire asusun kasancewa (ta amfani da Tantance kalmar SQL Server ko Tantancewar Windows), danna dama a kan asusu a cikin babban fayil na Logins , kuma zaɓi Share .
- Samar da asusu ba ya haifar da izini na bayanai ba . Mataki na gaba na tsari shine don ƙara izini zuwa asusun.
- SQL Server Tantance kalmar sirri yana samuwa ne kawai idan ka zaba mixed mode Tantance kalmar sirri don SQL Server misali.
- Duk abin da aka yi amfani dashi na asali, tabbatar da ƙirƙirar asusun da kuma sanya damar masu amfani tare da kulawa. Hukumomin tsaro ba shine mafi kyawun ayyukan gudanarwa na gwamnati ba, amma wannan ne wanda kake son tabbatar da samun dama.
Lura: Wannan labarin ya shafi SQL Server 2012. Idan kana amfani da version na SQL Server na baya, wannan hanya ɗaya ne, amma ku sani cewa Microsoft ya ƙi goyon bayan SQL Server 2008 a shekarar 2014.