Command line flag Windows Authentication?

[expired user #9631]'s profile image [expired user #9631] posted 8 years ago in General Permalink

Sorry if I missed it or Im being stupid, but I have checked the documentation, the forum, stackoverflow and searched online but can not find a command line interface flag for windows authentication for when connecting to MSSQL databases (like in the GUI). Is it simply not documented? or does it not exist?

This is would be useful as I am writing a simple batch file to enable easy loading HeidiSQL using a localdb instance, atm it can be a painful experience to use HeidiSQL for that. So this would be beneficial to any .Net dev as localdb is often a strong part of their development life cycle. Easy load up could sway people people wanting to use it :)

PS Love HeidiSQL I used it for years on some small MySQL stuff in the past :)

ansgar's profile image ansgar posted 8 years ago Permalink

Well, this is currently not supported by HeidiSQL, as you can see in the documentation. This is mostly due to the fact that HeidiSQL was a pure MySQL client most of the time.

But I can add supported parameters there if that makes sense.

[expired user #9631]'s profile image [expired user #9631] posted 8 years ago Permalink

Thank you, although obviously a low priority thing it would be helpful if you get chance :)

I did try looking through the source to see if it was an easy hook, but havent done Delphi before so couldnt find the entry point sorry.

[expired user #10002]'s profile image [expired user #10002] posted 8 years ago Permalink

My thumbs-up for this, since it is already available through the UI, and apparently only the CLI switch isn't there.

Code modification/commit d81a166 from ansgarbecker, 8 years ago, revision 9.3.0.5108
Support Windows authentication via command line parameter W or winauth. See http://www.heidisql.com/forum.php?t=20752
ansgar's profile image ansgar posted 8 years ago Permalink

r5108 now supports a new command line parameter in these flavours:

W=1
W=0
winauth=1
winauth=0

I'll update the help section with that. Be sure to update HeidiSQL before wondering if that does not work.

[expired user #10002]'s profile image [expired user #10002] posted 8 years ago Permalink

Nice... I will try this ASAP and get back to you. Kudos!

[expired user #10002]'s profile image [expired user #10002] posted 8 years ago Permalink

Works beautifully!

Please login to leave a reply, or register at first.