Free Republic
Browse · Search
News/Activism
Topics · Post Article

To: Technical

Yes, OSQL allows you to authenticate using Windows authentication instead of normal SQL authentication, IF you are logged into the SQL server machine with a Windows account that has permission to modify the database.

So if you can gain access to an account like that on the server, you don’t actually need SQL credentials.


429 posted on 08/12/2021 9:35:26 AM PDT by Boogieman
[ Post Reply | Private Reply | To 348 | View Replies ]


To: Boogieman
Yes, OSQL allows you to authenticate using Windows authentication instead of normal SQL authentication, IF you are logged into the SQL server machine with a Windows account that has permission to modify the database.

So if you can gain access to an account like that on the server, you don’t actually need SQL credentials.

It's not just OSQL. SQL Server by default supports Windows Authentication, and/or SQL Authentication for any client connecting to the database.

Yes - if you long on with a Windows account that has elevated privileges, then you already have that access. Executing a command under the context of that account, whether through a batch file, an application, or SSMS isn't elevating your privileges - it's what you had when you logged onto that account.
434 posted on 08/12/2021 9:43:19 AM PDT by Technical
[ Post Reply | Private Reply | To 429 | View Replies ]

Free Republic
Browse · Search
News/Activism
Topics · Post Article


FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson