How to create a new user in a SQL Azure database

Tags: SQL Azure, database, user, create

Saturday, June 5, 2021 9:05:51 PM

In SQL Server Management Studio:

1) select the database from the database dropdown list

2) run the following script:

CREATE USER [myusername] WITH PASSWORD = 'mypassword';

ALTER ROLE [db_owner] ADD MEMBER [myusername];

1 Comment

  • verasearch3 said Reply

    Note, you must specify the database when connecting or you will get a login failed error

You must log on to comment.