Archive

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]’;

 

Advertisements
Categories: SQL Server