Isticmaal Windows Authentication ama SQL Server Authentication
SQL Server 2008 ayaa bixiya laba hab oo lagu abuurayo xisaabaadka user accounts: Windows authentication iyo aqoonsiga SQL Server. Xaaladda aqoonsiga ee Windows, waxaad ku wareejin kartaa dhamaan oggolaanshaha xogta xisaabaadka Windows. Tani waxay leedahay faa'iido ay u leedahay bixinta khibrad isku mid ah oo loogu talagalay isticmaalaha iyo fududeynta maareynta amniga. In SQL Server (nidaamka isku dhafan) aqoonsiga, waxaad weli xuquuq u siin kartaa dadka isticmaala Windows, laakiin sidoo kale waxaad abuuri kartaa xisaabeed oo jira oo kaliya ee ku jira server-ka database.
Sida Loo Helo Xisaabtarka Database
- Furan Isticmaalka Studio Server Studio .
- Ku xir macluumaadka xogta SQL Server halkaas oo aad rabto inaad abuurto login.
- Furi faylasha amniga .
- Ku dhufo faylka Logins oo dooro New Log .
- Haddii aad rabto inaad kuxiso xuquuqda xisaabta Windows, dooro aqoonsiga Windows . Haddii aad rabto inaad abuurto koonto ku jirta oo kaliya ku jirta diiwaanka, dooro aqoonsiga SQL Server .
- Sii magaca magacaaga ee sanduuqa qoraalka. Waxaad isticmaali kartaa badhanka Raadinta si aad u dooratid xisaabta hadda jira haddii aad dooratay aqoonsiga Windows.
- Haddii aad dooratay aqoonsi SQL Server, waa inaad sidoo kale bixisaa lambar sir ah oo ku yaalla sanduuqyada qoraalka ah ee " Password" iyo " Confirmation" .
- Kala soocista xogta aasaasiga ah iyo luqadda koontada, haddii loo baahdo, adigoo isticmaalaya sanduuqyada hoosta ku yaal ee hoose ee daaqadda.
- Guji OK si aad u abuurto koontada.
Talooyin
- U hubso inaad isticmaasho furaha ereyga adag haddii aad abuurayso SQL Server login.
- Haddii aad rabto in aad ka saarto koontada hore (iyadoo la isticmaalayo aqoonsiga SQL Server ama aqoonsiga Windows), ku dhufo xisaabta ku jira khariidada Logins iyo Select Delete.
- Abuuritaanka xisaabtu ma samayso oggolaanshaha xogta. Talaabada xigta ee geeddi-socodka waa in lagu daro rukhsadaha koontada.
- Aqoonsiga SS Server waxaa kaliya oo la heli karaa haddii aad dooratay aqoonsiga habka isku dhafan ee tusaalahaaga SQL Server.