app login using username and password using sql database code example

Example: create login sql server

CREATE LOGIN <login_name> WITH PASSWORD = '<enterStrongPasswordHere>';
GO