é»è®¤æ
åµä¸, SQLServerExpressEdition 2005 å SQL Server 2005 å¼åçä¸å
许è¿ç¨è¿æ¥ã
è¦å
许è¿ç¨è¿æ¥SQL Server 2005 ,éè¦å®æ以ä¸æ¥éª¤ï¼
•å¨SQLServer å®ä¾ä¸å¯ç¨è¿ç¨è¿æ¥ã
•æå¼æå¡å¨ SQLBrowser æå¡ã
•é
ç½®é²ç«å¢ä»¥å
许SQLBrowser æå¡åSQLServeræå¡ç½ç»éä¿¡ã
å¨SQLServer å®ä¾ä¸å¯ç¨è¿ç¨è¿æ¥
1.æåâå¼å§->ç¨åº->Microsoft SQL Server 2005->é
置工å
·->SQL Server å¤å´åºç¨é
ç½®å¨â
2.å¨âSQL Server 2005 å¤å´åºç¨é
ç½®å¨â页, åå»âæå¡åè¿æ¥çå¤å´åºç¨é
ç½®å¨â
3.ç¶ååå»å±å¼âæ°æ®åºå¼æâï¼ éä¸âè¿ç¨è¿æ¥âï¼å¨å³è¾¹éä¸âæ¬å°è¿æ¥åè¿ç¨è¿æ¥âï¼
åéæ©è¦ä½¿ç¨çåè®®ï¼åå»âåºç¨âï¼æ¨ä¼çå°ä¸æ¶æ¯ï¼
âç´å°éæ°å¯å¨æ°æ®åºå¼ææå¡åï¼å¯¹è¿æ¥è®¾ç½®æåçæ´æ¹æä¼çæãâï¼åå»âç¡®å®âæé®è¿å
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 å®è£
ä¸åèä¸åã
温馨提示:答案为网友推荐,仅供参考