本文为【SQL Server不允许进行远程连接的解决办法】的汉字拼音对照版显示拼音
刚gang刚gang安an装zhuang的de数shu据ju库ku系xi统tong,按an照zhao默mo认ren安an装zhuang的de话hua,很hen可ke能neng在zai进jin行xing远yuan程cheng连lian接jie时shi报bao错cuo,通tong常chang是shi错cuo误wu:"在zai连lian接jie到dao SQL Server 2005 时shi,在zai默mo认ren的de设she置zhi下xia SQL Server 不bu允yuan许xu进jin行xing远yuan程cheng连lian接jie可ke能neng会hui导dao致zhi此ci失shi败bai。 (provider: 命ming名ming管guan道dao提ti供gong程cheng序xu, error: 40 - 无wu法fa打da开kai到dao SQL Server的de连lian接jie) ",现xian在zai针zhen对dui此ci问wen题ti总zong结jie如ru下xia:明ming白bai了leSQL Server是shi个ge网wang络luo数shu据ju库ku就jiu可ke迎ying刃ren而er解jie了le,简jian单dan的de分fen为wei下xia面mian的de几ji种zhong情qing况kuang。
◆1.数shu据ju库ku引yin擎qing没mei有you启qi动dong。有you两liang种zhong启qi动dong方fang式shi:
(1)开kai始shi->程cheng序xu->Microsoft SQL Server 2005->SQL Server 2005外wai围wei应ying用yong配pei置zhi器qi,在zai打da开kai的de界jie面mian单dan击ji"服fu务wu的de连lian接jie的de外wai围wei应ying用yong配pei置zhi器qi",在zai打da开kai的de界jie面mian中zhong找zhao到daoDatabase Engine,单dan击ji"服fu务wu",在zai右you侧ce查cha看kan是shi否fou已yi启qi动dong,如ru果guo没mei有you启qi动dong可ke单dan击ji"启qi动dong",并bing确que保bao"启qi动dong类lei型xing"为wei自zi动dong,不bu要yao为wei手shou动dong,否fou则ze下xia次ci开kai机ji时shi又you要yao手shou动dong启qi动dong;
(2)可ke打da开kai:开kai始shi->程cheng序xu->Microsoft SQL Server 2005->配pei置zhi工gong具ju->SQL Server Configuration Manager,选xuan中zhongSQL Server 2005服fu务wu中zhongSQL Server(MSSQLSERVER) ,并bing单dan击ji工gong具ju栏lan中zhong的de"启qi动dong服fu务wu"按an钮niu把ba服fu务wu状zhuang态tai改gai为wei启qi动dong;
使shi用yong上shang面mian两liang种zhong方fang式shi时shi,有you时shi候hou在zai启qi动dong的de时shi候hou可ke能neng会hui出chu现xian错cuo误wu,不bu能neng启qi动dong,这zhe时shi就jiu要yao查cha看kan"SQL Server 2005配pei置zhi管guan理li器qi"中zhong的deSQL Server 2005网wang络luo配pei置zhi->MSSQLSERVER协xie议yi中zhong的deVIA是shi否fou已yi启qi用yong,如ru果guo已yi启qi用yong,则ze把ba它ta禁jin止zhi.然ran后hou再zai执zhi行xing上shang述shu一yi种zhong方fang式shi操cao作zuo就jiu可ke以yi了le.
◆2.是shi否fou已yi经jing允yuan许xu远yuan程cheng连lian接jie。这zhe个ge部bu分fen可ke以yi简jian单dan的de分fen为wei4个ge方fang面mian,分fen别bie是shi在zai SQL Server上shang启qi用yong远yuan程cheng连lian接jie、启qi用yongSQL Server 浏liu览lan服fu务wu、在zaiWindows 防fang火huo墙qiang中zhong为weiSQL Server 2005 创chuang建jian例li外wai和he在zaiWindows 防fang火huo墙qiang中zhong为wei“SQLBrowser”创chuang建jian例li外wai。下xia面mian是shi几ji个ge具ju体ti的de操cao作zuo方fang式shi:
在zaiSQLServer 实shi例li上shang启qi用yong远yuan程cheng连lian接jie
◆1.指zhi向xiang“开kai始shi->程cheng序xu->Microsoft SQL Server 2005->配pei置zhi工gong具ju->SQL Server 外wai围wei应ying用yong配pei置zhi器qi”
◆2.在zai“SQL Server 2005 外wai围wei应ying用yong配pei置zhi器qi”页ye, 单dan击ji“服fu务wu和he连lian接jie的de外wai围wei应ying用yong配pei置zhi器qi”
◆3.然ran后hou单dan击ji展zhan开kai“数shu据ju库ku引yin擎qing”, 选xuan中zhong“远yuan程cheng连lian接jie”,在zai右you边bian选xuan中zhong“本ben地di连lian接jie和he远yuan程cheng连lian接jie”,
再zai选xuan择ze要yao使shi用yong的de协xie议yi,( 这zhe个ge地di方fang应ying当dang启qi用yongTCP/IP 和he命ming名ming管guan道dao服fu务wu!)单dan击ji“应ying用yong”,您nin会hui看kan到dao下xia消xiao息xi:
“直zhi到dao重chong新xin启qi动dong数shu据ju库ku引yin擎qing服fu务wu后hou,对dui连lian接jie设she置zhi所suo做zuo的de更geng改gai才cai会hui生sheng效xiao。”,单dan击ji“确que定ding”按an钮niu返fan回hui
◆4.展zhan开kai“数shu据ju库ku引yin擎qing”, 选xuan中zhong“服fu务wu”,在zai右you边bian单dan击ji“停ting止zhi”,等deng到dao MSSQLSERVER 服fu务wu停ting止zhi,
然ran后hou单dan击ji“启qi动dong”,重chong新xin启qi动dongMSSQLSERVER 服fu务wu。
启qi用yongSQLServer 浏liu览lan器qi服fu务wu
◆1.指zhi向xiang“开kai始shi->程cheng序xu->Microsoft SQL Server 2005->配pei置zhi工gong具ju->SQL Server 外wai围wei应ying用yong配pei置zhi器qi”
◆2.在zai“SQL Server 2005 外wai围wei应ying用yong配pei置zhi器qi”页ye, 单dan击ji“服fu务wu和he连lian接jie的de外wai围wei应ying用yong配pei置zhi器qi”
◆3.然ran后hou单dan击ji展zhan开kai“SQL Server Browser”, 选xuan中zhong“服fu务wu”,在zai右you边bian“启qi动dong类lei型xing”选xuan择ze“自zi动dong”,
再zai单dan击ji“启qi动dong”,单dan击ji“确que定ding”按an钮niu返fan回hui
在zaiWindows 防fang火huo墙qiang中zhong为wei“SQL Server 2005”创chuang建jian例li外wai
◆1.在zai Windows 防fang火huo墙qiang设she置zhi界jie面mian中zhong,选xuan择ze“ 例li外wai” 选xuan项xiang卡ka,然ran后hou单dan击ji“添tian加jia程cheng序xu”
◆2.在zai“添tian加jia程cheng序xu窗chuang口kou”中zhong单dan击ji“浏liu览lan”
◆3.然ran后hou找zhao到dao“C:\ProgramFiles\Microsoft Files\Microsoft SQL Server\ MSSQL.1 \MSSQL\Binn\sqlservr.exe”,
单dan击ji“确que定ding”返fan回hui
注zhu意yi : 路lu径jing可ke能neng会hui根gen据ju SQL Server 2005 安an装zhuang不bu同tong而er不bu同tong。 MSSQL.1 是shi占zhan位wei符fu,对dui应ying数shu据ju库ku实shi例liID。
◆4.对dui每mei个ge需xu要yao打da开kai远yuan程cheng访fang问wen的deSQL Server 2005 实shi例li,重chong复fu步bu骤zhou 1 至zhi 3。
在zaiWindows 防fang火huo墙qiang中zhong为wei“SQLBrowser”创chuang建jian例li外wai
◆1.在zai Windows 防fang火huo墙qiang设she置zhi界jie面mian中zhong,选xuan择ze“ 例li外wai” 选xuan项xiang卡ka,然ran后hou单dan击ji“添tian加jia程cheng序xu”
◆2.在zai“添tian加jia程cheng序xu窗chuang口kou”中zhong单dan击ji“浏liu览lan”
◆3.然ran后hou找zhao到dao“C:\ProgramFiles\Microsoft Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe”,
单dan击ji“确que定ding”返fan回hui
注zhu意yi :路lu径jing可ke能neng会hui根gen据ju SQL Server 2005 安an装zhuang不bu同tong而er不bu同tong。在zai使shi用yong.NET开kai发fa进jin行xing时shi,会hui遇yu到dao使shi用yong连lian接jie字zi符fu串chuan连lian接jieSQL Server 2005数shu据ju库ku使shi用yong机ji器qi名ming称cheng和helocalhost都dou能neng连lian接jie,但dan是shi使shi用yongIP地di址zhi却que不bu能neng连lian接jie的de问wen题ti,解jie决jue的de办ban法fa是shi在zaiSQL Server实shi例li上shang启qi用yong本ben地di和he远yuan程cheng连lian接jie,并bing且qie在zai选xuan择ze协xie议yi的de时shi候hou使shi用yongTCP/IP和he命ming名ming管guan道dao服fu务wu即ji可ke解jie决jue。【原文】