SQL Server works great with Java. You just have to pick the right JDBC driver.
I have used JTDS and MSJDBC and they both perform well. Unfortunately they don't behave identically, but it'a a minor issue if you choose which one to use from the start.
Hope this helps
Gianluca
-- Gianluca Sartori