en-us/about_AutomatedLab_sql.help.txt

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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
TOPIC
    about_automatedlab_sql
 
SHORT DESCRIPTION
    Generic help about the Role 'sql' in AutomatedLab
 
LONG DESCRIPTION
SQL Server
    The SQL Server role can be used to deploy any SQL Server version starting
    from SQL Server 2008 to 2019 on Windows. The installation can be customized
    like a normal SQL Server setup by using all available parameters or a
    configuration file.
    During the installation, all service accounts that are referenced will be
    created automatically unless they already exist. On Azure, by default a
    managed instance is deployed, unless role parameters are used that would
    prevent this. If for instance different service accounts are configured, a
    normal IaaS VM will be deployed and SQL will be installed from an ISO file
    that needs to be present in your LabSources folder on Azure.
    Starting with SQL Server 2017 the SQL Server Reporting Services need to be
    downloaded. On an online lab host, the package will be downloaded
    automatically. Should you be offline, please store the download as
    `"$LabSources\SoftwarePackages\SQLServerReportingServices.exe"`.
 
    ROLE ASSIGNMENT
    To deploy a default SQL Server, simply assign the role. This will include
    sample databases as well.
 
    Add-LabMachineDefinition -Name SQL01 -Roles SQLServer2017
 
    If you need a little more control, simply use the role properties. The
    following example only installs the engine and tools:
 
    $role = Get-LabMachineRoleDefinition -Role SQLServer2017 -RoleProperties @{Features = 'SQL,Tools'}
     
    Add-LabMachineDefinition -Name SQL01 -Roles $role
 
    ROLE PROPERTIES
    All role properties are entirely optional.
 
    FEATURES
    Features contains a string with the comma-separated features to install, as
    you would supply them on the command line. For example `@{Features =
    'SQL,Tools'}`.
 
    CONFIGURATIONFILE
    Specify the full (local) path to the configuration file that contains your
    setup parameters. You can still override single parameters.
 
    INSTANCENAME
    Name of the instance to deploy. Default is MSSQLSERVER
 
    COLLATION
    The collation to use
 
    SQLSVCACCOUNT
    The account name of the SQL service user
 
    SQLSVCPASSWORD
    The plaintext password of the SQL service user
 
    AGTSVCACCOUNT
    Agent Service account
 
    AGTSVCPASSWORD
    Agent Service account password
 
    RSSVCACCOUNT
    Reporting Services account
 
    RSSVCPASSWORD
    Reporting Services account password
 
    AGTSVCSTARTUPTYPE
    Agent Service start type
 
    BROWSERSVCSTARTUPTYPE
    Browser Service start type
 
    RSSVCSTARTUPTYPE
    Reporting Services start type
 
    ASSYSADMINACCOUNTS
    Analysis Services admin accounts
 
    ASSVCACCOUNT
    Analysis Services account
 
    ASSVCPASSWORD
    Analysis Services account password
 
    ISSVCACCOUNT
    Integration Services account
 
    ISSVCPASSWORD
    Integration Services account password
 
    SQLSYSADMINACCOUNTS
    The comma-separated list of administrative accounts
 
    CONFIGURATION SETTINGS
    There are several configuration settings that can be updated in case URLs
    change. To discover all available settings, please refer to
 
 
    Get-PSFConfig -Module AutomatedLab -Name SQL*