Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2081
  • Last Modified:

Getting "the instance name specified is invalid" when trying to install SP4

Hello Experts!

I am trying to install Service Pack 4 for MS SQL Server 2000 on a Windows Server 2003 Standard Edition OS.  I have tried both "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" (extracted to C:\SQL2KSP4_MSDE) and "SQL2000-KB884525-SP4-x86-ENU.EXE" (extracted to C:\SQL2KSP4).  When I try running setup.exe from the MSDE folder inside either directory, I get the following error:
"the instance name specified is invalid"  If I disable all the SQL services before install, I still get the error.

Any help getting this installed would be greatly appreciated.  Thank you!
0
mb2010
Asked:
mb2010
  • 3
  • 2
  • 2
1 Solution
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
and is your server 32 bit or 64 bit? That will make a difference as well.
0
 
mb2010Author Commented:
The solution to that post says "You need : SQL2000-KB884525-SP4-x86-ENU.EXE if you have a 32 bit processor."  Yes, I have a 32 bit processor, and yes that is the version I am trying to use, but still getting the error.

 I read here http://www.eggheadcafe.com/software/aspnet/30762764/the-instance-name-specifi.aspx that the patch can be ran from the command line and the instance name has to be specified.  However, I am not clear on the exact command to run.  I have two instances under SQL Server group: "(local) (Windows NT)" and "CAAH01-ILS724\BKUPEXEC (Windows NT)".  I hope that helps.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
mb2010Author Commented:
Thought I'd post again to see if any new suggestions come in.
0
 
Jim P.Commented:
>> I have two instances under SQL Server group:

The (local) would be CAAH01-ILS724.

I've seen this as a solution elsewhere. With SQL 7 & then 2000 the original install without the service packs could have the SA user ID with a blank password. The SP wouldn't install because the SA was blank. You may not use SA but it still has to have a password.

Use the following command  to change the password:

sp_password @old = null, @new = 'complexpwd',  @loginame ='sa'
   go

http://support.microsoft.com/kb/322336
0
 
mb2010Author Commented:
Many thanks Jimpen.  That worked!

For others looking at this solution, here is how to change the SA password through the GUI:

http://nsit.uchicago.edu/services/technicaltools/windows/mssql/
0
 
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now