å·¥å
·/åæ
çµèï¼å®è£
è¿SQL Server2008ï¼
æ¹æ³/æ¥éª¤
1
ç»éSQL Server 2008ï¼windows身份认è¯ï¼ï¼ç»éåå³å»ï¼éæ©âå±æ§âã
2
左侧éæ©âå®å
¨æ§âï¼éä¸å³ä¾§çâSQL Server å Windows 身份éªè¯æ¨¡å¼â以å¯ç¨æ··åç»å½æ¨¡å¼ã
3
éæ©âè¿æ¥âï¼å¾éâå
许è¿ç¨è¿æ¥æ¤æå¡å¨âï¼å»ºè®®å°âæ大并åè¿æ¥æ°âæå®é
æ
åµï¼è¿è¡è®¾ç½®ï¼ç¶åç¹âç¡®å®âã
4
å±å¼âå®å
¨æ§â->âç»å½åâ->âsaâï¼å³é®éæ©âå±æ§âã
5
左侧éæ©â常è§âï¼å³ä¾§éæ©âSQL Server 身份éªè¯âï¼å¹¶è®¾ç½®å¯ç ã
éæ©âç¶æâï¼éä¸âå¯ç¨âï¼ç¹å»âç¡®å®âã
å³å»æ°æ®åºéæ©âæ¹é¢âã
å¨âæ¹é¢âä¸æ¥å表æ¡ä¸ï¼éæ©âæå¡å¨é
ç½®ï¼âRemoteAccessEnabledâå±æ§åâRemotoDacEnabledâ设为âTrueâï¼ç¹âç¡®å®âãè³æ¤SSMS已设置å®æ¯ï¼å
éåºï¼åç¨saç»å½ï¼æåå³è¡¨ç¤ºsaå¸æ·å·²ç»å¯ç¨ã
ä¸é¢å¼å§é
ç½®Sql Server Configuration Manager (SSCM)ï¼éä¸å·¦ä¾§çâSQL Serveræå¡âï¼ç¡®ä¿å³ä¾§çâSQL Serverâ以åSQL Server Browseræ£å¨è¿è¡ã
æå¼å·¦ä¾§âSqlServerç½ç»é
ç½®âï¼æå¼âä½ èªå·±æ°æ®åºå®ä¾åçåè®®âï¼æ¥çå³ä¾§çTCP/IPé»è®¤æ¯âå·²ç¦ç¨âï¼å°å
¶ä¿®æ¹ä¸ºâå·²å¯ç¨âã
åå»æå¼âTCP/IPâæ¥çâTCP/IPå±æ§âä¸âåè®®âé项å¡ä¸çâå
¨é¨ä¾¦å¬âåâå·²å¯ç¨â项ï¼æ¯å¦é½æ¯è®¾ç½®æâæ¯âã
éæ©âIP Adderssesâé项å¡ï¼IP1ãIP2ãIPAll设置TCP端å£ä¸ºâ1433âï¼TCPå¨æ端å£ä¸ºç©ºå¼ï¼å·²å¯ç¨ä¸ºâæ¯âã
å°"客æ·ç«¯åè®®"ç"TCP/IP"ä¹ä¿®æ¹ä¸ºâå·²å¯ç¨âã
åå»æå¼å³ä¾§âTCP/IPâï¼æå¼âTCP/IPå±æ§âï¼å°é»è®¤ç«¯å£è®¾ä¸ºâ1433âï¼å·²å¯ç¨ä¸ºâæ¯âãé
ç½®å®æï¼éæ°å¯å¨SQL Server 2008ã
æåä¸æ¥ï¼å¿
éè¦é²ç«å¢ä¸æSQL Server ç1433 TCP端å£å1434 UDP端å£æ å°åºå»ã
注æäºé¡¹
SQL Server 2008 Expresså®è£
以åï¼é»è®¤æ
åµä¸æ¯ç¦ç¨è¿ç¨è¿æ¥çãå¦æéè¦è¿ç¨è®¿é®ï¼éè¦æå¨é
ç½®ã æå¼é²ç«å¢è®¾ç½®ãå°SQLServr.exeï¼C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exeï¼æ·»å å°å
许çå表ä¸ã 该æç« æ¯æ ¹æ®æ¬äººå¨ä½¿ç¨çå®é
æ
åµä¸è¿è¡ä¸æè¯éªåå¨ç½ä¸æ¥æ¾ç¸å
³èµæè¿è¡æ´æ¹çã ç±äºæ¬äººä½¿ç¨çæ¯CiscoASA5510çé²ç«å¢ï¼æ以å¨é
ç½®é²ç«å¢çæ¶åæ¾ç»ä¸åº¦ä»¥ä¸ºåªè¦1433çTCP端å£æ å°å°±å¯ä»¥äºï¼ä½æ¯å´åå¤è¯éªé½ä¸æåãæåæ¥æ¾äºSql Serverç½ç»ç«¯å£çç¸å
³èµæï¼åæ1434çUDP端å£ä¹ä¸å¹¶æ å°åºå»ï¼å°±å¯ä»¥ç¨SSMSå¨INTERNETä¸æåè¿æ¥ã
温馨提示:答案为网友推荐,仅供参考