Skip to Content
avatar image
Former Member

Not able to configure SQL server in MII Production server

Hi All,

I am facing problem in configuring a Data Server connection in MII production environment.

I have deployed the sqljdbc.jar, sqljdbc4.jar, una2000.jar, ojdbc14.jar drivers.

Following are the connections parameters

Connector Type : IDBC

JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Server URL : jdbc:sqlserver://<hostName>\<instanceName>;database=<dtabaseName>

Pool max. : 100

Pool Size : 10

Using these settings we are able to connect to the same SQL server from MII DEV and MII QA, but not able to connect the same SQL server from MII Production environment.

The SQL server we are using is MSSQL 2012

Following are the error details checked in the NW Log Viewer

Unable to get a connection from the pool

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host <hostName>, named instance <instanceName> failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

Thanks in advance.

Swapnil Bodkhe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 01, 2014 at 10:01 AM

    Dear Swapnil,

    I'd suggest two changes to your configuration,

    1. Delete drivers other than sqljdbc4.jar - which is enough for MII14.0 - SQL 2012 connections.

    2. The Connection url should be corrected as shown below,

    jdbc:sqlserver://<IPAddress:PortNumber>;instanceName=<Instance>;database=<DatabaseName>

    Also check with your network admin, whether your production VLAN has any firewall rule blocking the specified port - 1434.

    IP Address port combination is most preferable than the fully qualified domain name in hostName

    With regards,

    Ponilango P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2014 at 05:24 AM

    Try steps in this thread a/c to your IP and port.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2014 at 06:57 AM


    Thanks all for your help.

    We got the connection working by including a dynamic port in the URL, but this solution is not a reliable connection.

    Also I have checked for the TCP IP settings they are enabled and no firewall is active on the SQL server.

    I think if I am able to make connection from other MII servers leaves no doubt with the the SQL server configuration.

    We have to employ instance name in the the server URL as mention in my query and cant rely upon dynamic ports.

    I think there could be the problem with the Java environment on which MII Prod is setup, kindly drop some suggestions and constraints on using sqljdbc4.jar on the host MII server.

    Regards,

    Swapnil B

    Add comment
    10|10000 characters needed characters exceeded