none
DBA RRS feed

  • Question

  • OS: Windows Server 2008 R2 Standard Edition

    SQL Server: Microsoft SQL Server 2008 R2 (SP3)

    Command: fsutil volume diskfree c:\

    Source: SQL Server, Command prompt

    Problem:

    I have one admin windows account  and one admin SQL Server account.

    1. When I try to execute fsutil volume diskfree c:\ from SQL Server using sa account, it says "FSUTILITY requires administrative privileges".

    2. When I open command prompt with my windows credentials(which is admin) and try to execute fsutil volume diskfree c:\ , it says "FSUTILITY requires administrative privileges".

    3. When I open command prompt as administrator(Right click->Run as administrator) and try to execute fsutil volume diskfree c:\ , it works fine.

    4. Command works fine on other servers like Windows Server 2012.

    5. We have not granted any local administrative privileges to SQL Server's sa account on any of the computers.

    Please suggest what could be done to make it work from SQL Server. This utility is being called from within SSIS package and is working for all other servers but just one. So, I cannot change the way SSIS package queries for disk information.

    Thursday, May 18, 2017 11:02 AM