Re: Changing SA password
From: Star Fleet Admiral Q (Star_Fleet_Admiral_Q(NOSPAM)_at_(SPAMNOT)hotmail.com)
Date: 09/24/04
- Next message: James Wilson: "Alerts by email"
- Previous message: George: "Is there a way to recover from "fixmbr" and "fixboot"?"
- In reply to: Clete: "Changing SA password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 23 Sep 2004 20:15:00 -0400
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"
-- Star Fleet Admiral Q @ your service ************************************************* "Clete" <cschroeder@metropolitanloan.com> wrote in message news:47f301c4a171$e3628ec0$a501280a@phx.gbl... >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.
- Next message: James Wilson: "Alerts by email"
- Previous message: George: "Is there a way to recover from "fixmbr" and "fixboot"?"
- In reply to: Clete: "Changing SA password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
