eval sp2, sp_password?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just downloaded the XPe/SP2 eval kit. The process is to install SP1 tools
and the DB and then upgrade to SP2. When I tried to upgade the DB Engine,
the installer complained that my SA password was set to blank. Of course, I
was never given a chance to create this password but I was told I must use
sp_password to make the password stronger or set BLANKSAPWD=1. I assume
these are references to SQL server admin functions that I am not aware of in
the XPe distribution. Creating the environment variable BLANKSAPWD=1 didn't
help (bad guess), and the readme for whatever was included in SQL had no
reference to this issue. Can someone tell me how to proceed since the
installer refuses to upgrade my DB engine?
 
One way is, to go to the SQLMSDE directory on the XPe Service Pack 2 CD and
run the setup with the switch to set the SAPWD.

Command would be

setup SAPWD="insert a SA-Password"

Not recommended but you can ignore the SA Password by using the switch
BLANKSAPWD=1

This is all documented in the sp3readme.htm file located in the SQLMSDE
directory.
 
Sorry, I didn't put the whole run command in, it woud be........

setup /upgradesp sqlrun sapwd="insert your password"


-Scott Figg
 
Sam,
I just downloaded the XPe/SP2 eval kit. The process is to install SP1
tools
and the DB and then upgrade to SP2. When I tried to upgade the DB Engine,
the installer complained that my SA password was set to blank. Of course,
I
was never given a chance to create this password but I was told I must use
sp_password to make the password stronger or set BLANKSAPWD=1. I assume
these are references to SQL server admin functions that I am not aware of
in
the XPe distribution. Creating the environment variable BLANKSAPWD=1
didn't
help (bad guess), and the readme for whatever was included in SQL had no
reference to this issue. Can someone tell me how to proceed since the
installer refuses to upgrade my DB engine?
Click to expand...

You don't necessarily need to upgrade the DB engine (IIRC, it is either the
same version of MSDE or just latest SP for MSDE).
You can safily skip that step.

KM
 
Back
Top