Home Forums SQL Server 2008 SQL Server 2008 - General Using xp_cmdshell to grant fulladmin (read/write/xecute/full control) to a sql user RE: Using xp_cmdshell to grant fulladmin (read/write/xecute/full control) to a sql user

  • July 6, 2015 at 9:25 am

    #1810484

    Have your sysadmins grant the permissions for you or let you RDP in the SQL Server box. Don't try to circumvent security with xp_cmdshell.

    BTW, if the SQL Server service account is not an administrator (and it shouldn't) it won't work.

    -- Gianluca Sartori