SQL ta VPN: abokin ciniki kai tsaye ko tashar aiki ta ciki?

Ƙungiyoyi suna son SSMS a kwamfutocinsu na tafi-da-gida, kuma maganin gaggawa shi ne buga tashar SQL zuwa tafkin VPN. Amsa a hankali tana tambaya a ina tsarin abokin ciniki zai gudana, domin shiga kai tsaye da tashar aiki ta ciki suna ƙirƙirar adiresoshin tushe, amincewar ƙarshen hanya da hanyoyin bayanai daban-daban. Babu ɗayansu da ke da aminci kai tsaye, kuma kasancewa memba a VPN shi kaɗai ba ya yanke hukunci. Kwatanta tsare-tsaren kafin ƙa'idar izini ta wanzu.

Hanyoyi biyu, adiresoshin tushe biyu

A shiga kai tsaye kwamfutar tafi-da-gida ce ke ɗauke da saitin abokin ciniki kuma ita kanta ke buɗe haɗin bayanan. A tashar aiki mai nisa kwamfutar tafi-da-gida tana buɗe zaman tebur, kuma tashar aiki tana yin haɗin SQL daga adireshinta. Saboda haka bayanan suna ganin tafkin VPN ko ƙofar da aka fassara a tsarin farko, da adireshin tashar aiki a na biyu. Wannan bambanci ne ke yanke hukuncin wace ƙa'idar wuta da wace izinin SQL suka dace da gaske.

Kwamfutar tafi-da-gida har yanzu tana sarrafa zaman nesa, don haka tashar aiki ba ta maye gurbin tabbatar da mai amfani ko manufar zama.

Duba abin da bayanan suka gani da gaske

Adireshin tushe abu ne da ake aunawa maimakon ciro shi daga zane. Karanta shi daga bangaren uwar garke na haɗi mai rai.

Test-NetConnection sql.example.com -Port 1433
sqlcmd -S tcp:sql.example.com,1433 -N -d appdb -Q "select SUSER_SNAME() as login_name, DB_NAME() as db"

Gwajin haɗi yana tabbatar da cewa mai sauraro yana karɓar TCP daga wannan cibiyar sadarwa, yayin da tambayar ke tabbatar da wace shiga da wace bayanai zaman ya kai. Don ganin adireshin da uwar garke ta rubuta, yi tambaya kan sys.dm_exec_connections don zaman yanzu, wanda ke mayar da adireshin abokin ciniki bayan kowace fassara. Idan wannan darajar ƙofa ce ba kwamfutar tafi-da-gida ba, ƙa'idar mai masauki ga kowane mai amfani ba za ta iya aiki a injin bayanan ba. Rubuta darajar da aka lura kusa da tsarin da aka zaɓa, domin sake haɗawa da canje-canjen tafki suna motsa ta.

Buɗe mai sauraro ba wani abu ba

Buɗe sabis ɗin da turawa ke buƙata kawai. Sanannen 1433 tashar misali ta asali ce ba madaidaicin duniya ba.

Get-NetTCPConnection -State Listen -LocalPort 1433

Misalan masu suna suna sauraron tashar mai motsi, inda SQL Server Browser ke amsa ganowa a UDP 1434, kuma wannan dogaro fallasa ce daban da ya kamata a ba da hujja. Ƙulla tashar tabbatacce don misalin yana kawar da buƙatar Browser kuma yana sa ƙa'idodin wuta su tsaya. Riƙe binciken ɓoyewa da takardar shaida da abokin ciniki ke yi, maimakon kashe su don gwaji ya ci nasara. Sannan ba da matsayin bayanai don nauyin aiki maimakon ƙara dukan rukunin VPN cikin matsayin uwar garke.

Tabbatar da hanyar da aka yarda da wadda aka hana

Buɗe sabon zama a matsayin talakawan mai amfani da aka yarda, kuma tabbatar da asalin uwar garke, bayanan da aikin da ake buƙata. Sannan tabbatar da keɓancewa: tushe ko asusu da ke wajen manufar dole ya faɗi a wannan gwajin. Don tsarin tashar aiki, tabbatar cewa kwamfutar tafi-da-gida ba za ta iya tsallake iyaka ta hanyar kaiwa bayanan kai tsaye ba. Don shiga kai tsaye, tabbatar cewa hanya da ƙa'idar tushe suna nan bayan sake haɗawa.

Rubuta inda abokin ciniki ya gudana, wace tushe bayanan suka gani da wace ƙa'ida ta ba da izini. Wannan ita ce hujar da bita ta gaba za ta nema.