MSDE Upgrade

Last Post 09 Nov 2005 01:05 PM by drbits. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Koby
New Member
New Member

--
05 Sep 2005 06:36 AM
Hi,

I am tring to upgrade MSDE Release 3A Upgrade to SP4 but it always fail, I did check the registry for the product code and the package name and there is no problem with it, it is the SqlRun01.msi package, so there shouldn't be any problem with it.

I went also over the log and still can't see anything wrong there.

Can you please give your advise?

Koby Asaraf
Aladdin Knowledge Systems
DBA
Koby
New Member
New Member

--
06 Sep 2005 02:24 AM
I used SQL authentication with a NT administrator user which has full rights.

This is the error I saw in the log file but I don't understand what it means:

MSI (s) (28!94) [20:37:32:290]: Closing MSIHANDLE (1728) of type 790531 for thread 1684
MSI (s) (28!94) [20:37:32:478]: Creating MSIHANDLE (1729) of type 790531 for thread 1684
PerfmonLoad routine returned error code 267
MSI (s) (28!94) [20:37:32:478]: Closing MSIHANDLE (1729) of type 790531 for thread 1684
MSI (s) (28:54) [20:37:32:478]: Closing MSIHANDLE (1722) of type 790536 for thread 3756

Now, what a small DBA like me can do with such an error, I don't understand it, but moreover, when I look at the SQL version after the failure I can see that it was upgraded, but, doesn't it rolledback?! well, that is a realy strage situation, and I have checked it on several machines and they all work the same and give the same error.

this is what I did to operate the SP4 upgrade(without the password of course):
C:\SQL2KSP4\MSDE\setup.exe /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD= /Lex C:\MSDELog.log

Koby Asaraf
Aladdin Knowlege Systems
DBA
drbits
New Member
New Member

--
09 Nov 2005 01:05 PM
SP4 is intended for SQL Server running on a Windows server. I don't think it works for MSDE.


Acceptable Use Policy
---