Trying to add another SQL login account and password from SSMS for Azure SQL database.

Confirmed that I could connect using my original sql logon acct. Now I want to create another SQL logon account.

Rt clicked the Security>New logon> query below appeared. I also want to create this SQL account with sysadmin permissions.

Also unsure how to replace in the query below.

SQL_login_name = sqlservertest.database.windows.net ? (this is the server name that appears in the pulldown for SMMS)

log_name = newsqlacct1 ? (this the new SQL server logon account that I want to create)

sysname = ?

password = Is this the original password ? ( this is a new acct therefore there is no password yet?)

sysname, = ?

Change_Password = is this the new password ?

– ======================================================================================
– Create SQL Login template for Azure SQL Database and Azure SQL Data Warehouse Database
– ======================================================================================

CREATE LOGIN <SQL_login_name, sysname, login_name>
WITH PASSWORD = ‘<password, sysname, Change_Password>’
GO