• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 789
  • Last Modified:

Upgrading to MSDE SP4

I'm currently running an instance of MSDE SP3 on Windows Server 2003. Only one instance is running and it's the default instance. I verified the method of installation and am trying to upgrade to SP 4 by running the file sql01P.msp. However, when I run it I get a message that the current SA password is blank and to set BLANKSAPWD=1 to ignore this vulnerability. I'm not a DBA so I don't know how to do this off the top of my head. I searched for documentation but haven't found anything of any help. Please provide guidance for this. Also, because of the application that's using it the SA password has to be blank, so please don't recommend configuring a password for this. Thank you.
MSDE-Message.JPG
0
mcpp661
Asked:
mcpp661
1 Solution
 
James MurrellProduct SpecialistCommented:
To resolve this issue, run the update of SP4 by using the following command (Figure 3):

setup /upgradesp sqlrun INSTANCENAME=BKUPEXEC blanksapwd=1 /L*v C:\MSDELog.log

0
 
mcpp661Author Commented:
Thank you. I tried running it but nothing happens. The instance that's running is unnamed, so do I just type "INSTANCENAME="? Also, is the switch /upgradesp or just /p? Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now