Change Password


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Change Password

  1. #1
    rkbnair Guest

    Change Password


    I want to change the password of a login user. So I pulled the password information
    from the syslogin table(after login in as 'sa') and ran the sp_password stored
    procedure.

    exec sp_password '" + IIf(IsNull(rsLogin.Fields("password").Value) = True,
    Null, rsLogin.Fields("password").Value) + "', 'ocean','User A'"


    This didn't work. It says the old password is wrong. When I went in the debug
    mode, it showed the old password value but in unreadable fashion.

    Help please.


  2. #2
    David Satz Guest

    Re: Change Password

    If you are logged in as 'sa', then just do something that shown in BOL:
    EXEC sp_password NULL, 'ok', 'Victoria'
    use NULL for the old password

    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions
    { SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
    (Please reply to group only - emails answered rarely)
    -----------------------------------------------------------------
    "rkbnair" <rkannale@solus.oceaneering.com> wrote in message
    news:3c8e093a$1@10.1.10.29...
    >
    > I want to change the password of a login user. So I pulled the password

    information
    > from the syslogin table(after login in as 'sa') and ran the sp_password

    stored
    > procedure.
    >
    > exec sp_password '" + IIf(IsNull(rsLogin.Fields("password").Value) = True,
    > Null, rsLogin.Fields("password").Value) + "', 'ocean','User A'"
    >
    >
    > This didn't work. It says the old password is wrong. When I went in the

    debug
    > mode, it showed the old password value but in unreadable fashion.
    >
    > Help please.
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center