Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vetaal
Starting Member
3 Posts |
 Posted - 2006-06-13 : 09:59:52
|
| I am trying to upgrade my MSDE 2000 (SP3)to SP4, but it is giving an error of "invalid instance".Here is what is on the machine (before running any commands):I do see any SQL Server installation on my machine under Start-All Programs. But, I have a directory for SQL Server under:C:\Program Files\Microsoft SQL Server\MSSQLThe sqlserver.exe is in C:\Program Files\Microsoft SQL Server\MSSQL\Binn and version = 2000.80.760.0To upgrade MSDE 2000 (SP3) to MSDE SP4, I downloaded this file from Microsoft's website: SQL2000.MSDE-KB884525-SP4-x86-ENU.EXEI ran the above .exe and extracted the files on my hard drive. Now, I have the C:\SQL2KSP4\MSDE directory and the Setup.exe is in the MSDE directory.I looked in the services and stopped the following service:MSSQLSERVERNow, I ran this command:setup SAPWD="ourpassword" SECURITYMODE=SQL/L*v C:\MSDELog.logThis came with the error - Invalid InstanceI tried running:setup /upgradesp sqlrun /L*v C:\MSDELog.log I rebooted and checked the version of sqlserver.exe but it was still the same (2000.80.760.0)I am not sure what am I missing. All I want to do is update the MSDe on our company machines to SP4.Please help ! |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
|
|
|
|
|
Error upgrading MSDE to SQLSP4