1. æ°æ®åºå¼æ没æå¯å¨ã
æ两ç§å¯å¨æ¹å¼:
(1)å¼å§->ç¨åº->Microsoft SQL Server 2005->SQL Server 2005å¤å´åºç¨é
ç½®å¨,å¨æå¼ççé¢åå»"æå¡çè¿æ¥çå¤å´åºç¨é
ç½®å¨",å¨æå¼ççé¢ä¸æ¾å°Database Engine,åå»"æå¡",å¨å³ä¾§æ¥çæ¯å¦å·²å¯å¨,å¦æ没æå¯å¨å¯åå»"å¯å¨",并确ä¿"å¯å¨ç±»å"为èªå¨,ä¸è¦ä¸ºæå¨,å¦åä¸æ¬¡å¼æºæ¶åè¦æå¨å¯å¨;
(2)å¯æå¼:å¼å§->ç¨åº->Microsoft SQL Server 2005->é
置工å
·->SQL Server Configuration Manager,éä¸SQL Server 2005æå¡ä¸SQL Server(MSSQLSERVER) ,并åå»å·¥å
·æ ä¸ç"å¯å¨æå¡"æé®ææå¡ç¶ææ¹ä¸ºå¯å¨;
使ç¨ä¸é¢ä¸¤ç§æ¹å¼æ¶,ææ¶åå¨å¯å¨çæ¶åå¯è½ä¼åºç°é误,ä¸è½å¯å¨,è¿æ¶å°±è¦æ¥ç"SQL Server 2005é
置管çå¨"ä¸çSQL Server 2005ç½ç»é
ç½®->MSSQLSERVERåè®®ä¸çVIAæ¯å¦å·²å¯ç¨,å¦æå·²å¯ç¨,åæå®ç¦æ¢.ç¶ååæ§è¡ä¸è¿°ä¸ç§æ¹å¼æä½å°±å¯ä»¥äº.
2. æ¯å¦å·²ç»å
许è¿ç¨è¿æ¥ã
è¿ä¸ªé¨åå¯ä»¥ç®åçå为4个æ¹é¢ï¼åå«æ¯å¨ SQL Serverä¸å¯ç¨è¿ç¨è¿æ¥ãå¯ç¨SQL Server æµè§æå¡ãå¨Windows é²ç«å¢ä¸ä¸ºSQL Server 2005 å建ä¾å¤åå¨Windows é²ç«å¢ä¸ä¸ºâSQLBrowserâå建ä¾å¤ãä¸é¢æ¯å 个å
·ä½çæä½æ¹å¼ï¼æèªMSDNï¼ä¸ªäººè§å¾æç« çé»ä½é¨ååºå½ç¹å«çä¸èµ·æ们ç注æã
å¨SQLServer å®ä¾ä¸å¯ç¨è¿ç¨è¿æ¥
1.æåâå¼å§->ç¨åº->Microsoft SQL Server 2005->é
置工å
·->SQL Server å¤å´åºç¨é
ç½®å¨â
2.å¨âSQL Server 2005 å¤å´åºç¨é
ç½®å¨â页, åå»âæå¡åè¿æ¥çå¤å´åºç¨é
ç½®å¨â
3.ç¶ååå»å±å¼âæ°æ®åºå¼æâï¼ éä¸âè¿ç¨è¿æ¥âï¼å¨å³è¾¹éä¸âæ¬å°è¿æ¥åè¿ç¨è¿æ¥âï¼
åéæ©è¦ä½¿ç¨çåè®®ï¼( è¿ä¸ªå°æ¹åºå½å¯ç¨TCP/IP åå½å管éæå¡ï¼)åå»âåºç¨âï¼æ¨ä¼çå°ä¸æ¶æ¯ï¼
âç´å°éæ°å¯å¨æ°æ®åºå¼ææå¡åï¼å¯¹è¿æ¥è®¾ç½®æåçæ´æ¹æä¼çæãâï¼åå»âç¡®å®âæé®è¿å
4.å±å¼âæ°æ®åºå¼æâï¼ éä¸âæå¡âï¼å¨å³è¾¹åå»âåæ¢âï¼çå° MSSQLSERVER æå¡åæ¢ï¼
ç¶ååå»âå¯å¨âï¼éæ°å¯å¨MSSQLSERVER æå¡ã
å¯ç¨ SQLServer æµè§å¨æå¡
1.æåâå¼å§->ç¨åº->Microsoft SQL Server 2005->é
置工å
·->SQL Server å¤å´åºç¨é
ç½®å¨â
2.å¨âSQL Server 2005 å¤å´åºç¨é
ç½®å¨â页, åå»âæå¡åè¿æ¥çå¤å´åºç¨é
ç½®å¨â
3.ç¶ååå»å±å¼âSQL Server Browserâï¼ éä¸âæå¡âï¼å¨å³è¾¹âå¯å¨ç±»åâéæ©âèªå¨âï¼
ååå»âå¯å¨âï¼åå»âç¡®å®âæé®è¿å
å¨Windows é²ç«å¢ä¸ä¸ºâSQL Server 2005âå建ä¾å¤
1.å¨ Windows é²ç«å¢è®¾ç½®çé¢ä¸ï¼éæ©â ä¾å¤â é项å¡ï¼ç¶ååå»âæ·»å ç¨åºâ
2.å¨âæ·»å ç¨åºçªå£âä¸åå»âæµè§â
3.ç¶åæ¾å°âC:\ProgramFiles\Microsoft Files\Microsoft SQL Server\ MSSQL.1 \MSSQL\Binn\sqlservr.exeâï¼
åå»âç¡®å®âè¿å
注æ ï¼ è·¯å¾å¯è½ä¼æ ¹æ® SQL Server 2005 å®è£
ä¸åèä¸åã MSSQL.1 æ¯å ä½ç¬¦ï¼å¯¹åºæ°æ®åºå®ä¾IDã
4.对æ¯ä¸ªéè¦æå¼è¿ç¨è®¿é®çSQL Server 2005 å®ä¾ï¼éå¤æ¥éª¤ 1 è³ 3ã
å¨Windows é²ç«å¢ä¸ä¸ºâSQLBrowserâå建ä¾å¤
1.å¨ Windows é²ç«å¢è®¾ç½®çé¢ä¸ï¼éæ©â ä¾å¤â é项å¡ï¼ç¶ååå»âæ·»å ç¨åºâ
2.å¨âæ·»å ç¨åºçªå£âä¸åå»âæµè§â
3.ç¶åæ¾å°âC:\ProgramFiles\Microsoft Files\Microsoft SQL Server\90\Shared\sqlbrowser.exeâï¼
åå»âç¡®å®âè¿å
注æ ï¼ è·¯å¾å¯è½ä¼æ ¹æ® SQL Server 2005 å®è£
ä¸åèä¸å
温馨提示:答案为网友推荐,仅供参考