noman.khalid
3/4/2020 - 1:51 PM

New SQL User

USE [master];
GO
CREATE LOGIN username 
    WITH PASSWORD    = N'password',
    CHECK_POLICY     = OFF,
    CHECK_EXPIRATION = OFF;
GO
EXEC sp_addsrvrolemember 
    @loginame = N'username', 
    @rolename = N'sysadmin';