在Mac上使用JBDC的SQL Server的Windows身份验证 [英] Windows Authentication for SQL Server using JBDC on a Mac

问题描述

是否可以使用Mac上的Windows身份验证/集成安全性连接到SQL Server？我使用的是Microsoft提供的type 4 JDBC驱动程序。前端（表单应用程序）用Java编码。一切都在Windows上完美运行，但办公室里的一个人使用Mac。

Is it possible to connect to SQL Server using Windows authentication/integrated security from a Mac? I am using the type 4 JDBC driver provided by Microsoft. The front end (a form application) is coded in Java. Everything works perfectly on Windows but one person in the office uses a Mac.

这可能吗？仅供参考，我从未使用过Mac，因此我非常喜欢它们。我在互联网上搜索过但没有找到解决方案。
提前谢谢。

Is this possible? FYI, I have never used Macs so I am very much the novice with them. I have searched all over the Internet but have not found a solution. Thank you in advance.

推荐答案

根据我的经验，这些信息很难得到。由于Microsoft更改了规则并添加了 authenticationScheme 参数，因此我的所有搜索都显示错误（过时）信息。为了帮助下一个人，下面是一个有效的连接字符串示例：

This information is hard to come by in my experience. All of my searches turned up wrong (outdated) information since Microsoft changed the rules and added the authenticationScheme parameter. In the interest of helping the next person, here is an example of a connection string that works:

jdbc:jtds:sqlserver://123.123.123;instance=server1;databaseName=students;integratedSecurity=true;authenticationScheme=JavaKerberos

同样在驱动程序属性中设置域。不要在任何用户名设置中包含域。

Also in driver properties set "Domain". Do not include the domain in any user name setting.

这是在Mac OSX上使用带有jtds的Squirrel SQL（Java）测试的。希望上一句话中有人可能使用的搜索词需要知道这些信息。

This was tested using Squirrel SQL (Java) with jtds on Mac OSX. Hopefully the previous sentence has the search terms someone might use who needs to know this information.

这篇关于在Mac上使用JBDC的SQL Server的Windows身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！