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
WITH PASSWORD = ''