Microsoft SQL Server JDBC Connections


The following is a checklist of steps to take to resolve connectivity issues involving Microsoft SQL Server.

Trouble Shooting Checklist:

Ensure the Sql Server service is running

Ensure the user and password are correct.

Ensure the server name or TCP/IP address is correct. This can usually be tested by using a PING utility.

Ensure that the Sql Server has TCP/IP protocol enabled

Ensure the java.policy file grants the following permissions:

permission java.util.PropertyPermission "java.naming.*", "read,write";
permission java.net.SocketPermission "*.microsoft.com:0-65535", "connect"
permission java.io.FilePermission "C:\\TEMP\\", "read,write,delete"

See also:

Creating a Connection