如何配置禁止遠程登錄

❶ 濡備綍 sql server 2008 紱佹㈣繙紼嬪㈡埛絝鐧誨綍

1寮濮嬧斺>Microsoft SQL Server 2008鈥斺>閰嶇疆宸ュ叿鈥斺>Sql Server 閰嶇疆綆＄悊鍣ㄢ斺> Sql Server 緗戠粶閰嶇疆鈥斺>MSSQServer鍗忚鈥斺> 紱佺敤TCP/IP鍗忚

2寮濮嬧斺>Microsoft SQL Server 2008鈥斺>閰嶇疆宸ュ叿鈥斺>Sql Server 閰嶇疆綆＄悊鍣ㄢ斺> SQL Native Client 10.0 閰嶇疆鈥斺>瀹㈡埛絝鍗忚鈥斺>紱佺敤TCP/IP鍗忚

❷ 鎬庝箞紱佹㈡寚瀹氱殑鐢ㄦ埛榪滅▼妗岄潰鐧誨綍錛

浣跨敤Win+R,鍦ㄨ繍琛屾嗗唴杈撳叆 gpedit.msc錛屾墦寮鏈鍦板畨鍏ㄧ瓥鐣ワ紝渚濇℃墦寮璁＄畻鏈洪厤緗 - windows璁劇疆 - 瀹夊叏璁劇疆 - 鏈鍦板畨鍏ㄧ瓥鐣 - 鐢ㄦ埛鏉冮檺鍒嗛厤錛屽湪鍙充晶閫夐」涓鎵懼埌鈥滄嫆緇濋氳繃榪滅▼妗岄潰鏈嶅姟鐧誨綍鈥濓紝鍙屽嚮錛屽湪寮瑰嚭紿楀彛鍐呮坊鍔犺佺佹㈢櫥褰曠殑鐢ㄦ埛鍗沖彲