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 |
---|---|
Ensure that the permissions on the continuously available file share are configured correctly to host 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.
Log on to the file server as a member of the local Administrators group.
Open Windows Explorer and navigate to the scale-out file share.
Right-click the folder, and then click Properties.
Click the Sharing tab, click Advanced Sharing, and then click Permissions.
Ensure that the SQL Server service account has full-control permissions.
Click OK twice.
Click the Security tab.
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.