Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Windows authentication on SQL servers

ansgar's profile image ansgar posted 8 years ago in News Permalink
Users of MS SQL servers may find it useful to connect to their server via Windows authentication. The login dialog disables username + password in that case, as these are not required (indeed ignored by the server). The old option "Prompt for credentials" is now mutually exclusive to the new checkbox option "Windows authentication". Makes no sense to prompt for user+pass which then are ignored by the server. The connection dialog has grown a bit in its minimum height, as now the mentioned two checkboxes need vertical space. Well, features need space.

For MySQL sessions this checkbox is disabled. Although there is a MySQL server plugin which allows Windows authentication, the difference to MS SQL is that MySQL still asks for a username - only the password can be blank in that case.

Thanks to csiqojerncjsa for the hint on how to enable "Integrated Security" in a TAdoConnection
1 attachment(s):
  • windows-auth
Rvanlaak's profile image Rvanlaak posted 7 years ago Permalink
Shouldn't the "use windows auth" feature be available for MySQL servers? Our dev-server hosts > 200 databases, and is the domaincontroller, so that should come in handy :)
ansgar's profile image ansgar posted 7 years ago Permalink
The fact that your MySQL server is also used a domaincontroller does not by itself enable Windows authentication in MySQL. As said above, you need a plugin.
jfalch's profile image jfalch posted 7 years ago Permalink
see here about it.

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