.png)
Step 4: Configure Microsoft SQL Server to Use Scale-Out File Server
Published: February 29, 2012
Updated: May 31, 2012
Applies To: 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.
