I am assuming that you have used JDBC earlier. Connecting to MS SQL Server using JDBC is just like connecting to Oracle or any other database, except for a few parameters that are different.
Given the fact that SQL Server is from Microsoft, we have no native jdbc driver for SQL Server from Microsoft, like Oracle's driver. This leads us to the following possibilities:
1. Use the generic JDBC-ODBC driver from java
2. Use a third party native driver or type 3 driver. Merant has one native driver, I remember a native driver that came with Weblogic Server 5 but I am not sure if it is comercially available.
I will be glad to give you more information, if you need any.
Good luck!
Ravi