如何配置禁止远程登录

❶ 濡备綍 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璁剧疆 - 瀹夊叏璁剧疆 - 链鍦板畨鍏ㄧ瓥鐣 - 鐢ㄦ埛𨱒冮檺鍒嗛厤锛屽湪鍙充晶阃夐”涓镓惧埌钬沧嫆缁濋氲繃杩灭▼妗岄溃链嶅姟锏诲綍钬濓纴鍙屽嚮锛屽湪寮瑰嚭绐楀彛鍐呮坊锷犺佺佹㈢橱褰旷殑鐢ㄦ埛鍗冲彲