Cov txheej txheem:

SQL Server mixed hom authentication yog dab tsi?
SQL Server mixed hom authentication yog dab tsi?

Video: SQL Server mixed hom authentication yog dab tsi?

Video: SQL Server mixed hom authentication yog dab tsi?
Video: How to Connect Sql Server Using SSMS-Part1 2024, Kaum ib hlis
Anonim

Thaum enabled, mixed hom authentication tso cai rau koj nkag mus rau hauv a SQL neeg rau zaub mov siv koj lub Windows VDS username thiab password lossis koj li SQL ntawv database username thiab password. Thaum nkag mus siv koj lub Windows VDS username thiab password, koj tuaj yeem nkag mus rau tag nrho cov databases ntawm lub server.

Ib yam li ntawd, koj tuaj yeem nug, SQL mixed hom authentication yog dab tsi?

Mixed authentication hom tso cai siv cov ntawv pov thawj Windows tab sis ntxiv rau lawv hauv zos SQL ntawv Cov neeg siv nyiaj server uas tus thawj tswj hwm tsim thiab tswj xyuas hauv SQL ntawv Server. Tus neeg siv lub npe thiab tus password yog ob qho tib si khaws cia rau hauv SQL ntawv Server, thiab cov neeg siv yuav tsum rov ua dua. muaj tseeb txhua zaus lawv sib txuas.

Qhov thib ob, Kuv yuav teeb tsa hom kev lees paub sib xyaw hauv SQL Server li cas? Txhawm rau hloov kev ruaj ntseg authentication hom mus rau hom sib xyaw

  1. Hauv SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
  2. Ntawm nplooj ntawv Kev Ruaj Ntseg, nyob rau hauv Server authentication, xaiv SQL Server thiab Windows Authentication hom, thiab tom qab ntawd nyem OK.

Ua raws li qhov no saib, Kuv yuav ua li cas thiaj paub yog tias SQL Server muaj kev sib xyaw ua kom zoo?

Right-click lub SQL ntawv piv txwv thiab xaiv Properties los qhib qhov Server Khoom - qhov rais. Nyem Security ntawm sab laug tes. Xaiv SQL Server thiab Windows Authentication hom ntawm sab xis. Nyem OK kom kaw qhov Server Khoom - qhov rais.

Kuv yuav nrhiav tau SQL li cas hauv kev sib xyaw?

Txhawm rau txheeb xyuas tias 'Mixed Mode' authentication raug xaiv, ua raws li cov kauj ruam no:

  1. Pib Enterprise Manager.
  2. Nthuav Microsoft SQL Servers thiab tom qab ntawd nthuav SQL Server Group.
  3. Txoj cai-nias lub server uas koj xav kuaj xyuas tias SQL Server thiab Windows authentication raug xaiv rau, thiab tom qab ntawd nyem Properties.

Pom zoo: