SQL Server – checking for Instant File Initialization PermissionsPosted: May 9, 2017
To check for Instant File Initialization Permissions:
- Go to https://gallery.technet.microsoft.com/scriptcenter/Grant-Revoke-Query-user-26e259b0
- Download UserRights.ps1
- Add privilege SeDelegateSessionUserImpersonatePrivilege to the list within the script
- Download http://smooth1.co.uk/powershell/CheckSQLServerUserRights.ps1
NOTE: This script needs to be locally on the machine where you are checking for permissions.
The script assumes the SQL Servers are running under a server where the DisplayName starts with “SQL Server (“, please adapt for your own needs.