Installing Service Pack 4: Error : The instance name specified is invalid


I am trying to install service pack 4 for sql 2000.  When I run the setup.exe file I am getting a pop up which says-

Microsoft SQL Server Desktop Engine
!  The instance name specified is invalid.

Any ideas?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gnosticgnowledgeAuthor Commented:
Oh. I installed Service Pack 3a without issue, and rebooted the server.  I am still getting the above error.

Ok - have you verified that the sp4 is for your version of SQL Server? It is not for Analysis Server, etc? It is for either 32-bit or 64-bit (depends on your server)
Make sure you're using this file... SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

That's assuming you have MSDE... if you don't, that's the problem... you have this version instead of the SQL Server version of the service pack.
I am assuming that the user is trying to install a SQL Server service pack 4 - if this is an MSDE then we have different issues.
gnosticgnowledgeAuthor Commented:
Yes.  This is SQL Server 2000.
gnosticgnowledgeAuthor Commented:
Sorry to ask a stupid question, what the hell is Analysis Server?  This is just an Enterprise Edition of SQL 2000.  
gnosticgnowledgeAuthor Commented:
Yes we used the SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

The exe from this what is causing the problem....
That is the wrong file for the Enterprise Edition...

You need : SQL2000-KB884525-SP4-x86-ENU.EXE if you have a 32 bit processor.

Go to the link above, scroll to the bottom and download the proper version.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
By the way Analysis Server is the Data Warehouse service for SQL Server
gnosticgnowledgeAuthor Commented:
SQL2000-KB884525-SP4-x86-ENU.EXE :  This is for Analysis Server.  Not SQL 2000.   I am running a 32bit processor.
SQL2000-KB884525-SP4-x86-ENU.EXE, no I assure you this file applys the SP4 patch. I have done it so many times already. You can get it at the link above.

Keep in mind, the exe unpacks to a folder called C:\SQL2KSP4. You will then have to run the setup.bat file from there.
gnosticgnowledgeAuthor Commented:
thank you.  my fault.  No attention to detail, I downloaded the wrong file.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.