SQLÖ®¾Å SQLµÄ°²×°Óë¹ÜÀí
SQL Server °²×°×¢ÒâÊÂÏ£¡
==============================
http://www.cnblogs.com/pvistely/archive/2008/12/31/1365702.html
1. ÐèÒª.Net Framework 3.5£¬ÈôÔÚVista»ò¸ü¸ßµÄOSÉÏÐèÒª3.5 SP1µÄÖ§³Ö£¨ÔÚSQL2008°²×°µÄÇ°»á×Ô¶¯¸üа²×°£©
2. ÐèÒªWidnows PowerShellµÄÖ§³Ö,WPSÊÇÒ»¸ö¹¦Äܷdz£Ç¿´óµÄShellÓ¦Óã¬ÃüÁîÓëDOX/UNIX¼æÈݲ¢Ö§³ÖÖ±½Óµ÷ÓÃ.NETÄ£¿é×öÐÐÃüÁî±à¼£¬ÊǷdz£ÖµµÃÉîÈëÑо¿µÄ¹¤¾ß£¨ÔÚSQL2008°²×°Ê±»á×Ô¶¯¸üа²×°£©
3. ÐèҪȷ±£Windows InstallerµÄ³É¹¦Æô¶¯£¬ÐèÒª4.5ÒÔÉÏ°æ±¾£¨ÐèÒª¼ì²é·þÎñÆô¶¯×´Ì¬service.msc)
4. ÐèÒªMDAC2.8 sp1µÄÖ§³Ö£¨XPÒÔÉÏϵͳÖÐÒѼ¯³É£©
5. Èô»úÆ÷ÉÏÒѾ°²×°Visual studio 2008ÔòÐèÒªVS 2008 sp1ÒÔÉÏ°æ±¾µÄÖ§³Ö
±È½ÏÁ½¸öÊý¾Ý¿â±í½á¹¹µÄ²îÒì
========================
http://www.itwis.com/html/database/sqlserver/20090902/5907.html
ͼ½â¾Û´ØË÷ÒýÓë·Ç¾Û´ØË÷ÒýµÄÇø±ð¼°ÆäÓÅ»¯²éѯ
==============================
http://www.itwis.com/html/database/sqlserver/20090611/4602.html
named pipes
==============================================
"ÃüÃû¹ÜµÀ"»ò"ÃüÃû¹ÜÏß"(Named Pipes)ÊÇÒ»ÖÖ¼òµ¥µÄ½ø³Ì¼äͨÐÅ(I P C)»úÖÆ,
Microsoft Windows NT,Windows 2000,Windows 95ÒÔ¼°Windows 98¾ùÌṩÁ˶ÔËüµÄÖ§³Ö
(µ«²»°üÀ¨Windows CE).ÃüÃû¹ÜµÀ¿ÉÔÚͬһ̨¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,»òÔÚ¿çÔ½Ò»¸öÍøÂçµÄ
²»Í¬¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,Ö§³Ö¿É¿¿µÄ,µ¥Ïò»òË«ÏòµÄÊý¾ÝͨÐÅ.
ÃüÃû¹ÜµÀÓë TCP/IP Ì×½Ó×Ö
ÔÚ¿ìËÙ¾ÖÓòÍø (LAN) »·¾³ÖУ¬´«Êä¿ØÖÆÐÒé»ò Internet ÐÒé (TCP/IP) Ì×½Ó×Ö¿Í»§¶ËºÍÃüÃû¹ÜµÀ¿Í»§¶ËÔÚÐÔÄÜ·½Ãæ²»ÏàÉÏÏ¡£µ«ÊÇ£¬ÍøÂçËÙ¶ÈÔ½Âý£¨ÈçÔÚ¹ãÓòÍø (WAN) »ò²¦ºÅÍøÂçÉÏ£©£¬TCP/IP Ì×½Ó×Ö¿Í»§¶ËÓëÃüÃû¹ÜµÀ¿Í»§¶ËµÄÐÔÄܲîÒìÔ½Ã÷ÏÔ¡£ÕâÊÇÒòΪ½ø³Ì¼äͨѶ (IPC) »úÖÆÔÚ¶ÔµÈÏî¼äµÄͨѶ·½·¨²»Í¬¡£
¶ÔÓÚÃüÃû¹ÜµÀ£¬Í¨³£ÍøÂçͨÐŽ»»¥ÐÔ¸üÇ¿¡£Ò»¸ö¶ÔµÈÏîÖ±µ½ÁíÒ»¸ö¶ÔµÈÏîʹÓöÁÈ¡ÃüÁîÇëÇóÊý¾Ýʱ²Å·¢ËÍÊý¾Ý¡£ÔÚ¿ªÊ¼¶ÁÈ¡Êý¾ÝÇ°£¬ÍøÂç¶ÁÈ¡Ò»°ã°üÀ¨Ò»ÏµÁпúÊÓÃüÃû¹ÜµÀµÄÐÅÏ¢¡£ÕâÔÚÂýËÙÍøÂçÖпÉÄÜ»¨·Ñ·Ç³£¶à²¢µ¼Ö¹ý¶àµÄÍøÂçÁ÷Á¿£¬ÆäËüµÄÍøÂç¿Í»§¶Ë·´¹ýÀ´Ò²»áÊܵ½Ó°Ïì¡£
²ûÃ÷ËùÌÖÂÛµÄÊDZ¾µØ¹ÜµÀ»¹ÊÇÍøÂç¹ÜµÀÒ²ºÜÖØÒª¡£Èç¹û·þÎñÆ÷Ó
Ïà¹ØÎĵµ£º
Èç¹ûÄãµÄÉí·ÝÑéÖ¤·½Ê½ÎªWindows¼¯³ÉÉí·ÝÑéÖ¤¸ü¸ÄΪ»ìºÏ·½Ê½µÄÉí·ÝÑéÖ¤£¬ÐèÒªÔÚSQL Server Configuration ManagementÖУ¬°ÑTCP/IPµÄ»î¶¯ÆôÓã¬Ò²¾ÍÊǵÚÒ»¸öÑ¡ÔñµÄµØ·½£¬Ñ¡ÔñÆôÓᣲ¢ÇÒʹÓü¯³ÉÉí·ÝÑéÖ¤·½Ê½µÇ¼ºó£¬ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏÑ¡ÔñÊôÐÔ£¬°Ñ°²È«ÐÔϵÄWINDOWSģʽ¸ÄΪSQLÓëWINDOWSģʽ ......
----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
----------------------------------------------------------------------
1£©ÍêÈ«»Ö¸´Ä£ÐÍ
-----------------
£¨1£©±¸·ÝʱҪ±¸·ÝÊý¾Ý¿âµÄÊý¾ÝÎļþºÍÈÕÖ¾Îļþ
£¨2£©»¹ÔʱʹÓÃÊý¾Ý¿âµÄ±¸·ÝµÄÊý¾ÝÎļþ¸±±¾ºÍÈ«²¿ÈÕÖ¾ÐÅ ......
ºÜÔç×ö¹ýµÄÒ»¸ödelphiÏîÄ¿£¬°ÑÀïÃæÓõ½µÄ¼¼Êõ×ܽáһϣ¬Ö÷ÒªÊÇÕë¶ÔÏóÎÒÕâÑùµÄdelphiÐÂÊÖ£¬¼¼ÊõÉÏ×ö¸ö»ýÀÛ°É£¡
¼ÙÉèÎÒÃǵÄÊý¾Ý¿âÅäÖÃÎļþServerInfo.iniÄÚÈÝÈçÏ£º
[ServerInfo]
ServerIP=192.168.1.5
SQLDBName=Data
SQLUserID=sa
SQLPwd=
ÎÒÃǶ¨ÒåÒ»¸öÁ¬½ÓÊý¾Ý¿âµÄ¹ý ......
1. еIJúÆ·°æ±¾
³ýSQL Server 2005±ê×¼°æºÍÆóÒµ°æÖ®Í⣬²úÆ·ÏßÖл¹¼ÓÈëÁËSQL Server 2005¼ò»¯°æ£¨SQL Server 2005 Express£©ºÍ¹¤×÷×é°æ£¨SQL Server 2005 Workgroup£©Á½¸öа汾¡£
SQL Server 2005 Express——Æä×÷ÓÃÊÇ´úÌæ΢ÈíSQL Server×ÀÃæÒýÇ棨Microsoft SQL Server Desktop Engine£¬MSDE£©¡£SQL Serve ......