IiNkonzo zeSikhangeli soMncedisi weSQL

Ukuba, xa usebenzisa isikhangeli senkonzo yeSQL, uhlala ufumana lo myalezo wempazamo: “Inkonzo yeSikhangeli soMncedisi weSQL kwikhompyuter yakho yobulali iqalile emva koko yayeka. Ezinye iinkonzo zizima ngokuzenzekelayo ukuba azisetyenziswa zezinye iinkonzo okanye iinkqubo.” Isenokucaphukisa kakhulu.

Ukuba uzifumana ujongene nale ngxaki rhoqo, ungakhathazeki, kwesi sithuba siza kukubonisa indlela onokuyisombulula ngayo.

Ukuba isizathu sempazamo kukuba iinkonzo zeSQL azizange ziqalwe ngokufanelekileyo ngelixa umncedisi we SQL kuqhagamshelwana naye, uya kudibana nale mpazamo ilandelayo: S.QL Network Interfaces, imposiso: 26 – Imposiso yokuFumana iSeva/Imeko ecacisiweyo (iMicrosoft SQL Server)

Ukuba ufuna ukusombulula ingxaki ye-SQL Mncedisi ukumisa inkonzo yomkhangeli zincwadi kwaye uqalise emva koko kuya kufuneka uhlele ixabiso layo lobhaliso ukuze uvale inkonzo yeSsrpListener.

IiNkqubo zokuSebenza zeBit-64 (x64):

IiNkqubo zokuSebenza zeBit-32 (x86):

UwuSombulula Njani Lo mba:

1. Into yokuqala ekufuneka uyenzile kukucofa Win kunye no-R ngaxeshanye. Oku kuya kuvula u-Run. Emva koko kufuneka uchwetheze irisithi kwibhokisi ethi Qhuba.

2. Ngoku, ukuba unenkqubo yokusebenza ye-x64, kuya kufuneka uchwetheze oku kulandelayo: KEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft\Microsoft SQL Server\90\SQL Browser
3. Ukuba, nangona kunjalo, unenkqubo yokusebenza ye-x86, uya kuchwetheza into eyahlukileyo kuyo. Kwindlela yokusebenza ye-x86, kuya kufuneka uchwetheze oku kulandelayo: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL Browser
4. Emva kokuchwetheza komnye wale miyalelo mibini ingasentla, cofa ekunene kwi SsrpListener. Kuya kufuneka ngoku uguqule kwaye usete ixabiso layo ku-0.
5. Vula ibhokisi yencoko yababini kwakhona. Ngeli xesha, chwetheza kwiinkonzo.mcs. Emva kokuchwetheza oku, kuya kufuneka ucofe u-OK.
6. Ngoku kufuneka uye kwiinkonzo zeSikhangeli seSQL.
7. Cofa ekunene kwaye ucofe kuQalisa ukuseta uhlobo lokuQalisa njenge-Automatic ukusuka kwiipropathi.

Emva kokuthatha la manyathelo, iinkonzo zeSQL kufuneka ngoku ziqale ngokufanelekileyo.

Ngaba uyilungisile ingxaki yeenkonzo zeSQL ukuqala nokuyeka kwisixhobo sakho?

Yabelana ngamava akho kwiibhokisi zengcaciso ngezansi.

JR

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