Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

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


Ïà¹ØÎÊ´ð£º

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ