I thought I’d provide a recipe for how to connect to SQL Server from Java. The following is a quick, relatively clean way to connect to Microsoft’s SQL Server from Java without going through too much voodoo–as is often the case when trying to connect to MS SQL Server through a non-microsoft language. Luckily, Microsoft provides a pure Java JDBC driver for connecting to it’s server! You can find it here. Don’t forget to properly include in your Java project! Also, even though it’s the MS SQL 2k3 driver, it works perfectly fine with MS SQL 2000 (so you might as well just use this driver).