MSDE Upgrade

Last Post 09 Nov 2005 02:05 PM by drbits. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Koby
New Member
New Member

--
05 Sep 2005 07: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 03: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 02:05 PM
SP4 is intended for SQL Server running on a Windows server. I don't think it works for MSDE.
You are not authorized to post a reply.

Acceptable Use Policy