distal-attribute
distal-attribute
distal-attribute
distal-attribute

Windows authentication on SQL servers

User, date Message
Written by ansgar
3 years ago
Category: News
4940 posts since Fri, 07 Apr 06
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
Written by Rvanlaak
1 year ago
25 posts since Sat, 25 Dec 10
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 :)
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
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.
Written by jfalchMoney, Euro
1 year ago
383 posts since Sat, 17 Oct 09
see here about it.
 

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