Error upgrading MSDE (SP3) to SP4

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Error upgrading MSDE (SP3) to SP4

Author

Topic

vetaal
Starting Member

3 Posts

Posted - 2006-06-13 : 10:04:53

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 not 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\MSSQL

The sqlserver.exe is in C:\Program Files\Microsoft SQL Server\MSSQL\Binn and version = 2000.80.760.0

To upgrade MSDE 2000 (SP3) to MSDE SP4, I downloaded this file from Microsoft's website: SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

I 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:
MSSQLSERVER

Now, I ran this command:

setup SAPWD="ourpassword" SECURITYMODE=SQL
/L*v C:\MSDELog.log

This came with the error - Invalid Instance

I tried running:
setup /upgradesp sqlrun /L*v C:\MSDELog.log
This command ran and did not show any error. I then rebooted the machine, checked that the MSSQLSERVER service is running and checked the version of sqlserver.exe but it was still the same (2000.80.760.0). It should have been 8.00.2039

I am not sure what am I missing. All I want to do is update the MSDE Service Pack on our company machines to SP4.

Please help !

Kristen
Test

22859 Posts

Posted - 2006-06-13 : 10:55:52

Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67708

cmdr_skywalker
Posting Yak Master

159 Posts

Posted - 2006-06-13 : 23:26:02

there seems to be a loop in the link. Anyway,
1. identify which instance you want to upgrade. Make sure the services are running (MSSQLSERVER and MSSQLSERVER$XXX services). Run the following in your command prompt to see the list: OSQL -L
C:\WINNT>osql -L
Servers:
(local)
MATRIX\TESTINST

2. Once since you are performing an upgrade, you should run the setup as upgrade (see the SP4 readme). In our eample, I want to upgrade the MATRIX\TESTINST.

setup /upgradesp sqlrun INSTANCENAME=MATRIX\TESTINST SECURITYMODE=SQL UPGRADEUSER=sa
UPGRADEPWD=AdminPassword /L*v C:\MSDELog.log

if you don't specify an instance, it will use the default (MSSQLSERVER). Make sure that the service is running so it will detect that instance.

May the Almighty God bless us all!

cmdr_skywalker
Posting Yak Master

159 Posts

Posted - 2006-06-14 : 00:55:44

By the way, its MSSQL$(InstanceName) :).

May the Almighty God bless us all!

vetaal
Starting Member

3 Posts

Posted - 2006-06-19 : 13:32:12

My machine does not have any instances.

I tried the osql - l command and it came up with bunch of server names. I did not sse anything that appeared similar to (MATRIX\TESTINST) or (servername\instancename).

In my services list, I have 2 services that I see:
MSSQLSERVER(Auto and started)
and MSSQLServerADHelper (manual and not started).

Well, I used a different command line option:
C:\SQL2KSP4\MSDE>
Setup.exe UPGRADE=1 SECURITYMODE=SQL UPGRADEUSER=SA UPGRADEPWD=OURPassword /L*v C:\msde.log

After running the upgrade, I got an error dialog showing - "upgrade process failed". But, when I looked in the MSDE.log it showed:
Product: Microsoft SQL Server Desktop Engine -- Installation operation completed successfully.

Also, the sqlservr.exe, sqlagent.exe, under C:\Program Files\Microsoft SQL Server\MSSQL\Binn now show:
Version = 2000.80.2039.0 [This is the SP4 version]

I do not want to use this as a solution because I know that it came with a failed message and moving forward if we upgrade to SP5, I really do not want any possible issues.

Any thoughts?

cmdr_skywalker
Posting Yak Master

159 Posts

Posted - 2006-06-20 : 15:56:20

The (MATRIX\TESTINST) is just an example. You should see your machine appended to char "\" and to the instance name (example MATRIX\TestInst where the workstation name is MATRIX and TestInst is the SQL Instance I am trying to upgrade). Try the commandline that I specified, replacing the correct parameter values. You can replace the [bold]sqlrun[/bold] with [bold]all[/bold] keyword. Read the MSDE readme.html for more information.

May the Almighty God bless us all!

spgalvin
Starting Member

1 Post

Posted - 2007-03-01 : 12:50:30

I used just
setup /upgradesp sqlrun SECURITYMODE=SQL

to resolve this issue. So not specifying the instance assumes the local instance which is the only one I had on the pc.

Thanks for the post.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources