August 9, 2005 at 9:56 am
The upgrade seems to be detecting that I don't have an SA password although I do. So I was always rec'g error "UpgDetectBlankSALogin - return value 3." Then I put in syntax of BLANKSAPWD=1 just to see what it would do and I've gotten past the "UpgDetectBlankSALogin" error but now I get an error "Unable to execute scripts" which is true because I do have an SA password.
How can I get the upgrade to be successful on my target that has a password AND a database sitting there?
FYI - here's the syntax used:
C:\SQL2KSP4\MSDE\SETUP.EXE /upgradesp SQLRUN INSTANCENAME=ACME SECURITYMODE=SQL SAPWD=pwd BLANKSAPWD=1 REBOOT=FORCE /L*v c:\msde_sp4Upg.log
August 10, 2005 at 9:09 am
One thought although I'll probably get ripped for this suggestion. I had a similar situation a while back that was giving me fits while trying to upgrade MSDE on a laptop. The only thing I could do to get it to work was to temporarily set the SA password to blank, run the upgrade, then reset the SA password. I made sure the device was off the network at the time so nothing else could connect so I felt safe doing this. Hope this helps.
My hovercraft is full of eels.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply