Koj puas tau poob lossis tsis nco qab koj li SQL Server tus ID nkag mus? Puas yog koj tsis tuaj yeem nkag mus rau koj tus lej SQL Server? Yog tias koj yog ib tus neeg siv hauv SQL Server, koj tuaj yeem tiv tauj koj tus SA (tus thawj tswj hwm) kom rov pib tus password tshiab rau koj. Tab sis yog tias koj SA thiab tau poob tus password, nws yuav yog qhov xwm txheej nyuaj rau koj. Koj yuav tsum tau hloov lossis rov pib dua tus password kom qhib SQL Server. Qee qhov kev daws teeb meem tau muab hauv qab no, dhau los uas koj tuaj yeem hloov pauv SQL Server SA password.
Cov kauj ruam
Txoj Kev 1 ntawm 4: Siv Command Prompt
Kauj Ruam 1. Nias Yeej+R thiab hom ua cmd.
Ntaus nkag. Command Prompt yuav tshwm sim.
Kauj Ruam 2. Khiav Osql –S ComputerName commandE hais kom ua thiab ntaus nkag
Kauj Ruam 3. Tam sim no khiav EXEC sp_password NULL, 'NewPassword', 'sa' thiab ntaus nkag
Kauj Ruam 4. Ntaus Mus kom ua kom tiav
Tam sim no koj tuaj yeem nkag mus rau koj li SQL Server los ntawm kev siv tus lej tshiab.
Txoj Kev 2 ntawm 4: Siv SQL Management Studio
SQL Server tus password tuaj yeem hloov pauv hauv Management Studio los ntawm kev siv Windows Authentication.
Kauj Ruam 1. Nkag mus rau koj li SQL Server los ntawm kev siv Windows Authentication
Hauv Management Studio.
Kauj Ruam 2. Nthuav Lub Hom Phiaj Explorer thiab qhib lub Ruaj ntseg nplaub tshev.
Kauj Ruam 3. Tam sim no nthuav cov Logins nplaub tshev, txoj nyem rau ntawm SA tus account thiab nyem rau Khoom.
Kauj Ruam 4. Ntaus tus lej SA tshiab thiab lees paub nws
Tom qab ntawv nyem rau OK.
Txoj Kev 3 ntawm 4: Siv SQL Script
Kauj Ruam 1. Qhib SQL Server Management Studio los hloov SQL Server password los ntawm kev siv SQL Script
Kauj Ruam 2. Qhib Cov Lus Nug Tshiab thiab sau cov lus nug hauv daim duab uas pom
Ua nws.
Txoj Kev 4 ntawm 4: Siv Tus Neeg Sab Nraud Software
Kauj Ruam 1. Sim cov cuab yeej thib peb los qhib SQL Server cov nyiaj (tus tswj hwm lub cev ib yam nkaus thiab tus kheej)
Tshawb nrhiav online txhawm rau tshuaj xyuas cov software tsim nyog.