cancel
Showing results for 
Search instead for 
Did you mean: 

Installation ECC 6.0 / Sql Server 2005 with "named instance"

Former Member
0 Kudos

Hi all,

we have problem with an installation of a new instance, we want install a new ECC with a "named instance" in SQL Server 2005. Now we have, in the same server, two instance installed with a "default instace" and we want add a new one. I have run SQL4SAP.vbs and I have insert in the field the name of new instance (TST). After that I have run sapinst, during the installation we have a problem with Java Load import. I have attach the logs of sapint.

this is the jload log:

20.09.07 15:46:07 com.sap.inst.jload.Jload main

INFO: Jload -sec TST,jdbc/pool/TST,
acsap03/sapmnt/TST/SYS/global/security/data/SecStore.properties,
acsap03/sapmnt/TST/SYS/global/security/data/SecStore.key -dataDir G:/SAPCD/JAVA\JAVA_EXPORT\JDMP -job C:\Program Files\sapinst_instdir\ERP\SYSTEM\MSS\CENTRAL\AS\IMPORT.XML -log jload.log

20.09.07 15:46:20 com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

20.09.07 15:46:20 com.sap.inst.jload.Jload logStackTrace

SEVERE: java.sql.SQLException: [SAP_NWmss][SQLServer JDBC Driver][SAP_NWmss][SQLServer JDBC Driver]The requested instance is either invalid or not running.

at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.connect(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.open(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseDriver.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)

and this is jload.java.log:

java version "1.4.2_13"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_13-b06)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_13-b06, mixed mode)

Sep 20, 2007 4:57:41 PM com.sap.inst.jload.Jload main

INFO: Jload -sec TST,jdbc/pool/TST,
acsap03/sapmnt/TST/SYS/global/security/data/SecStore.properties,
acsap03/sapmnt/TST/SYS/global/security/data/SecStore.key -dataDir G:/SAPCD/JAVA\JAVA_EXPORT\JDMP -job C:\Program Files\sapinst_instdir\ERP\SYSTEM\MSS\CENTRAL\AS\IMPORT.XML -log jload.log

Sep 20, 2007 4:57:55 PM com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

Sep 20, 2007 4:57:55 PM com.sap.inst.jload.Jload logStackTrace

SEVERE: java.sql.SQLException: [SAP_NWmss][SQLServer JDBC Driver][SAP_NWmss][SQLServer JDBC Driver]The requested instance is either invalid or not running.

at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.connect(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.open(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseDriver.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)

Wait for you suggest, thanks bye.

Accepted Solutions (0)

Answers (1)

Answers (1)

clas_hortien
Active Contributor
0 Kudos

Hello,

please open a command prompt and chnage into the log directory of the sapisnt. Then set the environment variable


set SAPINST_MSS_LOG=0N 

and start from this command prompt the sapisnt from the original location. Then the sapisnt will write an additional logfile MSSlog.log. Check this log file for additional information about the error.

Regards

Clas