en-us/about_AutomatedLab_sql.help.txt
|
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 -Properties @{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* |