Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 100 of 212

88 C H A P T E R 5 | Broader data access /PBPORTRANGE Defines a range of at least six ports to dedicate to PolyBase. /PBENGSVCACCOUNT Configures the service account for the PolyBase engine. The default value is NT Authority\NETWORK SERVICE. /PBENGSVCPASSWORD Specifies the password to use with the PolyBase engine service account. /PBENGSVCSTARTUPTYPE Configures the startup mode for the PolyBase engine service: Automatic (default), Manual, or Disabled. /PBDMSSVCACCOUNT Configures the service account for the PolyBase data movement service. The default value is NT Authority\NETWORK SERVICE. /PBDMSSVCPASSWORD Specifies the password to use with the PolyBase data movement service account. /PBDMSSVCSTARTUPTYPE Configures the startup mode for the PolyBase data movement service: Automatic (default), Manual, or Disabled. Example 5-26: Installing PolyBase from a command-prompt window Setup.exe /Q /ACTION=INSTALL /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLEngine,Polybase /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="\Administrator" /INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /PBSCALEOUT=TRUE /PBPORTRANGE=16450-16460 /SECURITYMODE=SQL /SAPWD="" /PBENGSVCACCOUNT="\" /PBENGSVCPASSWORD="" /PBDMSSVCACCOUNT="\" /PBDMSSVCPASSWORD="" Next you need to configure your PolyBase instance for connectivity to either Hadoop or Azure Blob Storage, as shown in Example 5-27, using one of the following values for the @configvalue parameter: 0 Disable Hadoop connectivity 1 Hortonworks HDP 1.3 on Windows Server and blob storage 2 Hortonworks HDP 1.3 on Linux 3 Cloudera CDH 4.3 on Linux 4 Hortonworks HDP 2.0 on Windows Server and blob storage 5 Hortonworks HDP 2.0 on Linux 6 Cloudera 5.1 on Linux 7 Hortonworks 2.1 and 2.2 on Linux, Hortonworks 2.2 on Windows Server and blob storage Example 5-27: Configuring an external data source for PolyBase sp_configure @configname = 'hadoop connectivity', @configvalue = 7; reconfigure; After you run the sp_configure and reconfigure commands, you must reboot the server. The reboot will, of course, stop and start the SQL Server service, which also stops and restarts the dependent

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016