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

?

¶ÔÓÚʹÓûìºÏģʽÉí·ÝÑéÖ¤²¢ÇÒ½ûÓÃÁËÍøÂçЭÒéµÄĬÈÏʵÀý£¨ÆäÖУ¬AnAdminLogin ÊÇ sysadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±£©£¬Ö´ÐУº

?

setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin

UPGRADEPWD=AdminPassword /L*v C:\\MSDELog.log

?

¶ÔÓÚʹÓûìºÏģʽÉí·ÝÑéÖ¤²¢ÇÒ½ûÓÃÁËÍøÂçЭÒéµÄÃüÃûʵÀý£¨ÆäÖУ¬AnAdminLogin ÊÇ sysadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±£©£¬Ö´ÐУº

?

setup /upgradesp sqlrun INSTANCENAME= InstanceName SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin

UPGRADEPWD=AdminPassword /L*v C:\\MSDELog.log

4. 5.

ΪÁ˱ãÓÚÔĶÁ£¬ÔÚÕâЩʾÀýÖмÓÈëÁË»»Ðзû¡£Ö´ÐеÄÃüÁî²»ÄܰüÀ¨»»Ðзû¡£ ˵Ã÷ Èç¹ûËùÉý¼¶µÄ MSDE 2000 ʵÀýÊÇÒÔǰʹÓÃÔçÆÚµÄ SQL Server 2000 Service Pack ´Ó MSDE 1.0 Éý¼¶¶øÀ´µÄ£¬±ØÐ뻹ҪÔÚ°²×°ÃüÁîÖÐ×·¼Ó

UPGRADE=1¡£

6.

°²È«ËµÃ÷ Èç¹û°²×°Ê±Ê¹Óà .ini Îļþ£¬Çë²»Òª½«Æ¾¾Ý´æ´¢Ôڸà .ini ÎļþÖС£

[·µ»ØÒ³Ê×]

3.2.3 °²×°Ð嵀 MSDE 2000 SP4 ʵÀý

±¾½ÚÖеÄʾÀýÃèÊöÈçºÎ°²×°ÒÑÅäÖÃΪ½ûÓÃÍøÂçÁ¬½Ó£¨Ä¬ÈÏÐÐΪ£©µÄРMSDE 2000 SP4 ʵÀý¡£Èç¹û¸ÃʵÀý±ØÐë½ÓÊÜÔÚÆäËû¼ÆËã»úÉÏÔËÐеÄÓ¦ÓóÌÐòÇëÇóµÄÁ¬½Ó£¬±ØÐ뻹Ҫָ¶¨ DISABLENETWORKPROTOCOLS=0¡£

ÒÔÏÂʾÀýʹÓÃËùÓÐÅäÖÃÏÈçÅÅÐò¹æÔòºÍÎļþλÖ㩵ÄĬÈÏÉèÖð²×°ÊµÀý¡£ÕâЩÅäÖÿÉÒÔÓɰ²×°²ÎÊý£¨Èç COLLATION¡¢DATADIR ºÍ TARGETDIR£©À´¿ØÖÆ¡£ÓйØÔÚ°²×°Ê±¿ÉÒÔÖ¸¶¨µÄÅäÖòÎÊýµÄ¸ü¶àÐÅÏ¢£¬Çë²Î¼û Customizing Desktop Engine Setup.exe£¨×Ô¶¨Òå Desktop Engine Setup.exe£©¡£ °²×°Ð嵀 Desktop Engine ʵÀý

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 SAPWD=\AStrongSAPwd\ /L*v C:\\MSDELog.log

ÆäÖУ¬AStrongSAPwd ÊÇΪ sa µÇ¼ָ¶¨µÄÇ¿ÃÜÂë¡£

?

Òª°²×°±»ÅäÖÃΪʹÓà Windows Éí·ÝÑéÖ¤µÄÃüÃûʵÀý£¬ÇëÖ´ÐУº

?

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

ÆäÖУ¬AStrongSAPwd ÊÇΪ sa µÇ¼ָ¶¨µÄÇ¿ÃÜÂ룬InstanceName ÊÇΪ¸ÃʵÀýÖ¸¶¨µÄÃû³Æ¡£

? Òª°²×°±»ÅäÖÃΪʹÓûìºÏģʽÉí·ÝÑéÖ¤µÄĬÈÏʵÀý£¬ÇëÖ´ÐУº

?

setup SAPWD=\AStrongSAPwd\ SECURITYMODE=SQL

/L*v C:\\MSDELog.log

ÆäÖУ¬AStrongSAPwd ÊÇΪ sa µÇ¼ָ¶¨µÄÇ¿ÃÜÂë¡£

?

Òª°²×°±»ÅäÖÃΪʹÓûìºÏģʽÉí·ÝÑéÖ¤µÄÃüÃûʵÀý£¬ÇëÖ´ÐУº

?

setup INSTANCENAME=\InstanceName\ SECURITYMODE=SQL

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

ÆäÖУ¬AStrongSAPwd ÊÇΪ sa µÇ¼ָ¶¨µÄÇ¿ÃÜÂ룬InstanceName ÊÇΪ¸ÃʵÀýÖ¸¶¨µÄÃû³Æ¡£

ÖØÒª Èç¹û°²×°Ê±Ê¹Óà .ini Îļþ£¬Çë²»Òª½«Æ¾¾Ý´æ´¢Ôڸà .ini ÎļþÖС£ ÖØÒª ¼´Ê¹ÊµÀý±»ÅäÖÃΪʹÓà Windows Éí·ÝÑéÖ¤£¬Ò²ÇëʼÖÕΪ sa µÇ¼ָ¶¨Ò»¸öÇ¿ÃÜÂë¡£ [·µ»ØÒ³Ê×]

3.2.4 ½« MSDE 1.0 Éý¼¶µ½ MSDE 2000 SP4

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

MSDE 1.0 Óë MSDE 2000 µÄĬÈÏʵÀýµÄÔËÐз½Ê½Ïàͬ£¬ÇÒ×ÜÊÇÉý¼¶Îª MSDE 2000 ĬÈÏʵÀý¡£

˵Ã÷ ¸´ÖÆÍØÆËÖÐµÄ MSDE 1.0 ʵÀýÎÞ·¨Éý¼¶µ½ MSDE 2000 SP4¡£ ½« MSDE 1.0 ʵÀýÉý¼¶µ½ 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 Éí·ÝÑéÖ¤µÄ MSDE 1.0 ʵÀýÉý¼¶£¬ÇëÖ´ÐУº

?

setup UPGRADE=1 DISABLENETWORKPROTOCOLS=1 /L*v C:\\MSDELog.log

?

Èç¹û´ÓʹÓûìºÏģʽÉí·ÝÑéÖ¤µÄ MSDE 1.0 ʵÀýÉý¼¶£¨ÆäÖУ¬AnAdminLogin

ÊÇ sysadmin ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ³ÉÔ±£©£¬ÇëÖ´ÐУº

?

setup UPGRADE=1 SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin UPGRADEPWD=AdminPassword DISABLENETWORKPROTOCOLS=1 /L*v C:\\MSDELog.log

?

ÖØÒª Èç¹û°²×°Ê±Ê¹Óà .ini Îļþ£¬Çë²»Òª½«Æ¾¾Ý´æ´¢Ôڸà .ini ÎļþÖС£ °²È«ËµÃ÷ Ç¿ÁÒ½¨ÒéÄú²»ÒªÊ¹Óÿհ×ÃÜÂ룬ÒòΪ¿Õ°×ÃÜÂë»á´ó´óÔö¼Ó°²È«Òþ»¼¡£ ˵Ã÷ Èç¹ûʹÓà BLANKSAPWD=1£¬Ôò²»±ØÖ¸¶¨ SECURITYMODE=SQL »ò

UPGRADEUSER Óë UPGRADEPWD¡£

[·µ»ØÒ³Ê×]

3.3 ÖØÐÂÆô¶¯·þÎñºÍÓ¦ÓóÌÐò

Íê³É°²×°ºó£¬¿ÉÄÜ»áÌáʾÄúÖØÐÂÆô¶¯ÏµÍ³¡£3.1.3 ÔÚÔËÐÐ MSDE 2000 SP4 °²×°

³ÌÐò֮ǰֹͣ·þÎñºÍÓ¦ÓóÌÐòÖÐÌṩÁËÓйغÎʱ±ØÐëÖØÐÂÆô¶¯µÄ×¼Ôò¡£ÔÚÏµÍ³ÖØ

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