Add-SqlAdmin
Adds a Windows User as SQL administrator.
Syntax
Add-SqlAdmin [-Server] <String> [-User] <String> [<CommonParameters>]
Description
Adds a Windows User as SQL administrator.
Parameters
-Server <String>
The name of the SQL server to connect to.
| Position | Required | Default value | Accept pipeline input | Accept wildchard characters |
|---|---|---|---|---|
| 1 | true | false | false |
-User <String>
The name of the user to register as admin.
| Position | Required | Default value | Accept pipeline input | Accept wildchard characters |
|---|---|---|---|---|
| 2 | true | false | false |
Examples
-------------------------- EXAMPLE 1 --------------------------
Add-SqlAdmin -Server localhost -User "NT Authority\Service"