Search code examples
sqlsql-serversqlcmd

SQLCMD running as builtin Admin Group


How to run SQLCMD with builtin Administrator Group.


Solution

  • Run CommandPrompt (or PowerShell) as Administrator (so that you have elevated permissions). Then use sqlcmd with the -E flag, so that it uses your Windows login (using sa these days isn't recommended).