Install and configure SQL AlwaysON AG with Listener on Azure

Configuring the Nodes - Shared Location

The following process is a standard share with permissions added.
shared_location_step_1
Browse to the folder you wish to share, right click > Properties. Click on the Sharing tab, then click Advanced Sharing
shared_location_step_2

Place a tick next to Share this folder and click on Permissions
shared_location_step_3
Highlight Everyone and click on Remove.
shared_location_step_4
Click on Add
shared_location_step_5

Add the users and or groups, click on Check Names to verify they actually exist. Click on OK
shared_location_step_6
Select each account that was added and ensure that Full Control has been ticket. This will tick all the boxes. Click OK
shared_location_step_7
This will show that the path has now been shared.
shared_location_step_8
Click on the Security tab (This is owned by the original SQL Server Service Account prior to updating the login for this). Due to this, we need to click on Advanced
shared_location_step_9
Click on Change next to Owner
shared_location_step_10
Add the SQL Server Service Account. Click on Check Names to verify the account actually exists. Click OK
shared_location_step_11
Click on Add
shared_location_step_12
Click on Select a principal
shared_location_step_13
Search for a group and or user. Click on Check Names to verify the account actually exists. Click OK
shared_location_step_14
Ensure Modify has been ticked. This will automatically tick Write. Click OK
shared_location_step_15
This displays the permissions have been added. Click OK
shared_location_step_16
Click OK

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*