Re: Changing SA password
From: Fritz (fritz_at_biteme.net)
Date: 09/23/04
- Next message: Ole: "Re: XP sp2 enhanced virus protection"
- Previous message: Clete: "Changing SA password"
- In reply to: Clete: "Changing SA password"
- Next in thread: Star Fleet Admiral Q: "Re: Changing SA password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 23 Sep 2004 09:49:32 -0400
This has nothing to do with XP security.
Read the manual for MSDE. It tells you how to setup the INI file install
options.
"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: Ole: "Re: XP sp2 enhanced virus protection"
- Previous message: Clete: "Changing SA password"
- In reply to: Clete: "Changing SA password"
- Next in thread: Star Fleet Admiral Q: "Re: Changing SA password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
