Enable-MbamDatabase

Enables the Compliance and Audit and Recovery databases.

Syntax

Enable-MbamDatabase
      [-SkipValidation]
      -ConnectionString <String>
      [-DatabaseName <String>]
      -AccessAccount <String>
      -ReportAccount <String>
      [-ComplianceAndAudit]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Enable-MbamDatabase
      [-SkipValidation]
      -ConnectionString <String>
      [-DatabaseName <String>]
      -AccessAccount <String>
      [-Recovery]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Description

The Enable-MbamDatabase cmdlet enables a Compliance and Audit or a Recovery Database.

Examples

Example 1: Enable the Compliance and Audit Database

PS C:\> Enable-MbamDatabase -ComplianceAndAudit -ConnectionString "Integrated Security=SSPI;Data Source=MyDatabaseServer" -AccessAccount "MyDomain\MyAccessAccount" -ReportAccount "MyDomain\MyReportAccount" -DatabaseName "MyComplianceDatabaseName"

This command enables the Compliance and Audit Database on MyDatabaseServer. The name of the database is MyComplianceDatabaseName. The domain account MyAccessAccount has read and write permission to the database, and MyReportAccount has read-only permission to the database for reporting purposes. The current Windows account credentials are used for authentication.

Example 2: Enable the Recovery Database

PS C:\> Enable-MbamDatabase -Recovery -ConnectionString "Integrated Security=SSPI;Data Source=MyDatabaseServer" -AccessAccount "MyDomain\MyAccessAccount" -DatabaseName "MyRecoveryDatabaseName"

This command enables the Recovery database on MyRecoveryDatabaseServer. The name of the database is MyRecoveryDatabaseName. The domain account MyAccessAccount has read/write permission to the database. The command uses the current Windows account credentials for authentication.

Parameters

-AccessAccount

Specifies a domain user or group. This domain user or group has read and write permission to this database, which enables web applications to access the data and reports. If the value is a domain user, the WebServiceApplicationPoolCredential parameter in the Enable-MbamWebApplication cmdlet must use the same user account. If the value is a group, the domain account used by the WebServiceApplicationPoolCredential parameter must be a member of this group.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-ComplianceAndAudit

Indicates that the Compliance and Audit Database is enabled.

Type:SwitchParameter
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ConnectionString

Specifies the connection string used to connect to the data store. The Integrated Security field must be in the connection string.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-DatabaseName

Specifies the name of the database. This parameter cannot contain leading or trailing spaces or non-printable characters. If you do not specify a name, the Compliance and Audit Database is given the name MBAM Compliance Status, and the Recovery database is given the name MBAM Recovery and Hardware.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Recovery

Indicates that the Recovery Database is enabled.

Type:SwitchParameter
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-ReportAccount

Specifies a domain user or group. This domain user or group has read-only permission to this database, which enables reports to access the compliance and audit data. If the value is a domain user, the ComplianceAndAuditDBCredential parameter in the Enable-MbamReport cmdlet must use the same user account. If the value is a domain user group, the domain account used by the ComplianceAndAuditDBCredential parameter must be a member of this group.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-SkipValidation

Indicates that this cmdlet bypasses validation of parameter values. If you specify this parameter, the feature may not function properly after you enable it.

Type:SwitchParameter
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False