MSDE Update error
-
Product code (existing registry) E09B48B5-E141-427A-AB0C-D3605127224A (=SqlRun01.msi) Version 8.00.760 (=SP3) with Windows XP Pro, Trying to update Desktop SQL with MSDE SQL2000.MSDE-KB884525-SP4-x86-ENU.exe.
receiving message "The Instance Name Specified is Invalid" on a different computer I do not encounter this error. Am I missing a registry entry? Any help would be appreciated. Thanks
SP4 should not be contingent on SP3a should it?
-
I would check to see if the MSDE you're attempting to upgrade is a named instance (Look in Services for something like MSSQL$InstanceName.) If it is a named instance, you need to specify that with the INSTANCENAME parameter to the setup command or in the ini file.
Also, I'd carefully read (or re-read) the Service Pack 4 Readme available on the SP4 download page, especially section 3.2.2 Upgrading Existing Instances of MSDE 2000 to MSDE 2000 SP4.
SP4 doesn't depend on any previous service pack, so you're okay there.
Hope this helps.
-- J.Kozloski, MCDBA, MCITP
-
Thanks for the info. Instance name fine. I was able to resolve the problem by adding "/UPGRADESP SQLRUN" to the setup at a command prompt and it installed fine.
Beats me! -
This is a ramification of the sqlslammer fix which was applied by the early SP package. If you had no SP's applied, then SP4 would install seemlessly.
To resolve the error: "The instance name specified is invalid" you need to have a non-blank SA password.
You then need to call setup from the command prompt and supply the SA password (SAPWD):
setup /UPGRADESP SQLRUN SAPWD=relevantads.com
Of course replace the value above with your own SA password.
Hope this helps.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply