SQl Server é
置管çå¨ï¼ç®ç§°ä¸ºé
置管çå¨ï¼å
å«äºSQL Server 2008æå¡ãSQL Server 2008ç½ç»é
ç½®åSQL Native Clienté
ç½®3个工å
·ï¼ä¾æ°æ®åºç®¡ç人ååæå¡å¨å¯å¨åæ¢ä¸çæ§ãæå¡å¨ç«¯æ¯æçç½ç»åè®®é
ç½®ãç¨æ·è®¿é®SQLServer çç½ç»ç¸å
³è®¾ç½®çå·¥ä½ãä¸ãé
ç½®æå¡1ãSQL Server é
ç½®éæ¡ä¾ä¸å¯ä»¥éè¿å¼å§èåæ ä¸çãSQL Server 2é
置管çå¨ãæå¼ï¼æè
éè¿å¨å½ä»¤æ示ä¸è¾å
¥sqlservermanager.mscå½ä»¤æ¥æå¼ã2ãé¦å
æå¼SQL Server é
置管çå¨ï¼æ¥çååºçä¸SQL Server 2008ç¸å
³çæå¡ï¼éæ©æå¡å并å³é®åå»å¼¹åºçå¿«æ·èåä¸éæ©ãå±æ§ãå½ä»¤è¿è¡é
ç½®ãå¨å³é®åå»SQL Serverï¼MSSQLSERVERï¼å¼¹åºçãSQL Serverï¼MSSQLSERVERå±æ§ï¼ã对è¯æ¡ãå¨ãç»å½ãé项å¡ä¸è®¾ç½®æå¡çç»å½èº«ä»½ï¼æ¯ä½¿ç¨æ¬å°ç³»ç»è´¦æ·è¿æ¯æå®çè´¦æ·ã3ãå´æ¢å°ãæå¡ãé项å¡å¯ä»¥è®¾ç½®SQLServer ï¼MSSQLSERVERï¼æå¡çå¯å¨æ¨¡å¼ï¼å¯ä»¥é项æâèªå¨âãâæå¨âãâç¦ç¨âï¼ç¨æ·å¯ä»¥æ ¹æ®éè¦è¿è¡æ´æ¹ãäºãç½ç»é
ç½®1ãSQL Server 2008è½ä½¿ç¨å¤ç§åè®®ï¼å
æ¬Shared MemoryãNamed PipesãTCP/IPåVIA.ææè¿äºåè®®é½æç¬ç«çæå¡å¨å客æ·ç«¯é
ç½®ãéè¿SQL Serverç½ç»é
ç½®å¯ä»¥ä¸ºæ¯ä¸ä¸ªæå¡å¨å®ä¾ç¬ç«å°è®¾ç½®ç½ç»é
ç½®ã2ãå¨ãSQL Serveré
置管çå¨ãçªå£ä¸ï¼åå»å·¦ä¾§çãSQL Server ç½ç»é
ç½®ãèç¹ï¼å¨çªå£å³ä¾§æ¾ç¤ºåºææSQL Server æå¡å¨ä¸æ使ç¨çåè®®ï¼å³é®åå»åè®®å称ï¼å¨å¼¹åºçå¿«æ·èåä¸éæ©ãå±æ§ãèå项ï¼å¨å¼¹åºæ¥ç对è¯æ¡ä¸è¿è¡è®¾ç½®å¯ç¨æè
ç¦ç¨æä½ï¼è®¾ç½®Shared Memoryåè®®ç对è¯æ¡ï¼çªå£å³ä¾§æå个åè®®çä½ç¨å¦ä¸ã3ãShared Memoryåè®®ï¼Shared Memoryåè®®ä»
ç¨äºæ¬å°è¿æ¥ï¼å¦æ该å议被å¯ç¨ï¼ä»»ä½æ¬å°å®¢æ·é½å¯ä»¥ä½¿ç¨æ¤åè®®è¿æ¥æå¡å¨ãå¦æä¸å¸ææ¬å°å®¢æ·ä½¿ç¨Shared Shared Memoryåè®®ï¼åå¯ä»¥ç¦ç¨ã4ãName Pipesåè®®ï¼Name Pipeså议主è¦ç¨äºWindows 2008以åçæ¬çæä½ç³»ç»çæ¬å°è¿æ¥ä»¥åè¿ç¨è¿æ¥ã5ãTCP/IPåè®®ï¼TCP/IPåè®®æ¯éè¿æ¬å°æè¿ç¨è¿æ¥å°SQL Serverçé¦éåè®®ã使ç¨TCP/IPåè®®æ¶ï¼SQL SERVERå¨æå®çTCP端å£åIPå°å侦å¬å·²ååºå®ç请æ±ã6ãVIAåè®®ï¼å¦æåä¸è®¡ç®æºä¸å®è£
æ两个æå¤ä¸ªSQL Serverå®ä¾ï¼åVIAè¿æ¥å¯è½ä¼ä¸æç¡®ãVIAåè®®å¯ç¨åï¼å°å°è¯ä½¿ç¨TCP/IP设置ï¼å¹¶ä¾¦å¬ç«¯å£0:1433ã对äºä¸å
许é
置端å£çVIA驱å¨ç¨åºï¼ä¸¤ä¸ªSQL Serverå®ä¾åå°ä¾¦å¬åä¸ç«¯å£ãä¸ãæ¬å°å®¢æ·ç«¯åè®®é
ç½®1ãéè¿SQL Native Clientï¼æ¬å°å®¢æ·ç«¯åè®®ï¼é
ç½®å¯ä»¥å¯ç¨æç¦ç¨å®¢æ·ç«¯åºç¨ç¨åºä½¿ç¨çåè®®ãæ¥ç客æ·ç«¯åè®®é
ç½®æ
åµçæ¹æ³æ¯ï¼å¨å¯¹è¯æ¡ä¸ãSQL Native Clienté
ç½®ãèç¹ï¼å¨è¿å
¥çä¿¡æ¯çªæ ¼ä¸æ¾ç¤ºäºåè®®çå称以å客æ·ç«¯å°è¯è¿æ¥å°æå¡å¨æ¯å°è¯ä½¿ç¨çåè®®ç顺åºï¼ç¨æ·è¿å¯ä»¥æ¥çåè®®æ¯å¦ä»¥å¯ç¨æ以ç¦ç¨å¹¶è·å¾æå
³åè®®æ件ç详ç»ä¿¡æ¯ã2ãå¨é»è®¤çæ
åµä¸ Share Memoryåè®®æ»æ¯é¦éçæ¬å°è¿æ¥åè®®ãè¦æ¹åå议顺åºå¯å³é®åå»åè®®ï¼å¨å¼¹åºæ¥çå¿«æ·èåä¸éæ©ã顺åºãå½ä»¤ï¼å¨å¼¹åºæ¥çã客æ·åè®®å±æ§ã对è¯æ¡ä¸è¿è¡è®¾ç½®ï¼ä»ãå¯å¨çåè®®ãå表ä¸åå»éæ©ä¸ä¸ªåè®®ï¼ç¶åéè¿å³ä¾§ç两个æé®æ¥è°æ´åè®®åä¸æåä¸ç§»å¨ã
温馨提示:答案为网友推荐,仅供参考