Look under SQL Server 2005 Surface Area Configuration for Services and Connections -> Instance Name -> Database Engine -> Remote Connection ÖØÆô¹ý£¬¿É¾ÍÊÇûÓã¬ÎÒÊÇ°´ÕÕÕâ¸öÉÏÃæ×öµÄhttp://wanjianfei.javaeye.com/blog/439658£¬ÇÒ·À»ðǽҲ¹ØÁË£¬ÐéÄâ·þÎñÆ÷ÓõÄÊÇ»¨Éú¿Ç;Ôõô°ì°¡£¿ºÜÓôÃÆ
Firstly, are you sure your SQL Server is running on the port you expect it to. Check out this post http://topic.csdn.net/u/20100520/16/6cf306aa-e2d5-423b-94fb-2a6f4694d908.html ÒѾ¿ªÁËÕâ¸ö1433¶Ë¿Ú£¬ÔËÐÐ->cmd->netstat –ano ÖÐÏÔʾÓÐTCP 0.0.0.0:1433 0.0.0.0:0 LISTENING 440 ÎÒµÄÁ¬½Ó×Ö·û
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......