Changing SA password

From: Clete (cschroeder_at_metropolitanloan.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 06:33:19 -0700

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.

Relevant Pages

  • Re: Changing SA password
    ... Read the manual for MSDE. ... It tells you how to setup the INI file install ... > command prompt the following message appears "'osql' is ... open the command prompt window. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Changing SA password
    ... OP needs to review the install "command" line options for MSDE - SA ... After typing "osql -U sa" at the ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Returning error codes from OSQL
    ... I don't have a single command that I run thru osql. ... commands in an sql script which I'm invoking thru osql. ... >> Any help in retrieving the error code from the SQL script back from ...
    (microsoft.public.sqlserver.tools)
  • Re: How do I import/export databases in MSDE?
    ... What originally screwed me up in OSQL was that is wasn't clear that the ... commands were batched and that one must issue a "GO" command. ... > the detach/attach technique works different, and requires you to detach the ... > transaction log file) to the destination server, ...
    (microsoft.public.sqlserver.msde)
  • Re: Cannot Install DB
    ... Thats got it..with the OSQL -E it worked fine thru cmd.. ... > So perhaps you are not connected to the MSDE rathjer than to a SQL Server. ... > this on the command line: ... >>> HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver.msde)
Loading