Export (0) Print
Expand All
Expand Minimize

Initialize-ASMonitoringSqlDatabase

Initialize-ASMonitoringSqlDatabase

Adds the monitoring database objects to an SQL database, and creates the database if it does not already exist.

Syntax

Parameter Set: DatabaseNameAndServerName
Initialize-ASMonitoringSqlDatabase -Database <String> [-Admins <String> ] [-Force] [-Readers <String> ] [-Server <String> ] [-Writers <String> ] [ <CommonParameters>]


Parameters

-Admins<String>

Windows User(s) or Group(s) that will be assigned to the MonitoringDbAdmin role. This will be the AS_Administrators Windows security group.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

-ConnectionString<String>

SQL Server connection string.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

-Database<String>

Name of the SQL database.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

-Force

Forces the command to execute without asking for user confirmation.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

-Readers<String>

Windows User(s) or Group(s) that will be assigned to the MonitoringDbReader role. This will be the AS_Observers Windows security group.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

-Server<String>

SQL Instance Name (e.g. MachineA or MachineA/SQLEXPRESS).


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true (ByPropertyName)

Accept Wildcard Characters?

-Writers<String>

Windows User(s) or Group(s) that will be assigned to the MonitoringDbWriter role. This will be the AS_Administrators Windows security group.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • None


Outputs

The output type is the type of the objects that the cmdlet emits.

  • DatabaseInfo


Examples

Example 1

Running the Initialize-ASMonitoringSqlDatabase cmdlet creates a new monitoring database named MyServiceStore. It initializes the store to receive monitoring information. The AS_Observers Windows security group is added to the MonitoringDbReader role, while the AS_Administrators Windows security group is added to both the MonitoringDBWriter and MonitoringDBAdmin roles. The NT AUTHORITY\LOCAL SERVICE account is also added to the MonitoringDBAdmin role for use with the Event Collection service and Workflow Management service.


PS C:\Windows\system32> Initialize-ASMonitoringSqlDatabase -Database "MyServiceStore" -Admins "AS_Administrators" -Readers "AS_Observers" -Writers "AS_Administrators"Server : MICROSO-XNMDH06Database : MyServiceStoreConnectionString : Data Source=MICROSO-XNMDH06;Initial Catalog=OrderService_PS;Integrated Security=True
Show:
© 2015 Microsoft