Windows authentication on SQL servers
| User, date | Message |
|---|---|
|
Written by ansgar
2 years ago Category: News 3950 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
2 months ago 22 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
2 months ago 3950 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 jfalch
2 months ago 222 posts since Sat, 17 Oct 09 |
see here about it. |
|
Please login to leave a reply, or register at first. |