forked from dsccommunity/SqlServerDsc
-
Notifications
You must be signed in to change notification settings - Fork 0
/
1-AddLogin.ps1
72 lines (63 loc) · 2.41 KB
/
1-AddLogin.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<#
.EXAMPLE
This example shows how to ensure that the Windows user 'CONTOSO\WindowsUser' exists.
.EXAMPLE
This example shows how to ensure that the Windows group 'CONTOSO\WindowsGroup' exists.
.EXAMPLE
This example shows how to ensure that the SQL Login 'SqlLogin' exists.
#>
Configuration Example
{
param(
[Parameter(Mandatory = $true)]
[System.Management.Automation.PSCredential]
$SqlAdministratorCredential,
[Parameter(Mandatory = $true)]
[System.Management.Automation.PSCredential]
$LoginCredential
)
Import-DscResource -ModuleName SqlServerDsc
node localhost {
SqlServerLogin Add_WindowsUser
{
Ensure = 'Present'
Name = 'CONTOSO\WindowsUser'
LoginType = 'WindowsUser'
ServerName = 'TestServer.company.local'
InstanceName = 'DSC'
PsDscRunAsCredential = $SqlAdministratorCredential
}
SqlServerLogin Add_DisabledWindowsUser
{
Ensure = 'Present'
Name = 'CONTOSO\WindowsUser2'
LoginType = 'WindowsUser'
ServerName = 'TestServer.company.local'
InstanceName = 'DSC'
PsDscRunAsCredential = $SqlAdministratorCredential
Disabled = $true
}
SqlServerLogin Add_WindowsGroup
{
Ensure = 'Present'
Name = 'CONTOSO\WindowsGroup'
LoginType = 'WindowsGroup'
ServerName = 'TestServer.company.local'
InstanceName = 'DSC'
PsDscRunAsCredential = $SqlAdministratorCredential
}
SqlServerLogin Add_SqlLogin
{
Ensure = 'Present'
Name = 'SqlLogin'
LoginType = 'SqlLogin'
ServerName = 'TestServer.company.local'
InstanceName = 'DSC'
LoginCredential = $LoginCredential
LoginMustChangePassword = $false
LoginPasswordExpirationEnabled = $true
LoginPasswordPolicyEnforced = $true
PsDscRunAsCredential = $SqlAdministratorCredential
}
}
}