Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLÔ¶³ÌÁ¬½ÓÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÎÒÔÚ±¾»úÁ¬½ÓÊý¾Ý¿âÔËÐгÌÐòûÓÐÎÊÌâ,¿ÉÊÇÎҰѳÌÐò¸ÄΪÁ¬½ÓÔ¶³Ì·þÎñÆ÷ÔËÐоͳöÏÖ((ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) ))Õâ¸ö´íÎó!ÎÒÓõÄÊÇsql2005 EXPRESS£¬ÎÒÒѾ­°´ÕÕÍøÉÏ˵µÄÆôÓÃSQLServer ä¯ÀÀÆ÷·þÎñÁË£¬»¹ÊÇͬÑùµÄÎÊÌ⣡£¡£¡£¡
ÔõôûÈ˰¡£¿Ç§ÍòÒª°ï°ïæ°¡£¡£¡£¡¶¥Ò»ÏÂ

ÅäÖùÜÀí¹¤¾ß-¡·SQL Server ÍâΧӦÓÃÅäÖÃÆ÷-¡··þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷-¡·Database Engine-¡·Ô¶³ÌÁ¬½Ó-¡·Ñ¡ÖС®±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó¡¯-¡·ÖØÆô·þÎñ¡£ ÓÐ×ö¹ýÉÏÊöµÄÅäÖÃÂð£¿

Did you enable remote connection for TCP and Named Pipe?

Look under SQL Server 2005 Surface Area Configuration for Services and Connections -> Instance Name -> Database Engine -> Remote Connection

ÖØÆô¹ý£¬¿É¾ÍÊÇûÓã¬ÎÒÊǰ´ÕÕÕâ¸öÉÏÃæ×öµÄhttp://wanjianfei.javaeye.com/blog/439658£¬ÇÒ·À»ðǽҲ¹ØÁË£¬ÐéÄâ·þÎñÆ÷ÓõÄÊÇ»¨Éú¿Ç;Ôõô°ì°¡£¿ºÜÓôÃÆ


ÒýÓÃ
ÖØÆô¹ý£¬¿É¾ÍÊÇûÓã¬ÎÒÊǰ´ÕÕÕâ¸öÉÏÃæ×öµÄ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

ÎÒµÄÁ¬½Ó×Ö·û


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ