SQL Server Browser Services

Yog tias, thaum koj siv SQL qhov kev pabcuam browser, koj tau txais cov lus yuam kev no: "Qhov kev pabcuam SQL Server Browser ntawm koj lub computer hauv zos tau pib thiab tom qab ntawd nres. Qee qhov kev pabcuam nres tau yog tias lawv tsis siv los ntawm lwm cov kev pabcuam lossis cov haujlwm. " Nws tuaj yeem ua rau ntxhov siab heev.

Yog tias koj pom koj tus kheej ntsib qhov teeb meem no ntau zaus, tsis txhob txhawj, hauv cov ntawv tshaj tawm no yuav qhia koj tias koj tuaj yeem daws nws li cas.

Yog vim li cas rau qhov yuam kev yog tias cov kev pabcuam SQL tsis tau pib zoo thaum lub SQL server raug hu, koj yuav ntsib qhov yuam kev hauv qab no: SQL Network Interfaces, yuam kev: 26 - yuam kev Locating Server/Instance Specified (Microsoft SQL Server)

Yog tias koj xav daws qhov teeb meem ntawm SQL neeg rau zaub mov browser kev pabcuam nres thiab pib tom qab ntawd koj yuav tsum hloov kho nws tus nqi sau npe txhawm rau txhawm rau lov tes taw qhov kev pabcuam SsrpListener.

64-ntsis Operating Systems (x64):

32-ntsis Operating Systems (x86):

Yuav daws qhov teeb meem li cas:

1. Thawj qhov uas koj yuav tau ua yog nias Win thiab R ib txhij. Qhov no yuav qhib Run. Tom qab ntawd koj yuav tsum ntaus daim ntawv txais nyiaj hauv Run box.

2. Tam sim no, yog tias koj muaj x64 operating system, koj yuav tsum tau ntaus ntawv hauv qab no: KEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\SQL Browser
3. Txawm li cas los xij, yog tias koj muaj x86 operating system, koj yuav ntaus ib yam dab tsi txawv rau hauv x86 operating system, koj yuav tsum ntaus hauv qab no: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL Browser
4. Tom qab ntaus ntawv hauv ib qho ntawm ob cov lus txib saum toj no, txoj nyem rau ntawm SsrpListener. Tam sim no koj yuav tau hloov kho thiab teem nws tus nqi rau 0.
5. Qhib lub dialog box ib zaug ntxiv. Lub sijhawm no, ntaus hauv services.mcs. Tom qab ntaus ntawv no, koj yuav tsum nias OK.
6. Tam sim no koj yuav tsum mus rau SQL Browser cov kev pabcuam.
7. Txoj cai-nias thiab nyem rau ntawm Start kom teeb tsa hom Startup li Tsis siv neeg los ntawm cov khoom.

 

Tom qab ua cov kauj ruam no, SQL cov kev pabcuam tam sim no yuav tsum pib pib kom zoo.

 

Koj puas tau kho qhov teeb meem ntawm SQL cov kev pabcuam pib thiab nres hauv koj lub cuab yeej?

Qhia koj kev nyob rau hauv cov lus lub thawv hauv qab no.

JR

[embedyt] https://www.youtube.com/watch?v=h24S8xXC94A[/embedyt]