We use java for a lot of our jobs, and using it to access SQL Server is no exception. We wanted to have controlled access, and avoid “user sprawl” across servers. As such, we use Windows authentication from our java programs. Below is an example:<\/p>\n
\r\nimport java.sql.*;\r\nimport com.microsoft.sqlserver.jdbc.*;\r\n\r\npublic class connSqlServer {\r\n public static void main(String[] args) {\r\n try {\r\n Connection con = DriverManager.getConnection(\"jdbc:sqlserver:\/\/STSQL01.fake_domain:1433;databaseName=MSDB;integratedSecurity=true;\");\r\n Statement stm = con.createStatement();\r\n ResultSet rst = stm.executeQuery(\"select * from msdb.dbo.backupset\");\r\n while (rst.next()) {\r\n System.out.println(rst.getString(\"database_name\"));\r\n }\r\n }\r\n catch (Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"We use java for a lot of our jobs, and using it to access SQL Server is no exception. We wanted to have controlled access, and avoid “user sprawl” across servers. As such, we use Windows authentication from our java…<\/p>\n