Skip to content

Commit 7a1961d

Browse files
v-danschv-dansch
committed
edit pass: instance-configuration
1 parent e707bda commit 7a1961d

2 files changed

Lines changed: 14 additions & 12 deletions

File tree

‎docs/database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup.md‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -126,11 +126,11 @@ The following item is for SQL Server 2016-2017
126126

127127
The workflow for the rest of the installation depends on the features that you've specified for your installation. Depending on your selections, you might not see all the pages.
128128

129-
14. Use the **Server Configuration - Service Accounts** page to specify the login accounts for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services. The actual services that you configure on this page depend on the features that you selected to install. For more information about configuration settings, see [Installation Wizard help](../../sql-server/install/instance-configuration.md#serverconfig).
129+
14. Use the **Server Configuration - Service Accounts** page to specify the logon accounts for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services. The actual services that you configure on this page depend on the features that you selected to install. For more information about configuration settings, see [Installation Wizard help](../../sql-server/install/instance-configuration.md#serverconfig).
130130

131-
You can assign the same login account to all [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services, or you can configure each service account individually. You can also specify whether services start automatically, start manually, or are disabled. We recommend you configure service accounts individually to provide the least privileges for each service. Make sure [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services are granted the minimum permissions they must have to complete their tasks. For more information, see [Configure Windows service accounts and permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md).
131+
You can assign the same logon account to all [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services, or you can configure each service account individually. You can also specify whether services start automatically, start manually, or are disabled. We recommend you configure service accounts individually to provide the least privileges for each service. Make sure [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] services are granted the minimum permissions they must have to complete their tasks. For more information, see [Configure Windows service accounts and permissions](../../database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md).
132132

133-
To specify the same login account for all service accounts in this instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], provide the credentials in the fields at the bottom of the page.
133+
To specify the same logon account for all service accounts in this instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], provide the credentials in the fields at the bottom of the page.
134134

135135
> [!IMPORTANT]
136136
> [!INCLUDE[ssNoteStrongPass](../../includes/ssnotestrongpass-md.md)]
@@ -234,7 +234,7 @@ To reduce the attackable surface area of a system, [!INCLUDE[ssNoVersion](../../
234234
## See also
235235

236236
* [Validate a SQL Server installation](../../database-engine/install-windows/validate-a-sql-server-installation.md)
237-
* [Repair a failed SQL Server 2016 installation](../../database-engine/install-windows/repair-a-failed-sql-server-installation.md)
237+
* [Repair a failed SQL Server installation](../../database-engine/install-windows/repair-a-failed-sql-server-installation.md)
238238
* [View and read SQL Server Setup log files](../../database-engine/install-windows/view-and-read-sql-server-setup-log-files.md)
239-
* [Upgrade to SQL Server 2016 by using the Installation Wizard (Setup)](../../database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup.md)
240-
* [Install SQL Server 2016 from the command prompt](../../database-engine/install-windows/install-sql-server-2016-from-the-command-prompt.md)
239+
* [Upgrade to SQL Server by using the Installation Wizard (Setup)](../../database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup.md)
240+
* [Install SQL Server from the command prompt](../../database-engine/install-windows/install-sql-server-2016-from-the-command-prompt.md)

‎docs/sql-server/install/instance-configuration.md‎

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -126,7 +126,7 @@ If you're installing [!INCLUDE[ssGeminiShort](../../includes/ssgeminishort-md.md
126126

127127
The default directories in the following table are user-configurable during [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Setup. Permission to access these files is granted to local administrators and to members of the SQLServerMSASUser$\<instance> security group that's created and provisioned during Setup.
128128

129-
### UI element list
129+
### UIElement list
130130

131131
|Description|Default directory|Recommendations|
132132
|-----------------|-----------------------|---------------------|
@@ -159,7 +159,7 @@ For more information about directories, file locations, and instance ID naming,
159159

160160
The default directories in the following table are user-configurable during [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Setup. Permission to access these files is granted to local administrators and to members of the SQLServerMSASUser$\<instance> security group that's created and provisioned during Setup.
161161

162-
#### UI element list
162+
#### UIElement list
163163

164164
|Description|Default directory|Recommendations|
165165
|-----------------|-----------------------|---------------------|
@@ -280,7 +280,7 @@ To specify an SMB file share as a directory, you must manually type the supporte
280280

281281
For a standalone instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], the following table lists the supported storage types and the default directories that you can configure during [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Setup:
282282

283-
### UI element list
283+
### UIElement list
284284

285285
|Description|Supported storage types|Default directory|Recommendations|
286286
|-----------------|----------------------------|-----------------------|---------------------|
@@ -312,7 +312,9 @@ The following recommendations apply to SMB file servers:
312312

313313
* The account used to install [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] should have Full Control NTFS permissions on the SMB file share folder used as the data directory.
314314

315-
* The account used to install [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] should be granted SeSecurityPrivilege privileges on the SMB file server. To grant this privilege, use the Local Security Policy console on the file server to add the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] setup account to the **Manage auditing and security log** policy. This setting is in the **User Rights Assignments** section under **Local Policies** in the Local Security Policy console.
315+
* The account used to install [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] should be granted SeSecurityPrivilege privileges on the SMB file server. To grant this privilege, use the Local Security Policy console on the file server to add the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] setup account to the **Manage auditing and security log** policy. This setting is in the **User Rights Assignments** section under **Local Policies** in the Local Security Policy console.
316+
317+
To make changes to the user roles after this installation program ends, use [SQL Server Management Studio](https://docs.microsoft.com/sql/relational-databases/security/authentication-access/join-a-role?view=sql-server-2017) or [Transact-SQL](https://docs.microsoft.com/sql/t-sql/statements/alter-role-transact-sql?view=sql-server-2017).
316318

317319
### Considerations
318320

@@ -355,7 +357,7 @@ For a failover cluster instance of [!INCLUDE[ssNoVersion](../../includes/ssnover
355357
|**tempdb data directory**|Local disk, shared storage, SMB file server|\<Drive:>\Program Files\\[!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]\MSSQL*nn*.\<InstanceID>\Data<br /><br /> **Tip**: If you select **shared disk** on the **Cluster Disk Selection** page, the default is the first shared disk. This field defaults to blank if you don't make a selection on the **Cluster Disk Selection** page.|[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Setup configures ACLs for [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] directories and breaks inheritance as part of configuration.<br /><br /> Ensure that the specified directory or directories (if multiple files are specified) are valid for all the cluster nodes. During failover, if the **tempdb** directories aren't available on the failover target node, the SQL Server resource fails to come online.|
356358
|**tempdb log directory**|Local disk, shared storage, SMB file server|\<Drive:>\Program Files\\[!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]\MSSQL*nn*.\<InstanceID>\MSSQL\Data<br /><br /> **Tip**: If you select **shared disk** on the **Cluster Disk Selection** page, the default is the first shared disk. This field defaults to blank if you don't make a selection on the **Cluster Disk Selection** page.|Best practices for user data directories depend on workload and performance requirements.<br /><br /> Ensure that the specified directory is valid for all the cluster nodes. During failover, if the **tempdb** directories aren't available on the failover target node, the SQL Server resource fails to come online.<br /><br /> Ensure that the log directory has adequate space.|
357359

358-
### UI element list
360+
### UIElement list
359361

360362
Configure the settings for **tempdb** according to your workload and requirements. The following settings apply to **tempdb** data files:
361363

@@ -426,7 +428,7 @@ You can manually configure this setting on this page, and you can modify this se
426428

427429
Use this page to enable FILESTREAM for this installation of [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)]. FILESTREAM integrates the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] with an NTFS file system by storing **varbinary(max)** binary large object (BLOB) data as files in the file system. [!INCLUDE[tsql](../../includes/tsql-md.md)] statements can insert, update, query, search, and back up FILESTREAM data. Microsoft Win32 file-system interfaces provide streaming access to the data.
428430

429-
### UI element list
431+
### UIElement list
430432

431433
**Enable FILESTREAM for Transact-SQL access**: Select to enable FILESTREAM for [!INCLUDE[tsql](../../includes/tsql-md.md)] access. This check box must be selected before the other options will be available.
432434

0 commit comments

Comments
 (0)