Step 4: Configure Microsoft SQL Server to Use Scale-Out File Server

 

Applies To: Windows Server 2012 R2, Windows Server 2012

SQL Server is one of two Microsoft applications that are supported when using File Server for scale-out application data storage. SQL Server 2008 R2 and SQL Server 2012 are supported in this scenario. SQL Server 2008 R2 is supported in a stand-alone configuration, and SQL Server 2012 adds support for clustered servers.

Task

Description

4.1. Verify permissions

Ensure that the permissions on the continuously available file share are configured correctly to host the database files.

4.2. Create the database files

Create the database files by using SQL Server Management Studio or by using a query.

4.1. Verify permissions

You should ensure that the proper permissions are granted on the continuously available file share before you create SQL Server database files.

To verify permissions

  1. Log on to the file server as a member of the local Administrators group.

  2. Open Windows Explorer and navigate to the scale-out file share.

  3. Right-click the folder, and then click Properties.

  4. Click the Sharing tab, click Advanced Sharing, and then click Permissions.

  5. Ensure that the SQL Server service account has full-control permissions.

  6. Click OK twice.

  7. Click the Security tab.

  8. Ensure that the SQL Server service account has full-control permissions.

4.2. Create the database files

When creating the database files, you can store the database files in a scale-out file share by using SQL Server Management Studio or by using a query. In SQL Server 2012, you can choose to store all database files in a scale-out file share during installation.

See also