Our company have enforced this type of login, so I can't seem to find a way around this. From what it seems the Get-SqlDatabase command from the SqlServer module that is used does not seem to support login through MFA.
I run into problems however with getting the database connection to work. Get-SqlColumnMasterKey -InputObject $database # List column master keys for the specified database. $database = Get-SqlDatabase -ConnectionString $connStr $connStr = "Server = " + $serverName + " Database = " + $databaseName + " Authentication = Active Directory Integrated" # Set the valid server name, database name and authentication keywords in the connection string
I am following this guide, which offers the following sample code: # Import the SqlServer module I am trying to set up a PowerShell script to enable Always Encrypted on our Azure SQL Server databases.
0 kommentar(er)
