Windows Authentication for SQL Server using JBDC on a Mac

java sql sql-server macos windows-authentication
user1406416 picture user1406416 · Jun 27, 2012 · Viewed 17.7k times · Source

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.

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.

Answer

Ray Morris picture Ray Morris · Sep 27, 2012

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.

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.

Related questions

Which jar to use for connecting to MS SQL server

Can some one please guide me to understand which jar file i need to include in my application to be able to set up a jdbc connection with ms sql server. thanks in advance.

Read More
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

I used this code to create a connection to SQL Server. String connectionUrl = "jdbc:sqlserver://IP:1433;" + "databaseName=db;user=db;password=pwd"; Connection con = null; try { // Establish the connection. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(connectionUrl); …

Read More
What are the difference between: sequence id using JPA @TableGenerator, @GeneratedValue vs database Auto_Increment

Q1.: What is the difference between applying sequence Id in a database using A. CREATE TABLE Person ( id long NOT NULL AUTO_INCREMENT ... PRIMARY KEY (id) ) versus B. @Entity public class Person { @Id @TableGenerator(name="TABLE_GEN", table="SEQUENCE_TABLE", …

Read More