2-FSx for Windows Configuration

Now that we have created our FSx File System we need to create the shares we will use for our SQL Server installs

By default a single share is created initially \\<DNS Name>\Share on D:\Share

We will be creating two additional shares to provide a target for SQL Data files and SQL Log Files

For the next steps we will need the FSx File System DNS name and the Windows Remote PowerShell Endpoint which can be found in the console here

  1. Within the jumpserver, open up Powershell ISE by right-clicking it and running it as Administrator:

Script: - replace <Windows Remote PowerShell Endpoint> with the Windows Remote PowerShell Endpoint located above

# Opens a remote PowerShell Session to the FSx File System

Enter-PSSession -ComputerName <Windows Remote PowerShell Endpoint>.demosql.com -ConfigurationName FsxRemoteAdmin
  1. When first opening up Powershell ISE, make sure to open up the Script Pane, where you will be pasting the scripts

  2. Once executed, you should see an output below

  1. Now that the Remote PowerShell session is connected we can run the share creation command. The -ContinuouslyAvailable $True makes the share compatable with Failover Cluster Shared Storage

    New-FSxSmbShare -Name "SQL-Data" -Path "D:\share" -Description "SQL Data" -ContinuouslyAvailable $True 
    
  2. Paste the command after the PS> in the lower pane and press Enter

  1. When executing it will prompt for credentials to connect to the FSx File System
    • Username: demosql\admin
    • Password: given by facilitator

  1. Once executed, you should see the output below

  1. Repeat steps 5-7 for the following command

    New-FSxSmbShare -Name "SQL-Log" -Path "D:\share" -Description "SQL Log" -ContinuouslyAvailable $True
    
  2. When complete you should see these two responses

  1. To confirm the creation of the shares, Open the Start menu and run fsmgmt.msc using Run As Administrator (right-click). This will open the Shared Folders GUI tool

  1. Click on Action - Connect to another computer and enter the DNS name of the FSx File System we identified above and click OK

  1. Clicking on Shares will show the two shares we just created

  1. We can also access the two shares through File Explorer via their UNC paths
    • \\<DNS Name>.demosql.com\SQL-Data
    • \\<DNS Name>.demosql.com\SQL-Log

  1. Finally we will edit the share permissions

    • First for SQL-Data
    • Right click on SQL-Data and select Properties
    • Click on Share Permissions, Add and type admin into the object names area and click OK
    • You will see a message on Multiple Names Found. select Admin and click OK
    • Finally select Admin and check Full Control, then click OK

    • Then for SQL-Log

    • Right click on SQL-Log and select Properties

    • Click on Share Permissions, Add and type admin into the object names area and click OK

    • You will see a message on Multiple Names Found. select Admin and click OK

    • Finally select Admin and check Full Control