on 12-06-2010 8:48 AM
Hi SAP Basis Gurus,
We are unable to installed Java Dailog instance for EP
error message:MDB-05800 <html>Unable to determine the port number for MSSQL version
Platform used:
OS: Win 2003 64-Bit
DB: MS SQL Server 2005
EP Version: EP 6.0 ( SAP Netweaver 2004)
We followed Below steps for Installation:
SQL Server installation on host SQLV605V: DVD used "51036539"
1. We installed SQL server 2005 using SQL4sap.vbs script.
2. Selected SID NPP for Named instance.
3. Prompt "SAP recommends that you install default instance. Do you
want to install deafult instance ? Selected "NO".
4. Installation finished successfully.
5. rebooted server.
6. Set Authentication mode "Mixed".
7. Enable sa user.
Central Instance Installation on host SQLV605V using System Copy: DVD
Used "51033746_15"
1. Selected SAP Netweaver 04 SR1 >System Copy>Target System-->
Java System >MS SQL Server>Migration Target System Installation.
2. Prompt for JAVA DVD. DVD USed "51031849_2"
and Migration Export path.
3. Prompt For SAPSID: "NPP"
and installation drive: E.
4. Prompt for JDK directory: c:\j2sdk1.4.2_28-x64\
5. Propmt for Java Crptographic tool kit: Selected Strong.
and Path for JCE policy.
6. SAP Domain Selection: Selected "Installation of domain of current
user".
7. Prompt for OS Password: BDN\nppadm & BDN\SAPServiceNPP
8. Propmt for SCS Instance Parameter:
SCS Instance Number 01 and
SAP Message service port( Leave empty for Default)= "Left EMPTY"
9. J2EE Engine Parameter:
Central Instance Number: 00
Number of servers: 1
Max Heap Size(MB):1024
10. Propmt for SDM user password and
Administrator user password.
11.Propmt for database Schema SAPNPPDB password:
12.Prompt for Java DVD: 51031849_3 & 51031849_1
13.Prompt for MS SQL Server Instance Name: Database Instance
name:SQLV605V\NPP
14.New Database will be created with same name as SAPSID.
15.Path for Database files: Data and Log
Dailog instance installation on host:SAPV606A: DVD Used "51033746_15"
we first installed SNAC from DVD and then
1.Selected SAP Netweaver 04 SR1 >SAP System Installation>
Java System>MS SQL Server>Central/Distributed System-->Dailog
Instance Installation.
2.Propmt for SAP System parameter:
SAPSID: NPP
SCS HOSTNAME:SQLV605V
3.Prompt for JDK path: c:\j2sdk1.4.2_28-x64\
4.SAP System User Domain:
Selected "Installation of domain of current user".
5.Propmt for OS User:
BDN\nppadm and BDN\SAPServiceNPP
6.Prompt for J2EE Engine Parameters:
Installation Drive: E
Instance Number: 00
Number of servers:1
MAx Heap Size (MB):1024
7.Prompt for Java DVD:51031849_3 & 51031849_1
after we receive error:
ERROR 2010-11-26 06:44:23 [iaxxinscbk.cpp:289]
abortInstallation
MDB-05800 <html>Unable to determine the port number for MSSQL version
NaN</html>
Our CI is working fine but unable to installa JAava dialog instance.
We have checked SAP Note: 639702 JDBC Driver for Microsoft SQL Server
and download latest JDBC driver files i.e jar files in j2ee/jdbc directory
E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa
<password>
-
Server : sqlv605v:3404
User : sa
Password : <password>
-
No Microsoft JDBC Driver found.
com.microsoft.sqlserver.jdbc.SQLServerDriver
-
Found DataDirect Driver.
Driver version is : 3.50.20 (016225.009408.011318)
JDBC version: 3.0
Then we tried downloading newer version and excuted below query
again:
E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa
<password>
-
Server : sqlv605v:3404
User : sa
Password : <password>
-
No Microsoft JDBC Driver found.
com.microsoft.sqlserver.jdbc.SQLServerDriver
-
Found DataDirect Driver.
Driver version is : 3.70.11 (029613.012904.017408)
JDBC version: 3.0
But still no success!!!
Details of jdbc & java url path in secure store:
jdbc/pool/NPP/ClassName=com.sap.nwmss.jdbc.sqlserver.SQLServerDriver
jdbc/pool/NPP/Url=jdbc:nwmss:sqlserver://SQLV605V:3404;databasename=NPP
Aslo the port Number is 3404 in regedit:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\NPP\MSSQLServer\SuperSoctNetLib\Tcp = 3404
We also modify the control.xml file in Master dvd in the else part in the
function. this.getPortNumber from 5912 to 3404 but still it gives same error:
trace of sapinst_dev.log:
-
Opened iamodmssql.dll
ERROR 2010-11-26 05:42:16 [iaxxinscbk.cpp:289]
abortInstallation
MDB-05800 <html>Unable to determine the port number for MSSQL version NaN</html>
TRACE [iaxxejsbas.hpp:270]
EJS_Base::dispatchFunctionCall()
JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined
WARNING 2010-11-26 05:42:16
lib=iamodmssql module=CIaNtMssDmo
Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
<br>Call your SAP Support.<br><br>
WARNING 2010-11-26 05:42:16 [iaxxccntrl.cpp:477]
CController::stepExecuted()
The step dConfigureDriver with step key J2EE_EngineEnterprise_DI|ind|ind|ind|WebAS|630|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|INSERT_JDBC_DRIVER_INTO_CONTEXT_TABLES|ind|ind|ind|ind|ind|0|MSS_JDBC_DRIVER|ind|ind|ind|ind|ind|0|dConfigureDriver was executed with status ERROR.
-
Please let me know how do we resolve this issue.
Regards,
Prashant Mistry
Edited by: Prashant MIstry on Dec 6, 2010 9:50 AM
in addition to above:
Our CI is working fine but unable to installa JAava dialog instance.
We have checked SAP Note: 639702 JDBC Driver for Microsoft SQL Server
and download latest JDBC driver files i.e jar files in j2ee/jdbc directory
E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa
<password>
-
Server : sqlv605v:3404
User : sa
Password : <password>
-
No Microsoft JDBC Driver found.
com.microsoft.sqlserver.jdbc.SQLServerDriver
-
Found DataDirect Driver.
Driver version is : 3.50.20 (016225.009408.011318)
JDBC version: 3.0
Then we tried downloading newer version and excuted below query
again:
E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa
<password>
-
Server : sqlv605v:3404
User : sa
Password : <password>
-
No Microsoft JDBC Driver found.
com.microsoft.sqlserver.jdbc.SQLServerDriver
-
Found DataDirect Driver.
Driver version is : 3.70.11 (029613.012904.017408)
JDBC version: 3.0
But still no success!!!
Details of jdbc & java url path in secure store:
jdbc/pool/NPP/ClassName=com.sap.nwmss.jdbc.sqlserver.SQLServerDriver
jdbc/pool/NPP/Url=jdbc:nwmss:sqlserver://SQLV605V:3404;databasename=NPP
Aslo the port Number is 3404 in regedit:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\NPP\MSSQLServer\SuperSoctNetLib\Tcp = 3404
We also modify the control.xml file in Master dvd in the else part in the
function. this.getPortNumber from 5912 to 3404 but still it gives same error:
trace of sapinst_dev.log:
-
Opened iamodmssql.dll
ERROR 2010-11-26 05:42:16 [iaxxinscbk.cpp:289]
abortInstallation
MDB-05800 <html>Unable to determine the port number for MSSQL version NaN</html>
TRACE [iaxxejsbas.hpp:270]
EJS_Base::dispatchFunctionCall()
JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined
WARNING 2010-11-26 05:42:16
lib=iamodmssql module=CIaNtMssDmo
Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
<br>Call your SAP Support.<br><br>
WARNING 2010-11-26 05:42:16 [iaxxccntrl.cpp:477]
CController::stepExecuted()
The step dConfigureDriver with step key J2EE_EngineEnterprise_DI|ind|ind|ind|WebAS|630|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|INSERT_JDBC_DRIVER_INTO_CONTEXT_TABLES|ind|ind|ind|ind|ind|0|MSS_JDBC_DRIVER|ind|ind|ind|ind|ind|0|dConfigureDriver was executed with status ERROR.
-
Please let me know how do we resolve this issue.
Regards,
Prashant Mistry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In addition to above details:
Our CI is working fine but unable to installa JAava dialog instance.
We have checked SAP Note: 639702 JDBC Driver for Microsoft SQL Server
and download latest JDBC driver files i.e jar files in j2ee/jdbc directory
E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa
<password>
-
Server : sqlv605v:3404
User : sa
Password : <password>
-
No Microsoft JDBC Driver found.
com.microsoft.sqlserver.jdbc.SQLServerDriver
-
Found DataDirect Driver.
Driver version is : 3.50.20 (016225.009408.011318)
JDBC version: 3.0
Then we tried downloading newer version and excuted below query
again:
E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa
<password>
-
Server : sqlv605v:3404
User : sa
Password : <password>
-
No Microsoft JDBC Driver found.
com.microsoft.sqlserver.jdbc.SQLServerDriver
-
Found DataDirect Driver.
Driver version is : 3.70.11 (029613.012904.017408)
JDBC version: 3.0
But still no success!!!
Details of jdbc & java url path in secure store:
jdbc/pool/NPP/ClassName=com.sap.nwmss.jdbc.sqlserver.SQLServerDriver
jdbc/pool/NPP/Url=jdbc:nwmss:sqlserver://SQLV605V:3404;databasename=NPP
Aslo the port Number is 3404 in regedit:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\NPP\MSSQLServer\SuperSoctNetLib\Tcp = 3404
We also modify the control.xml file in Master dvd in the else part in the
function. this.getPortNumber from 5912 to 3404 but still it gives same error:
trace of sapinst_dev.log:
-
Opened iamodmssql.dll
ERROR 2010-11-26 05:42:16 [iaxxinscbk.cpp:289]
abortInstallation
MDB-05800 <html>Unable to determine the port number for MSSQL version NaN</html>
TRACE [iaxxejsbas.hpp:270]
EJS_Base::dispatchFunctionCall()
JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined
WARNING 2010-11-26 05:42:16
lib=iamodmssql module=CIaNtMssDmo
Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
<br>Call your SAP Support.<br><br>
WARNING 2010-11-26 05:42:16 [iaxxccntrl.cpp:477]
CController::stepExecuted()
The step dConfigureDriver with step key J2EE_EngineEnterprise_DI|ind|ind|ind|WebAS|630|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|INSERT_JDBC_DRIVER_INTO_CONTEXT_TABLES|ind|ind|ind|ind|ind|0|MSS_JDBC_DRIVER|ind|ind|ind|ind|ind|0|dConfigureDriver was executed with status ERROR.
-
Please let me know how do we resolve this issue.
Regards,
Prashant Mistry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.