Archive for May, 2016

How to change SQL Server password with SQLCMD

In some situation, we need to change password for our SQL Server user account via SQLCMD as remote or local connection, it’s not really new but it’s too important, just follow these below steps:

  1. Open CMD with SQLCMD utility
  2. Connect to SQL instance with sysadmin authorization
  3. Execute script to modify user metadata

ALTER LOGIN ‘[your user account]’ WITH PASSWORD = N'[your new password]’;


Categories: SQL Server