May 12th, 2022 at 04:21 PM

Create and Change User, SQL Server

/* Create a user for a specified database */

create LOGIN isl_amira WITH PASSWORD='*****', CHECK_POLICY = OFF;
GO

USE master;
GO
DENY VIEW ANY DATABASE TO isl_amira;
GO

USE master;
GO
ALTER AUTHORIZATION ON DATABASE::IBO_GAMCA_AMIRA TO amira;
GO

/* Change Password */

ALTER LOGIN isl_amira WITH PASSWORD = '******';
GO

Other Method: https://www.cocosenor.com/articles/office/how-to-change-sql-sa-password-from-a-command-prompt.html