MSDE Install

Running MSDE 2000 Rel A install with the following information:
[Setup.ini File]
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
Step 2: Reboot -- Ensure service starts.
Step 3: Extract Service Pack 4
Step 4: Run Service Pack 4 for MSDE
Step 5: Error on install of Service Pack 4 -- Specified 'Instance Name could
not be found'
Any work-arounds for Step 5 ?
Uninstalling MSDE 2000 Rel a does not uninstall all registry entrys, and
rerunning the setup files does not work and gives the following error:
'Specified Instance Name' could not be found.
Seems to work fine by taking a previous system restore point...
Are they bugs ?
I launched the MSDE 2000 Rel A(SP3) install with the following command line:
setup.exe SAPWD="sa" INSTANCENAME="Image_Archive" DISABLENETWORKPROTOCOLS=1
SECURITYMODE=SQL
After reboot the MSDE works fine.
Downloading and extract SP4 for MSDE and try to launch with the following
command line will failed:
setup.exe /upgradesp sqlrun INSTANCENAME="Image_Archive" SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=sa /L*v C:\MSDESP4Install.log
The error message that displayed:
"This product is not installed. Check if a appropiate instance of MSDE is
installed."
Ok button.
After this installation failure I try on a clean machine to install MSDE SP3
without instance name:
setup.exe SAPWD="sa" DISABLENETWORKPROTOCOLS=1 SECURITYMODE=SQL
After reboot the MSDE works fine.
Launch the SP4 with the following command line will success:
setup.exe /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=sa
/L*v C:\MSDESP4Install.log
So my question is the same: Is this a bug?
It seems to me that with instance name doesn't work the upgrade or I'm
missed somewhere.
|||hi,
Ketchup wrote:
> setup.exe /upgradesp sqlrun INSTANCENAME="Image_Archive"
> SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=sa /L*v
> C:\MSDESP4Install.log
try INSTANCENAME=Image_Archive
without quotes..
seem to remember this solved the problem last time I upgraded a named
instance to sp4
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you Andrea!That's the solution.
"Andrea Montanari" wrote:

>try INSTANCENAME=Image_Archive
> without quotes..