Hello,
There are a couple of things that you can try. First of all, you can use the JTDS driver from
jTDS JDBC Driver. This driver has worked very well for me. Here are the connection properties:
Driver class: net.sourceforge.jtds.jdbc.Driver
Driver URL: jdbc:jtds:sqlserver://<host>:<port>/<database Name>
You also need to ensure that your sql server accepts TCP/IP connections. You can do this by going to SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, select Protocols for MSSQLSERVER, and enable TCP/IP.
You may also want to ensure that you have port 1433 set as the TCP/IP port. Go to the Registry Editor on the server machine. Go to HKEY_LOCAL_MACHINE ? SOFTWARE - Microsoft ? MSSQLServer-MSSQLServer ? SuperSocketNetLib ? TCP. Check the value for TcpPort. I hope this helps.