Changing SA password

[Clete]

I tried the following steps to change the SA password
provided by microsoft. After typing "osql -U sa" at the
command prompt the following message appears "'osql' is
not recognized as an internal or external command,
operable program or batch file." I'm running XP
professional and trying to load MSDE 2000. MSDE 2000
will not install until I create a SA password.


INFO OBTAINED FROM http://support.microsoft.com/?
kbid=322336

How to Change Your SA Password
On the computer that is hosting the instance of MSDE to
which you are connecting, open the command prompt window.
Type the following command, and then press ENTER:

osql -U sa

At the Password: prompt, press ENTER if your password is
blank or type the current password. This connects you to
the local, default instance of MSDE by using the sa
account. To connect by using Windows authentication, type
this command: use osql -E

Type the following commands, on separate lines, and then
press ENTER:
sp_password @old = null, @new = 'complexpwd',
@loginame ='sa'
go

NOTE: Make sure that you replace "complexpwd" with the
new strong password. A strong password includes alpha-
numeric and special characters, and a combination of
upper and lower case characters.

You will receive the following informational message,
which indicates that your password was changed
successfully:

Password changed.

 

[Fritz]

This has nothing to do with XP security.
Read the manual for MSDE. It tells you how to setup the INI file install
options.

 

[Star Fleet Admiral Q]

1) This is not an XP issue,
2) This is not an MSDE issue,
3) OP needs to review the install "command" line options for MSDE - SA
password (non-null) must be supplied on the command line:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"