SQL Server – checking for Instant File Initialization Permissions

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.

Advertisement

---