This command gets all instances of SQL Server on the computer named Computer005 and configures the authentication mode to Mixed,
with the provided SQL credentials for each one of them. The SQL Server service is not restarted automatically.
The self-signed certificate of the target machine is automatically accepted without prompting the user.
参数
-AutomaticallyAcceptUntrustedCertificates
Indicates that this cmdlet automatically accepts untrusted certificates.
参数属性
类型:
SwitchParameter
默认值:
None
支持通配符:
False
不显示:
False
参数集
(All)
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-Confirm
Prompts you for confirmation before running the cmdlet.
参数属性
类型:
SwitchParameter
默认值:
False
支持通配符:
False
不显示:
False
别名:
cf
参数集
(All)
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-Credential
Specifies a user account with Windows Administrator credentials on the target computer.
参数属性
类型:
PSCredential
默认值:
None
支持通配符:
False
不显示:
False
参数集
(All)
Position:
0
必需:
True
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-ForceServiceRestart
Indicates that this cmdlet forces the SQL Server service to restart, if necessary, without prompting the user.
参数属性
类型:
SwitchParameter
默认值:
None
支持通配符:
False
不显示:
False
参数集
(All)
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-InputObject
Specifies the server object, as an array, of the target instance.
参数属性
类型:
Server[]
默认值:
None
支持通配符:
False
不显示:
False
参数集
ByObject
Position:
Named
必需:
True
来自管道的值:
True
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-ManagementPublicPort
Specifies the public management port on the target computer.
This parameter should be used when the ports of the target computer are not directly accessible but are exposed through
endpoints, which means that this cmdlet needs to connect to a different port.
SQL Server Cloud Adapter must be accessible by this port.
参数属性
类型:
Int32
默认值:
None
支持通配符:
False
不显示:
False
参数集
(All)
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-Mode
Specifies the authentication mode that will be configured on the target instance of SQL Server.
参数属性
类型:
ServerLoginMode
默认值:
None
接受的值:
Normal, Integrated, Mixed, Unknown
支持通配符:
False
不显示:
False
参数集
(All)
Position:
1
必需:
True
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-NoServiceRestart
Indicates that this cmdlet prevents a restart of the SQL Server service without prompting the user.
参数属性
类型:
SwitchParameter
默认值:
None
支持通配符:
False
不显示:
False
参数集
(All)
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-Path
Specifies the path to the instance of SQL Server, as an array, on which this cmdlet runs the operation.
If you do not specify a value for this parameter, the cmdlet defaults to the current working location.
参数属性
类型:
String[]
默认值:
None
支持通配符:
False
不显示:
False
参数集
ByPath
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-RetryTimeout
Specifies the time period to retry the command on the target sever.
After the timeout expires, no retry will be attempted.
参数属性
类型:
Int32
默认值:
None
支持通配符:
False
不显示:
False
参数集
(All)
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-ServerInstance
Specifies, as a string array, the name of an instance of SQL Server that becomes the target of the operation.
参数属性
类型:
String[]
默认值:
None
支持通配符:
False
不显示:
False
参数集
ByName
Position:
Named
必需:
True
来自管道的值:
True
来自管道的值(按属性名称):
True
来自剩余参数的值:
False
-SqlCredential
Specifies the administrator credentials that is created in the target instance of SQL Server if Mixed mode authentication is enabled.
参数属性
类型:
PSCredential
默认值:
None
支持通配符:
False
不显示:
False
参数集
(All)
Position:
2
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
参数属性
类型:
SwitchParameter
默认值:
False
支持通配符:
False
不显示:
False
别名:
wi
参数集
(All)
Position:
Named
必需:
False
来自管道的值:
False
来自管道的值(按属性名称):
False
来自剩余参数的值:
False
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable,
-InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable,
-ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see
about_CommonParameters.