Kuv yuav ua li cas thiaj tau txais ib daim ntawv teev npe ntawm SQL Server?
Kuv yuav ua li cas thiaj tau txais ib daim ntawv teev npe ntawm SQL Server?

Video: Kuv yuav ua li cas thiaj tau txais ib daim ntawv teev npe ntawm SQL Server?

Video: Kuv yuav ua li cas thiaj tau txais ib daim ntawv teev npe ntawm SQL Server?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Tej zaum
Anonim

Tag nrho cov piv txwv ntsia yuav tsum tshwm nyob rau hauv Services Snap-In hauv Microsoft Management Console. Kom tau txais cov piv txwv npe, mus rau Pib | Khiav | Hom Kev Pabcuam. msc thiab nrhiav txhua qhov nkag nrog " Sql Server ( Piv txwv Lub npe)". lis tus piv txwv cov npe koj tau teeb tsa hauv zos.

Tib neeg kuj nug, pes tsawg zaus SQL tuaj yeem ntsia tau rau hauv server?

50 ej

Ib sab saum toj no, kuv yuav ua li cas thiaj nrhiav tau SQL Server piv txwv lub npe los ntawm kev sau npe? Los ntawm Command Prompt, ntaus regedit .exe, thiab nias [ENTER]. Mus rau HKEY_LOCAL_MACHINE >> SOFTWARE >> Microsoft >> Microsoft SQL Server >> Cov npe piv txwv . Txhua piv txwv ntsia rau ntawm server muaj tus yuam sij hauv ib daim nplaub tshev hauv qab no npe nkag.

Ntawm no, kuv yuav nrhiav tau kuv lub npe SQL Server hauv zos li cas?

Kauj ruam 1 - Qhib lub qhov rais hais kom ua ntawm lub tshuab uas SQL ntawv yog ntsia. Mus rau Start → Khiav, ntaus cmd, thiab ntaus nkag mus qhib qhov hais kom ua. Kauj ruam 2 -SQLCMD -S servername npe (qhov servernameb = the npe ntawm koj server , thiab npe yog cov npe ntawm SQL piv txwv ). Cov lus qhia yuav hloov mus rau 1 →.

Kuv yuav nrhiav tau lub npe neeg rau zaub mov rau SQL Server li cas?

Nyob ntawm server , mus SQL Server Configuration Manager. Hauv qab SQL Server Cov kev pabcuam nyob rau sab laug pane, koj yuav nyem thiab pom Lub npe , Lub Xeev, Pib Hom, thiab Nkag Mus Raws li rau kab. Koj yuav tsum pom SQL Server ( NPE ). Vam tias nws tab tom khiav, txoj nyem thiab mus rau cov khoom.

Pom zoo: