Cannot get connection for cache and display the error message "com.sybase.jaguar.util.JException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket".
Cause: The driver from Microsoft cannot handle windows integrated authentication.
Solution:
Step 1: Make sure that SQL Server is set to mixed authentication. To do this, open enterprise manager, right click on server/properties.
Step 2: Keeping the server properties dialog up, go to the general tab and push the network configuration button. Enable TCP/IP (it is disabled by default).
Step 3: Add an SQL Server login account (not a Windows account).
Step 4: Use the login setup in Step 3.
You can find detailed information from the following Website: http://support.microsoft.com/default.aspx?scid=kb;en-us;313178
