"com.sybase.jaguar.util.JException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."

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.


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