Azure SQL Users

This extension allows you to create multiple Azure SQL Logins & Database Admins, it use's email addresses and creates a unique password that is then emailed to the user via your sendgrid account.

Prerequisite's

• Azure SendGrid Account
• Azure SQL Server & Database

How to Use

Email Addresses: Comma Seperated email address Database Connection: The Azure SQL Server address XXXXXX.database.windows.net Database Name: Name of the Database you wish to give the accounts access to SQL Admin: Azure SQL Admin Account SQL Password: Azure SQL Password, Either place the password in the textbox or create a hidden variable and reference it

SendGrid Username: XXXXXXXXXXX@Azure.com SendGrid Password: Sendgrid Password, Either place the password in the textbox or create a hidden variable and reference it

Custom Address: This is the email address you want the details to be sent from

Once the users have been created make sure when connecting to the database you have it set in SSMS as the database you are connecting to.

Updates

Version 5.0

Allows you to create a Read Only SQL Account

Version 4.0

Stable Release to allow encrypted passwords.

Version 3.0

Stable release to add users to database

Version 2.0

• Error Handling when user account is already on the Azure SQL Server

Version 4.0 - Issues

Cant have multiple users with the same name. For example: Bob.Jones@gmail.com, Bob.Jones@hotmail.com.

Upcoming

• Allowing Multiple names if already created