Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Published: February 29, 2012

Updated: April 2, 2014

Applies To: Windows Server 2012, Windows Server 2012 R2



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.

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

  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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.