ActiveDirectoryAdministratorArgs

data class ActiveDirectoryAdministratorArgs(val azureadAuthenticationOnly: Output<Boolean>? = null, val login: Output<String>? = null, val objectId: Output<String>? = null, val resourceGroupName: Output<String>? = null, val serverName: Output<String>? = null, val tenantId: Output<String>? = null) : ConvertibleToJava<ActiveDirectoryAdministratorArgs>

Allows you to set a user or group as the AD administrator for an Azure SQL server.

Note: The azure.sql.ActiveDirectoryAdministrator resource is deprecated in version 3.0 of the AzureRM provider and will be removed in version 4.0. Please use the azuread_administrator block of the azure.mssql.Server resource instead.

Example Usage

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.CoreFunctions;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.sql.SqlServer;
import com.pulumi.azure.sql.SqlServerArgs;
import com.pulumi.azure.sql.ActiveDirectoryAdministrator;
import com.pulumi.azure.sql.ActiveDirectoryAdministratorArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
final var current = CoreFunctions.getClientConfig();
var example = new ResourceGroup("example", ResourceGroupArgs.builder()
.name("example-resources")
.location("West Europe")
.build());
var exampleSqlServer = new SqlServer("exampleSqlServer", SqlServerArgs.builder()
.name("mysqlserver")
.resourceGroupName(example.name())
.location(example.location())
.version("12.0")
.administratorLogin("4dm1n157r470r")
.administratorLoginPassword("4-v3ry-53cr37-p455w0rd")
.build());
var exampleActiveDirectoryAdministrator = new ActiveDirectoryAdministrator("exampleActiveDirectoryAdministrator", ActiveDirectoryAdministratorArgs.builder()
.serverName(exampleSqlServer.name())
.resourceGroupName(example.name())
.login("sqladmin")
.tenantId(current.applyValue(getClientConfigResult -> getClientConfigResult.tenantId()))
.objectId(current.applyValue(getClientConfigResult -> getClientConfigResult.objectId()))
.build());
}
}

Import

A SQL Active Directory Administrator can be imported using the resource id, e.g.

$ pulumi import azure:sql/activeDirectoryAdministrator:ActiveDirectoryAdministrator administrator /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver/administrators/activeDirectory

Constructors

Link copied to clipboard
fun ActiveDirectoryAdministratorArgs(azureadAuthenticationOnly: Output<Boolean>? = null, login: Output<String>? = null, objectId: Output<String>? = null, resourceGroupName: Output<String>? = null, serverName: Output<String>? = null, tenantId: Output<String>? = null)

Functions

Link copied to clipboard
open override fun toJava(): ActiveDirectoryAdministratorArgs

Properties

Link copied to clipboard
val azureadAuthenticationOnly: Output<Boolean>? = null

Specifies whether only AD Users and administrators can be used to login (true) or also local database users (false).

Link copied to clipboard
val login: Output<String>? = null

The login name of the principal to set as the server administrator

Link copied to clipboard
val objectId: Output<String>? = null

The ID of the principal to set as the server administrator

Link copied to clipboard
val resourceGroupName: Output<String>? = null

The name of the resource group for the SQL server. Changing this forces a new resource to be created.

Link copied to clipboard
val serverName: Output<String>? = null

The name of the SQL Server on which to set the administrator. Changing this forces a new resource to be created.

Link copied to clipboard
val tenantId: Output<String>? = null

The Azure Tenant ID