I-SQL Server ibopha ikheli le-VPN elingekho ngesikhathi sokuvula

Funda umugqa werogile ye-SQL Server mayelana nokwehluleka kokubopha ngesikhathi isevisi isasebenza, futhi uthole ukuncika ekulandeleni kokuqala, hhayi ukuphahlazeka. Leyo nhlanganisela iyisikhombisi: injini yaqala ngaphambi kokuba ikheli eyayitshelwe ukuthi ilalele kulo libe khona emshinini. I-adaptha ye-VPN evela ngemva kokungena iyisimo sangaphambili esibi sesevisi yedatha engabhekwanga, ngakho landela ukwehluleka ngokulandelelana injini ekubonayo.

Qala kurogile yokuqala, hhayi kuklayenti

Vula irogile yamaphutha yensiza bese ufunda okufakiwe okuzungeze ukuqalwa kwenethiwekhi, hhayi umugqa wokugcina kuphela. Injini ibika ukuthi yiziphi izikheli eyazama kanye nokuthi yiziphi izivumelwano eyazivula, futhi leyo rekhodi ingeyangaphambi kokuba noma yiliphi iklayenti lixhumane. Manje bheka ukuthi yini ekhona kusibungayi khona manje. Uma isixhumi esinekhlei elilungisiwe sibonakala kuphela ngemva kokuba umsebenzisi engene futhi eqale iklayenti, ikheli lalingekho ngesikhathi sokuqala futhi ukwehluleka kokubopha kuchazwa ngokugcwele.

Get-NetIPAddress -AddressFamily IPv4 | Select-Object InterfaceAlias, IPAddress, PrefixOrigin
Get-Content 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG' -Tail 40

Lungisa indlela yensiza ngokuhambisana nokufakwa kwakho, futhi ufunde uhlu lwezixhumi ngaphambi kokuthatha izinqumo. Ikheli elikhona kodwa elingeladaptha engalungile liyinkinga ehlukile kunekheli elingakabi khona.

Hamba ngokulandelelana kokubopha injini ekulandelayo ngempela

Injini ifunda ukulungiswa kwaso kwesilaleli bese icela uhlelo lokusebenza ukuthi lubophe. Uma ikheli lingekho endaweni ngaleso sikhathi, ukubopha kulelo kheli kuyahluleka kuyilapho insiza eseleyo ingaqhubeka ngokwejwayelekile. Yingakho ezinye izivumelwano noma amanye amakheli kusengasebenza, futhi yingakho „i-SQL Server iphansi“ kuyisifinyezo esingalungile. Gcina iphuzu lokugcina eliqondile kurogile: ikheli, imbobo kanye nesivumelwano, ngoba ukulungiswa kuncike ekutheni yikuphi kokuthathu okungalungile.

Ukuqala kabusha isevisi ngemva kokuvela kwadaptha ngokuvamile kuzokwenza isilaleli siphumelele, futhi yisona sici eso. Kufakazela ukuncika esikhundleni kokukususa, futhi kunqamula wonke umsebenzisi oxhunyiwe njalo lapho umhubhe uxhuma kabusha.

Funda isilaleli ngendlela injini eyifunda ngayo

Ku-SQL Server Configuration Manager, vula izici ze-TCP/IP zensiza futhi uphawule ukulungiswa kwe-Listen All ngaphambi kokuhlela amakheli ngamanye. Uma i-Listen All i-Yes, amanani e-Enabled ngekheli ngayinye ayashaywa indiva, ngakho ukuwahlela akushintshi lutho isilaleli esikusebenzisayo. Bhala izinto ezintathu ngokulandelelana: ikheli ohlose ukulisebenzela, imbobo, nokuthi isilaleli kufanele sihlanganise wonke amakheli noma elilodwa kuphela. Bese usebenzisa ushintsho ngenqubo yokuqala kabusha esekelwayo futhi ufunde irogile yokuqala elandelayo ukuze uqinisekise ukuthi injini ibophe lokho obukucelile.

Ukulalela kukho konke ikheli akusikho ukulawula ukufinyelela. Uma isilaleli esibanzi sidingeka ngempela, isixhumi ngasinye esifinyeleleka sidinga isinqumo saso somsakazo kanye nokugunyazwa kwedatha, kuhlanganise noma yisiphi isixhumi esibheke ku-inthanethi.

Nikeza iklayenti indawo eziqondile ezinhle

Iklayenti alidingi ukuthi isibungayi sedatha sigqoke ikheli lechibi. Idizayini enomzila isebenza lapho iseva ilalele ekhelini layo langasese elizinzile kuyilapho isango le-VPN lidlulisela ithrafikhi yeklayenti kuyo futhi libuyisele impendulo.

Test-NetConnection -ComputerName 10.80.0.15 -Port 1433
tracert -d 10.80.0.15

Uma iklayenti lifinyelela ku-10.80.0.15, indlela isiqinisekisiwe futhi idatha kudingeka kuphela igunyaze lelo klayenti. Uma lingafinyeleli, lungisa umzila kanye ne-DNS ngaphambi kokuthinta isilaleli futhi, ngoba inkinga yokubopha kuseva yayingakaze ibe yisizathu sokuthi iklayenti lingayitholi. Ukwengeza ikheli lechibi elingelona kuseva, noma isango lesibili elimisiwe ukuze kujabuliswe isilaleli, kudala inkinga entsha yenethiwekhi phezu kwendala. Gcina ikheli leseva lizinzile futhi uvumele umhubhe ukuthi ulethe amaklayenti kuyo.

Qinisekisa iphuzu lokugcina elisetshenziswe yiklayenti

Qeda ngokuhlola ezingeni lohlelo esikhundleni sokuhlola imbobo. Xhuma kusukela kuklayenti nge-akhawunti esetshenziswa uhlelo bese ufunda imininingwane yoxhumano ohlangothini lwesva, ekhombisa ikheli lendawo okwehlela kulo isikhathi sakho.

sqlcmd -S tcp:10.80.0.15,1433 -Q "SELECT local_net_address, local_tcp_port FROM sys.dm_exec_connections WHERE session_id = @@SPID"

Qhathanisa lelo kheli nesilaleli osilungisile. Ukungafani kusho isilaleli sesibili noma igama elixazululwa endaweni engalindelekile, futhi kokubili kufanele kwaziwe ngaphambi kokuba ukuqala kabusha okulandelayo kuhlole ukulungisa kwakho esikhundleni sakho. Bese uqala kabusha isibungayi ngaphandle komsebenzisi ongenile futhi uqinisekise ukuthi ukubopha kuphumelela. Leyo nhlolo eyodwa iyimehluko phakathi kwesilaleli esilungisiwe kanye nekhambi lesikhashana elihluleka ngobusuku besichibi esilandelayo.