Check File System for SQL Server Access across multiple servers
0
votes
1
answer
400
views
This article describes the File System permissions that are needed for the SQL Server Database Engine to access any folder where database files are stored.
My organization has dozens of database servers, each of which are storing files in a varying number of local attached drives.
Is there an automated SQL (or PowerShell) script I can run that will return my ALL of the folders that do (or don't) have Full Control permissions for the NT SERVICE\MSSQLSERVER SID?
I have already tried using Test-DbaPath from DBATools. This is returning results if the folder exists, however it is not letting me know if the SID has Full Control.
Asked by Britt Wescott
(103 rep)
Mar 28, 2022, 03:29 PM
Last activity: Mar 28, 2022, 03:56 PM
Last activity: Mar 28, 2022, 03:56 PM