Skip to content

Instantly share code, notes, and snippets.

@w3bward
Last active April 21, 2022 18:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save w3bward/7e42070cc714be6cafd74a22ef980324 to your computer and use it in GitHub Desktop.
Save w3bward/7e42070cc714be6cafd74a22ef980324 to your computer and use it in GitHub Desktop.
An example of creating an SMO connection using the SmoRenewableToken module
Import-Module SmoRenewableToken
# You must run Connect-AzAccount so that an access token can be obtained from Az.Accounts
Connect-AzAccount
$SmoRenewableToken = New-SmoRenewableToken
# Replace these values with the values for your Azure SQL server/database
$Server = "myazuresqlserver.database.windows.net"
$Database = "MyDatabase"
$ConnectionInfo = [Microsoft.SqlServer.Management.Common.SqlConnectionInfo]::new($Server)
$ConnectionInfo.DatabaseName = $Database
$ConnectionInfo.AccessToken = $SmoRenewableToken
$ConnectionInfo.UserName = $SmoRenewableToken.UserId
$ServerConnection = [Microsoft.SqlServer.Management.Common.ServerConnection]::new($ConnectionInfo)
$ServerInstance = [Microsoft.SqlServer.Management.Smo.Server]::new($ServerConnection)
$DatabaseInstance = $ServerInstance.Databases | where Name -EQ $Database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment