Re: How user can change their password with sp_password.

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 08/22/03 

Date: Fri, 22 Aug 2003 10:05:27 GMT

I agree with Sue. Only members of the sysadmin role can change the password
for another user’s login.

If user wants to change their password then they do not need to put 'Login
Name' in the sp_password syntax.
They should use the foll. syntax

sp_password 'oldpassword', 'Newpassword'

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Relevant Pages

  • Re: How user can change their password with sp_password.
    ... Only members of the sysadmin role can change the password ... > for another user?s login. ... > Name' in the sp_password syntax. ... > SQL Server Developer Support Engineer, MCDBA, MCSE, MCT ...
    (microsoft.public.sqlserver.security)
  • Re: Other way of Changing Password if does not have Server Role
    ... A user can change his password without being a member of the sysadmin role. ... You just have to login as the user and then omit the 3rd parameter ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Steve Perkins advice!
    ... the syntax SELECT * FROM [tablename] ... Nothing special comes wen i type it into the password and login ID(I ... dint type exactly the same thing since its the syntax, ... Just invalid password or Login appears, ...
    (alt.2600)
  • Re: Variables in SQL-script SQL2005
    ... Not all DCL commands accept variables (see BOL syntax) so you'll need to use dynamic SQL. ... DECLARE @SqlStatement nvarchar; ... N'CREATE LOGIN ' + ... DECLARE @brugernavn as char ...
    (comp.databases.ms-sqlserver)
  • RE: cannot log into Reporting Services from SMSS
    ... When you say in SMSS select Server name...Server roles, ... "sysadmin" role was already checked for that login. ... I installed the ReportServer as part of a full installation of SQL Server ... Please add a domain user as a new login and grant it sysadmin role. ...
    (microsoft.public.sqlserver.connect)