CODEWITHSUNDEEP
sqlsql-serversqlcmd
Sreedhar
Sreedhar

Reputation: 30045

SQLCMD running as builtin Admin Group

How to run SQLCMD with builtin Administrator Group.

Upvotes: 1

Views: 2630

Answers (2)

Cade Roux
Cade Roux

Reputation: 89671

RUNAS

Upvotes: 0

Rob Farley
Rob Farley

Reputation: 15849

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).

Upvotes: 1

Related Questions