The connection to the named instance has failed. Error: java.net.SocketTime

[Former Member]

Hi folks,

I am facing an error while installing SOLMAN on an named instance of MSSQL.

Hereu2019s the situation: the server is already running ERP DEV on the default instance, and customer decided to use the same box for SOLMAN, so I decided to install it on a named instance (\SMD), instead of going for MCOD.

During phase 18 of 44 (Import Java Dump), I am getting the following error. Have you guys ever faced this error before?

Thanks for your help,

Marco

java version "1.4.2_14"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_14-b05)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_14-b05, mixed mode)

Dec 17, 2008 10:48:05 AM com.sap.inst.jload.Jload main

INFO: Jload -sec

SMD,jdbc/pool/SMD,
oc-sap-dev/sapmnt/SMD/SYS/global/security/data/SecStore.properties,
oc-sap-dev/sapmnt/SMD/SYS/global/security/data/SecStore.key

-dataDir F:/SW_REPOSITORY/SOLMAN/51033521\DATA_UNITS\JAVA_EXPORT_JDMP

-job D:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\MSS\CENTRAL\AS\IMPORT.XML -log jload.log

Dec 17, 2008 10:48:16 AM com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

Dec 17, 2008 10:48:16 AM com.sap.inst.jload.Jload logStackTrace

SEVERE: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the named instance has failed. Error: java.net.SocketTimeoutException: Receive timed out.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(UnknownSource)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at

com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)

at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)

at com.sap.inst.jload.Jload.main(Jload.java:580)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

[Former Member]

I figured it out. SQL Server Browser must me running.

[Former Member]

"

[Former Member]

Reason- Due to changes in network IP Address or IP address range of your machine & SQL Server Machine).

Identification-

1) Ping SQLServer Machine--TimeOut

2) Firewall setting

Resoluation-

Correct the IP address range given for SQL Server machine with your machibe newly allocated IP address.

Change VLAN Setting by Network Admin