Set D365SysAdmin - FH-Inway/d365fo.tools GitHub Wiki
Set a user to sysadmin
Set-D365SysAdmin [[-User] <String>] [[-DatabaseServer] <String>] [[-DatabaseName] <String>]
[[-SqlUser] <String>] [[-SqlPwd] <String>] [<CommonParameters>]
Set a user to sysadmin inside the SQL Server
Set-D365SysAdmin
This will configure the local administrator on the machine as a SYSADMIN inside SQL Server
For this to run you need to be running it from a elevated console
Set-D365SysAdmin -SqlPwd Test123
This will configure the local administrator on the machine as a SYSADMIN inside SQL Server. It will logon as the default SqlUser but use the provided SqlPwd.
This can be run from a non-elevated console
The user that you want to make sysadmin
Most be well formatted server\user or domain\user.
Default value is: machinename\administrator
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 2
Default value: "$env:computername\administrator"
Accept pipeline input: False
Accept wildcard characters: False
The name of the database server
If on-premises or classic SQL Server, use either short name og Fully Qualified Domain Name (FQDN).
If Azure use the full address to the database server, e.g. server.database.windows.net
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: $Script:DatabaseServer
Accept pipeline input: False
Accept wildcard characters: False
The name of the database
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 4
Default value: $Script:DatabaseName
Accept pipeline input: False
Accept wildcard characters: False
The login name for the SQL Server instance
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 5
Default value: $Script:DatabaseUserName
Accept pipeline input: False
Accept wildcard characters: False
The password for the SQL Server user
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 6
Default value: $Script:DatabaseUserPassword
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Author: Mötz Jensen (@splaxi)