Abuurista Diiwaanka Macluumaadka SQL Server 2008

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

  1. Furan Isticmaalka Studio Server Studio .
  2. Ku xir macluumaadka xogta SQL Server halkaas oo aad rabto inaad abuurto login.
  3. Furi faylasha amniga .
  4. Ku dhufo faylka Logins oo dooro New Log .
  5. 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 .
  6. Sii magaca magacaaga ee sanduuqa qoraalka. Waxaad isticmaali kartaa badhanka Raadinta si aad u dooratid xisaabta hadda jira haddii aad dooratay aqoonsiga Windows.
  7. Haddii aad dooratay aqoonsi SQL Server, waa inaad sidoo kale bixisaa lambar sir ah oo ku yaalla sanduuqyada qoraalka ah ee " Password" iyo " Confirmation" .
  8. Kala soocista xogta aasaasiga ah iyo luqadda koontada, haddii loo baahdo, adigoo isticmaalaya sanduuqyada hoosta ku yaal ee hoose ee daaqadda.
  9. Guji OK si aad u abuurto koontada.

Talooyin