Skip to content

Instantly share code, notes, and snippets.

@justinyoo
Last active April 11, 2016 23:15
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save justinyoo/071607ca0ab18f7eac56926a4167c3f4 to your computer and use it in GitHub Desktop.
DevOps Pro Tip - Creating Accounts on Azure SQL Database through PowerShell
$server = "tcp:my-azure-sql.database.windows.net,1433"
$database = "master"
$adminName = "admin@my-azure-sql"
$adminPassword = "P4SSW0rd"
$connectionString = "Server=$server;Database=$database;User ID=$adminName;Password=$adminPassword;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
$connection = New-Object -TypeName System.Data.SqlClient.SqlConnection($connectionString)
$queryPath = "C:\Temp\SqlLogin.sql"
$query = [System.IO.File]::ReadAllText($queryPath)
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand($query, $connection)
$username = New-Object -TypeName System.Data.SqlClient.SqlParameter("@Username", "MyDboName")
$password = New-Object -TypeName System.Data.SqlClient.SqlParameter("@Password", "3yDb0Pa$$W0rd")
$command.Parameters.Add($username)
$command.Parameters.Add($password)
$connection.Open()
$command.ExecuteNonQuery()
$connection.Close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment