-
Notifications
You must be signed in to change notification settings - Fork 3
/
SingleInstanceInstall_Example.ps1
68 lines (60 loc) · 2.59 KB
/
SingleInstanceInstall_Example.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
$secpassword = 'Somepass1' | ConvertTo-SecureString -AsPlainText -Force
$SqlInstallCredential = New-Object System.Management.Automation.PSCredential("Contoso\Install", $secpassword)
$SqlServiceCredential = New-Object System.Management.Automation.PSCredential("Contoso\Install", $secpassword)
$SqlAgentServiceCredential = New-Object System.Management.Automation.PSCredential("Contoso\Install", $secpassword)
$MofPath = 'C:\Mofs'
$ConfigData = @{
AllNodes = @(
@{
NodeName = '*'
SqlInstallCredential = $SqlInstallCredential
SqlServiceCredential = $SqlServiceCredential
SqlAgentServiceCredential = $SqlAgentServiceCredential
MofPath = 'C:\Mofs'
SetupSourcePath = 'C:\SQL2017'
SQLSysAdminAccounts = 'Contoso\Administrator'
PSDscAllowPlainTextPassword = $true
PSDscAllowDomainUser = $true
InstanceName = 'TestInstance'
XpCmdShellEnabled = 0
}
@{
NodeName = "localhost"
}
)
}
Configuration SqlStandAlone
{
Import-DscResource -ModuleName SQLCompositeResources
Import-DscResource -ModuleName SqlServerDsc
node $allNodes.NodeName
{
SingleInstanceInstall StandAlone {
Server = $Node.Nodename
SetupSourcePath = $Node.SetupSourcePath
SQLSysAdminAccounts = $Node.SQLSysAdminAccounts
SqlInstallCredential = $Node.SqlInstallCredential
SqlServiceCredential = $Node.SqlServiceCredential
SqlAgentServiceCredential = $Node.SqlAgentServiceCredential
SQLInstance = $Node.InstanceName
XpCmdShellEnabled = $Node.XpCmdShellEnabled
}
SqlServerLogin DisableSaAccount {
ServerName = $Node.Nodename
InstanceName = $Node.InstanceName
Name = 'sa'
Ensure = 'Present'
Disabled = $true
LoginType = 'SqlLogin'
DependsOn = '[SingleInstanceInstall]StandAlone'
}
Service DisableSqlBrower {
Name = 'SQLBrowser'
State = 'Stopped'
StartupType = 'Disabled'
DependsOn = '[SingleInstanceInstall]StandAlone'
}
}
}
SQLStandAlone -ConfigurationData $ConfigData -OutputPath $MofPath
Start-DscConfiguration -ComputerName $ConfigData.AllNodes.nodename -Path $MofPath -Force -Wait -Verbose