Azure System Administration

Ask about programs you have written using Azure to perform system-administration tasks.

1
Posts

46
Members

12
Followers

Topic menu

Stream CLIPP Knowledge

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

Aug 28, 2019

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

Latest activities

- Collapse

Topic Learners

- Collapse

Topic Experts

ExpertConnect - Mentoring & Discussions

Azure System Administration

Ask about programs you have written using Azure to perform system-administration tasks.

Terms And Conditions

Hidden Gallery