Jack Dee
asked on
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
"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!
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
"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!
and is your server 32 bit or 64 bit? That will make a difference as well.
ASKER
The solution to that post says "You need : SQL2000-KB884525-SP4-x86-E
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.
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.
ASKER
Thought I'd post again to see if any new suggestions come in.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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/
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/
Glad to be of assistance. May all your days get brighter and brighter.
https://www.experts-exchange.com/questions/21861171/Installing-Service-Pack-4-Error-The-instance-name-specified-is-invalid.html