Post reply

SQL Service Account - Identifying Folder Permissions

  • April 5, 2011 at 8:33 am

    #147774

    I'm changing the account used for SQL Services, and the current account has various folder permission across the network so that scheduled jobs can output text files reports etc.... Is there a tool or utility I can use to identify the permissions the old account has so that I can give them to the new account ?

    I realize this is more of a Windows question, so if anyone has a suggestion of a better forum to post this on, I'd appreciate it.

    Thanks.

  • April 5, 2011 at 9:34 am

    #1307542

    this is a command line tool and you must be the admin on the target machine.

    AccessChk

    Alex S

  • April 5, 2011 at 9:50 am

    #1307556

    Do you know all the paths to all the folders the old account has access to?

    I use PowerShell to verify permissions on a server for both troubleshooting and security checks:

    $a = (Get-Acl -Path 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL')

    $a.Access | Select-Object FileSystemRights, AccessControlType, IdentifyReference, IsInherited | Format-Table -AutoSize

    I have not learned everything there is to PowerShell but you could change this around to accept a parameter that is feed each path you need to check. That is if you have PowerShell running in your environment.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply