The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Thursday, March 28, 2024 Login
Public

Alter Login fails 12/19/2014 11:07:05 AM

SQL Server, Alter Login fails, must specify the old_password and "Execute As Login = 'user'.

Absolutely confusing for users and seems dumb, maybe I need to read more to understand why.

Good write up here:

http://sqlity.net/en/2322/change-password/ 

execute as login = 'my_login'

ALTER LOGIN my_login WITH PASSWORD = 'new password' OLD_PASSWORD = 'old password';


Blog Home