Microsoft SQL Server 2000 Service Pack 4Desktop Engine(MSDE 2000)ʹÓÃ˵Ã÷Êé

ÐòµÄ°²×°ÊµÓù¤¾ßÀ´µ÷Óá£Ó¦ÓóÌÐò°²×°³ÌÐò´¦ÀíËùÓÐÓë×îÖÕÓû§µÄ±ØÐè½»»¥¡£MSDE 2000 ÓÐÁ½ÖÖ°²×°»úÖÆ£º

?

ÃüÁîÌáʾ·û°²×°ÊµÓù¤¾ß (Setup.exe)¡£´Ë°²×°ÊµÓù¤¾ßͨ³£ÓÉÓ¦ÓóÌÐòµÄ°²×°ÊµÓù¤¾ßÀ´µ÷Ó㬵«Ò²¿ÉÒÔ´ÓÃüÁîÌáʾ·û´°¿ÚÀ´ÔËÐС£MSDE 2000 °²×°ÊµÓù¤¾ßûÓпÉÓÉÓû§À´¿ØÖƸÃʵÓù¤¾ßµÄÐÐΪµÄͼÐÎÓû§½çÃæ¡£µ«Ëü¿ÉÒÔ½ÓÊÜÒ»×é²ÎÊý£¬ÕâЩ²ÎÊý¶¨ÒåÁ˸ÃʵÓù¤¾ßÖ´ÐеIJÙ×÷¡£

ÖØÒª Ò»¶¨ÒªÍ¨¹ýÔËÐÐ Setup.exe À´°²×°»òÉý¼¶ MSDE ʵÀý¡£²»ÒªÊÔͼͨ¹ý .msi Îļþ¼ä½ÓÆô¶¯°²×°³ÌÐò£»ÀýÈ磬²»ÒªË«»÷ij¸ö MSDE 2000 .msi Îļþ¡£

? ?

Ò»¶¨ÒªÊ¹Óà /L*v ¿ª¹ØÉú³É°²×°³ÌÐòÈÕÖ¾Êä³öÎļþ¡£

Ò»×é Windows °²×°³ÌÐòºÏ²¢Ä£¿é¡£±àд»ùÓÚ Windows °²×°³ÌÐòµÄ°²×°ÊµÓù¤¾ßµÄ¿ª·¢ÈËÔ±¿ÉÒÔ¶ÔÓ¦ÓóÌÐòµÄ°²×°³ÌÐò½øÐбà³Ì£¬ÒÔ±ãͨ¹ýʹÓà MSDE 2000 ºÏ²¢Ä£¿éÀ´°²×° MSDE 2000 ʵÀý¡£¿ª·¢ÈËÔ±¿ÉÒÔͨ¹ýÖ¸¶¨Óë MSDE 2000 °²×°ÊµÓù¤¾ß²ÎÊýÏà¶ÔÓ¦µÄ°²×°°üÊôÐÔÀ´¿ØÖÆÒѰ²×°ÊµÀýµÄÅäÖá£

[·µ»ØÒ³Ê×]

°²×°²ÎÊý

±ØÐëͨ¹ý´ÓÃüÁîÌáʾ·ûÔËÐÐ Setup.exe À´°²×°»òÉý¼¶ÈÎÒâ MSDE ʵÀý¡£Óû§¿Éͨ¹ýÖ¸¶¨²ÎÊýÀ´¿ØÖÆ MSDE 2000 °²×°³ÌÐòµÄÐÐΪ¡£°²×°²ÎÊý¿Éͨ¹ýÏÂÁÐÁ½ÖÖ·½Ê½Ö¸¶¨£º

? ?

ÔÚÃüÁîÌáʾ·û´¦¡£

ÔÚ°²×°ÊµÓù¤¾ß½«¶ÁÈ¡µÄ .ini ÎļþÖС£

Èç¹ûÖ¸¶¨µÄ MSDE °²×°²ÎÊýÖµÖаüº¬ÌØÊâ×Ö·û£¨Èç¿Õ¸ñ£©£¬Ôò±ØÐ뽫¸ÃÖµ·ÅÔÚÒýºÅÖС£Èç¹ûûÓÐÌØÊâ×Ö·û£¬ÔòÒýºÅÊÇ¿ÉÑ¡µÄ¡£

µÚ 3.2.2¡¢3.2.3 ºÍ 3.2.4 ½ÚÌṩÁË×î³£¼ûµÄ MSDE 2000 SP4 °²×°·½°¸Ê¹ÓõIJÎÊýʾÀý¡£¿ÉÒÔΪ°²×°³ÌÐòÖ¸¶¨µÄ²ÎÊýÔÚ×îа汾µÄ SQL Server 2000 Áª»ú´ÔÊéÖÐÓÐËùÃèÊö¡£Óйذ²×°×îа汾µÄ SQL Server 2000 Áª»ú´ÔÊéµÄÐÅÏ¢£¬Çë²Î¼û 1.8 SQL Server 2000 Áª»ú´ÔÊé¸üÐÂÒÑ¿ÉÓá£ÒÔÏÂÊÇÃèÊö Setup.exe ÐÐΪµÄÓ¢Óï°æ²Î¿¼Ö÷Ì⣺Customizing Desktop Engine Setup.exe£¨×Ô¶¨Òå Desktop Engine Setup.exe£©¡£

˵Ã÷ Èç¹ûʹÓÃÖÕ¶Ë·þÎñÁ¬½Ó³¢ÊÔ½«ÏÖÓÐµÄ MSDE ʵÀýÉý¼¶µ½ MSDE 2000 SP4£¬»òÕß°²×°Ð嵀 MSDE 2000 SP4 ʵÀý£¬¿ÉÄÜ»á³öÏÖÎÊÌâ¡£Èç¹ûÓöµ½ÎÊÌ⣬Çë´Ó±¾µØ¼ÆËã»úÖØÐÂÆô¶¯°²×°³ÌÐò¡£

[·µ»ØÒ³Ê×]

ʹÓà .ini Îļþ

¿ÉÒÔÔÚ .ini ÎļþÖÐÖ¸¶¨ MSDE 2000 Setup.exe ²ÎÊý£¬.ini ÎļþµÄλÖÃÓÉ /settings ¿ª¹ØÖ¸¶¨¡£.ini ÎļþÊÇÒ»¸öÎı¾Îļþ£¬ÈçʹÓüÇʱ¾´´½¨²¢Ê¹ÓÃÀ©Õ¹Ãû .ini ±£´æµÄÎļþ¡£.ini ÎļþÖеĵÚÒ»ÐÐÊÇ [Options]¡£Äú¿ÉÒÔÔÚºóÃæÖ¸¶¨²ÎÊý£¬Ã¿ÐÐÖ¸¶¨Ò»¸ö²ÎÊý¡£

°²È«ËµÃ÷ Èç¹û°²×°Ê±Ê¹Óà .ini Îļþ£¬Çë²»Òª½«°²È«Æ¾¾Ý´æ´¢ÔÚ¸ÃÎļþÖС£ ÏÂÀý˵Ã÷ÁËÈçºÎÔÚÃüÁîÌáʾ·û´¦Ö¸¶¨²ÎÊý£º

setup SAPWD=\AStrongPassword\ INSTANCENAME=\InstanceName\TARGETDIR=\C:\\MyInstanceFolder\

ҪʹÓà .ini ÎļþÖеÄÏàͬ²ÎÊýÔËÐа²×°³ÌÐò£¬ÇëʹÓüÇʱ¾´´½¨Ò»¸öÃûΪ

MyParameters.ini µÄÎļþ£¬ÆäÄÚÈÝÈçÏ£º [Options]

INSTANCENAME=\InstanceName\ TARGETDIR=\C:\\MyInstanceFolder\

È»ºóÔÚÔËÐа²×°³ÌÐòʱ£¬Ê¹Óà /settings ¿ª¹ØÖ¸Ïò¸Ã .ini Îļþ£º

setup /settings \MyParameters.ini\ SAPWD=\AStrongPassword\

[·µ»ØÒ³Ê×]

ÇëÇó°²×°³ÌÐòÈÕÖ¾

ʹÓÃÏêϸÈÕÖ¾À´ÑéÖ¤ N °²×°ÊÇ·ñ³É¹¦£¬»òÕß°ïÖú½â¾ö³öÏÖµÄÎÊÌâ¡£

ÒªÉú³ÉÏêϸÈÕÖ¾£¬ÇëÖ¸¶¨ /L*v £¬ÆäÖÐ Êǰ²×°³ÌÐòÓÃÓڼǼËùÓвÙ×÷µÄÈÕÖ¾ÎļþµÄÃû³Æ¡£Èç¹ûÖ¸¶¨Ãû³ÆÊ±Ã»Óаüº¬Â·¾¶£¬½«ÔÚµ±Ç°Îļþ¼ÐÖд´½¨ÈÕÖ¾Îļþ¡£Èç¹ûÊÇ´Ó CD-ROM Ö´Ðа²×°³ÌÐò£¬Ôò±ØÐëÖ¸¶¨Ö¸ÏòÓ²ÅÌÉÏij¸öÎļþ¼ÐµÄÍêÕû·¾¶¡£

ÏÂÀý½«ÔÚ C: Çý¶¯Æ÷µÄ¸ùÎļþ¼ÐÖд´½¨Ò»¸öÃûΪ MSDELog.log µÄÈÕÖ¾Îļþ£º

setup SAPWD=\AStrongSAPassword\ /L*v C:\\MSDELog.log

Èç¹û°²×°³É¹¦£¬ÔÚÈÕ־ĩ⽫ÏÔʾÈçÏÂËùʾµÄÌõÄ¿£º

=== Logging stopped: 5/16/03 0:06:10 === MSI (s) (BC:7C): Product: Microsoft SQL Server Desktop Engine

-- Installation operation completed successfully.

Èç¹û°²×°Ê§°Ü£¬ÔÚÈÕ־ĩ⽫ÏÔʾÈçÏÂËùʾµÄÌõÄ¿£º

=== Logging stopped: 5/15/03 23:50:34 === MSI (c) (6A:CE): Product: Microsoft SQL Server Desktop Engine

-- Installation operation failed.

Èç¹û°²×°Ê§°Ü£¬ÇëÔÚ´íÎóÈÕÖ¾ÖÐËÑË÷×Ö·û´®¡°value 3\¡£¸Ã×Ö·û´®µÄºó 10 ÐÐÊÇÓйØ×Ô¶¨Òå²Ù×÷µÄ¹ÊÕÏ֪ͨ¡£¸Ã֪ͨÖаüº¬ÓйعÊÕÏÐÔÖʵĸ½¼ÓÐÅÏ¢¡£

[·µ»ØÒ³Ê×]

3.2.2 ½«ÏÖÓÐµÄ MSDE 2000 ʵÀýÉý¼¶µ½ MSDE 2000 SP4

±¾½ÚÖеÄʾÀýÃèÊöÈçºÎ½«ÏÖÓÐµÄ MSDE 2000 ʵÀýÉý¼¶µ½ MSDE 2000 SP4 ÒÔ¼°ÈçºÎ¶Ô¸Ã MSDE 2000 ʵÀý½ûÓÃÍøÂçÁ¬½Ó¡£Èç¹û¸ÃʵÀý±ØÐë½ÓÊÜÆäËû¼ÆËã»úÉÏÔËÐеÄÓ¦ÓóÌÐòËùÇëÇóµÄÁ¬½Ó£¬Çë²»ÒªÖ¸¶¨ DISABLENETWORKPROTOCOLS ²ÎÊý¡£ ±¾½ÚÖеÄʾÀý¼Ù¶¨ sa µÇ¼ÓÐÒ»¸öÇ¿ÃÜÂë¡£ÓÐ¹Ø sa µÇ¼ÃÜÂëµÄ¸ü¶àÐÅÏ¢£¬Çë²Î¼û 1.3 MSDE 2000 SP4 µÄ°²È«×¢ÒâÊÂÏî¡£ ½«ÏÖÓÐµÄ MSDE 2000 ʵÀýÉý¼¶µ½ MSDE 2000 SP4

1. 2.

´ò¿ªÃüÁîÌáʾ·û´°¿Ú¡£

ÔÚÃüÁîÌáʾ·û´¦£¬Ê¹Óà cd ÃüÁîµ¼º½ÖÁ°üº¬ MSDE 2000 SP4 °²×°ÊµÓù¤¾ßµÄÎļþ¼Ð£º

cd c:\\MSDESP4Folder\\MSDE

ÆäÖÐ c:\\MSDESP4Folder ÊÇÒ»¸ö·¾¶£¬ËüÖ¸Ïò½« MSDE 2000 SP4 Îļþ½âѹËõµ½µÄÎļþ¼Ð»òÕß SQL Server 2000 SP4 ¹âÅÌÉ쵀 MSDE 2000 SP4 Îļþ¼Ð¡£

3.

?

Ö´ÐÐÏÂÁÐÃüÁîÖ®Ò»£º

¶ÔÓÚʹÓà Windows Éí·ÝÑéÖ¤²¢ÇÒ½ûÓÃÁËÍøÂçЭÒéµÄĬÈÏʵÀý£¬Ö´ÐУº

setup /upgradesp sqlrun /L*v C:\\MSDELog.log

?

¶ÔÓÚʹÓà Windows Éí·ÝÑéÖ¤²¢ÇÒÆôÓÃÁËÍøÂçЭÒéµÄĬÈÏʵÀý£¬Ö´ÐУº

setup /upgradesp sqlrun

DISABLENETWORKPROTOCOLS=0 /L*v C:\\MSDELog.log

?

¶ÔÓÚʹÓà Windows Éí·ÝÑéÖ¤²¢ÇÒ½ûÓÃÁËÍøÂçЭÒéµÄÃüÃûʵÀý£¬Ö´ÐУº

setup /upgradesp sqlrun

INSTANCENAME=InstanceName /L*v C:\\MSDELog.log

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)