Java connect MS SQL Server using windows authentication
To connect MS SQL Server using windows authentication, the first step is to setup ODBC. You can go to Control panel -> Administrative tools -> ODBC. Add a new DSN to connect MS SQL Server using windows authentication account following wizard setup.
The second step is the similar with using SQL Server authentication. The only change is that the connection string is: jdbc:odbc:dsn-name. There is no need to use username/password any longer, because it is already connected to the server!
Here is a sample code of a database class which uses windows authentication:
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Database { public Connection conn = null; private String dbName = null; public Database(){ } public Database(String dbName, String dbURL){ this.dbName = dbName; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); this.conn = DriverManager.getConnection(dbURL);//here put the new simple url. } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public ResultSet runSql(String sql) throws SQLException { Statement sta = conn.createStatement(); return sta.executeQuery(sql); } } |
The jar file can be downloaded here: http://dev.mysql.com/downloads/connector/j/
<pre><code> String foo = "bar"; </code></pre>
-
Amit
-
Abraham Janne
-
eric
-
Unnikrishnan P
-
clement