ããé»è®¤é²ç«å¢è®¾ç½®
ããè§åé²ç«å¢é ç½®ç第ä¸æ¥æ¯ç¡®å®æä½ç³»ç»çé²ç«å¢çå½åç¶æã å¦ææä½ç³»ç»æ¯ä»æ©æçæ¬å级èæ¥ï¼åå¯è½å·²ä¿ç以åçé²ç«å¢è®¾ç½®ã æ¤å¤ï¼é²ç«å¢è®¾ç½®å¯è½å·²ç±å ¶ä»ç®¡çåæåä¸çç»çç¥æ´æ¹ã
ãã注æ 注æ
ããæå¼é²ç«å¢å°å½±å访é®æ¤è®¡ç®æºçå ¶ä»ç¨åºï¼ä¾å¦æ件åæå°å ±äº«ä»¥åè¿ç¨æ¡é¢è¿æ¥ã å¨è°æ´é²ç«å¢è®¾ç½®ä¹åï¼ç®¡çååºå¯¹è®¡ç®æºä¸è¿è¡çææåºç¨ç¨åºå 以èèã
ããç¨äºé ç½®é²ç«å¢çç¨åº
ããæä¸ç§é ç½® Windows é²ç«å¢è®¾ç½®çæ¹å¼ã
ããâæ§å¶é¢æ¿âä¸çâWindows é²ç«å¢â项
ããå¯ä»¥ä»âæ§å¶é¢æ¿âæå¼âWindows é²ç«å¢â项ã
ããéè¦è¯´æ éè¦æ示
ããå¨âæ§å¶é¢æ¿âä¸çâWindows é²ç«å¢â项ä¸æåçæ´æ¹åªä¼å½±åå½åé ç½®æ件ã 诸å¦ä¾¿æºå¼è®¡ç®æºä¹ç±»ç移å¨è®¾å¤ä¸åºä½¿ç¨âæ§å¶é¢æ¿âä¸çâWindows é²ç«å¢â项ï¼å 为å½ä»¥å ¶ä»é ç½®è¿æ¥è®¾å¤æ¶é ç½®æ件å¯è½ä¼æ´æ¹ã è¿æ ·ä»¥åé ç½®çé ç½®æ件å°å¤±æã æå ³é ç½®æ件ç详ç»ä¿¡æ¯ï¼è¯·åé é«çº§å®å ¨ Windows é²ç«å¢å ¥é¨æåã
ãã使ç¨âæ§å¶é¢æ¿âä¸çâWindows é²ç«å¢â项å¯é ç½®åºæ¬é项ã å ¶ä¸å æ¬ï¼
ããæå¼æå ³éâæ§å¶é¢æ¿âä¸çâWindows é²ç«å¢â项
ããå¯ç¨åç¦ç¨è§å
ããé ç½®ä¾å¤ç端å£åç¨åº
ãã设置ä¸äºèå´éå¶
ããâæ§å¶é¢æ¿âä¸çâWindows é²ç«å¢â项æéåäºé²ç«å¢é ç½®ç»éªä¸è¶³çç¨æ·ä»¥åè¦ä¸ºé移å¨ç计ç®æºé ç½®åºæ¬é²ç«å¢é项çç¨æ·ã ä¹å¯ä»¥éç¨ä»¥ä¸æ¥éª¤éè¿ run å½ä»¤æå¼âæ§å¶é¢æ¿âä¸çâWindows é²ç«å¢â项ï¼
ããæå¼âWindows é²ç«å¢â项
ããå¨âå¼å§âèåä¸ï¼åå»âè¿è¡âï¼ç¶åè¾å ¥ firewall.cplã
ããåå»âç¡®å®âã
ããMicrosoft 管çæ§å¶å° (MMC)
ãã使ç¨é«çº§å®å ¨ Windows é²ç«å¢ MMC 管çåå å¯ä»¥é ç½®æ´é«çº§çé²ç«å¢è®¾ç½®ã æ¤ç®¡çåå 以ä¸ç§æäºä½¿ç¨çæ¹å¼åç°å¤§å¤æ°é²ç«å¢é项ï¼å¹¶ä¸ä¼æ¾ç¤ºææé²ç«å¢é ç½®æ件ã æå ³è¯¦ç»ä¿¡æ¯ï¼è¯·åé æ¬ä¸»é¢åé¢ç使ç¨é«çº§å®å ¨ Windows é²ç«å¢ç®¡çåå ã
ããnetsh
ãã管çåå¯ä»¥å¨å½ä»¤æ示符ä¸ä½¿ç¨ netsh.exe å·¥å ·é ç½®åçè§åºäº Windows ç计ç®æºï¼ä¹å¯ä»¥ä½¿ç¨æ¹å¤çæ件æ§è¡æ¤æä½ã.éè¿ä½¿ç¨ netsh å·¥å ·ï¼å¯ä»¥å°è¾å ¥çä¸ä¸æå½ä»¤å®åå°ç¸åºå¸®å©å¨ï¼ç¶åç±å¸®å©å¨æ§è¡æ¤å½ä»¤ã 帮å©å¨æ¯ä¸ä¸ªå¨æé¾æ¥åº (.dll) æ件ï¼å®éè¿å¯¹ä¸ç§æå¤ç§æå¡ãå®ç¨å·¥å ·æåè®®æä¾é ç½®ãçè§åæ¯ææ¥æ©å± netsh å·¥å ·çåè½ã æææ¯æ SQL Server çæä½ç³»ç»é½å ·æé²ç«å¢å¸®å©å¨ã Windows Server 2008 ä¹å ·æç§°ä½ advfirewall çé«çº§é²ç«å¢å¸®å©å¨ã æ¬ä¸»é¢ä¸è®¨è®ºæå ³ä½¿ç¨ netsh ç详ç»ä¿¡æ¯ã ä¸è¿ï¼æè¿°é ç½®é项ä¸ç许å¤é项é½å¯ä»¥éè¿ä½¿ç¨ netsh å 以é ç½®ã ä¾å¦ï¼å¨å½ä»¤æ示符ä¸è¿è¡ä»¥ä¸èæ¬ï¼ä»¥æå¼ TCP ç«¯å£ 1433ï¼
ããnetsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT
ãã使ç¨é«çº§å®å ¨ Windows é²ç«å¢å¸®å©å¨çä¸ä¸ªç±»ä¼¼ç¤ºä¾ï¼
ããnetsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN
ããæå ³ netsh ç详ç»ä¿¡æ¯ï¼è¯·åé 以ä¸é¾æ¥ï¼
ããå¦ä½ä½¿ç¨ Netsh.exe å·¥å ·åå½ä»¤è¡å¼å ³
ããå¦ä½ä½¿ç¨ânetsh advfirewall firewallâä¸ä¸æèéânetsh firewallâä¸ä¸ææ§å¶ Windows Server 2008 å Windows Vista ä¸ç Windows é²ç«å¢è¡ä¸º
ããânetsh firewallâå½ä»¤åâprofile=allâåæ°ä¸é ç½®åºäº Windows Vista ç计ç®æºä¸çå ¬å ±é ç½®æ件
ããä¸é¢å 个表å¯æå©äºæ¨ç¡®å® SQL Server æ使ç¨ç端å£ã
ããæ°æ®åºå¼æ使ç¨ç端å£
ããä¸è¡¨ååºäºæ°æ®åºå¼æç»å¸¸ä½¿ç¨ç端å£ã
ãã