Re: Sp_changepassword

errr...nevermind. i must have been missing a quote or something.

"Jason" wrote:

thanks

one follow up, i noticed that using the 3rd option with sysadmin rights,
worked unless i put a special character in the passwork like a *, the it
failed. why was that?

"Erland Sommarskog" wrote:

Jason (Jason@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I found this sp_changepassword in BOL as non GUI way to change the
password. But my ‘test’ user won’t work because its not a sysadmin.
That is intentional.
I get Only members of the sysadmin role can use the loginame option. The
password was not changed.
However my ‘test’ user can do it via the EM GUI.

So how should users be instructed to change their password, is the EM GUI
the only option?

No, they can use sp_password.

sp_password 'oldbadpw', 'neW&muCH$Tr0nG€r'

What they cannot is to specify the the third parameter, not even with
their own username.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: permissions required for executing CDOSys stored procedures
    ... he is by default member of the sysadmin server ... role on the SQL Server database unless steps are taken to prevent that. ... sysadmin and who has not been granted specific execute permissions on the ... it is possible to GRANT EXECUTE ON sp_OACreate TO ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint index problems in SQL Server.
    ... The Administrator account is a sysadmin and have all the access to all the ... > database is master and language US_English? ... >> I've set back the account localsystem for both SQL Server and Microsoft ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Move or Setup of SQL Database toa Remote Server Fails
    ... as well as have SysAdmin privileges on the DB. ... Registered type 501ST MASTER for 501ST SCCM1DB\master ... Could not connect SQL Server 'master' db. ... The SCCM Primary Site Computer Account and the User account I am using ...
    (microsoft.public.sms.setup)
  • Re: order of columns
    ... If you are sysadmin, you will be able to set an option that will allow you to perform direct ... Tibor Karaszi, SQL Server MVP ... >>> CREATE TABLE tblRichTest1( ...
    (microsoft.public.sqlserver.programming)
  • Re: cannot acees two databases as owner
    ... member of the built-in group Administrators, is not sysadmin. ... Administrator of SQL Server. ...
    (microsoft.public.sqlserver.setup)