cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
608
Views
0
Helpful
0
Comments
TCC_2
Level 10
Level 10

Core Issue

This is a known issue related to Microsoft SQL Desktop Edition (MSDE) upgrades.

Resolution

If the Instance name is invalid error message appears during the installation of the MSDE Service Pack 3 (SP3), perform this procedure:

  1. Browse to the folder where the MSDE service pack files were extracted.
  2. Browse to the MSDE directory.
  3. Right-click the setup.exe file and choose Create Shortcut.
  4. Right-click the shortcut to setup.exe and choose Properties.
  5. In the Target field, add /upgradesp sqlrun blanksapwd=1 after setup.exe.

    For example, if the files were extracted to c:\temp, the string is c:\temp\sql2ksp3\MSDE\setup.exe /upgradesp sqlrun blanksapwd=1.

  6. Click OK.
  7. Double-click the shortcut to setup.exe to run the upgrade.

For more information, refer to the Instance name is invalid  Error (MSDE Only) section of Cisco Unity 3.x and 4.0 Are Vulnerable to W32.Slammer Worm.

There is also a manual uninstallation process for SQL documented in the following Microsoft article (in case part of the uninstallation has failed in some way): How to manually remove SQL Server 2000 default, named, or virtual instance

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: