MaxDB on W2k3 R2 64-bit - No Connection to Database - No Instance found

[Former Member]

Hello,

I´ve installed a SolMan 4.0 SP 9 on W2K3 R2 64-bit host. The installed DB is a MaxDB 7.6, and its running.

While trying to backup my database I recognized that I cannot connect to my database via DB-Manager. The appearing popup says:

-4 server rejected connection

I tried the default Port Option as well as 3306, 3900 and 3901.

I think there a two instances of maxDB running, and the ports 3900 and 3901 must work.

I have no idea what went wrong. (firewall isn´t blocking, db and system are running ..)

Has anybody a helpful idea?

thanx

[Former Member]

Hello,

the Solution is to manage the installed maxDB on the 64-bit-host remotely with the DBMGUI(installed on a 32-bit OS).

Thanks

[former_member229109]

Hello Thomas,

-> What is the database version? You wrote - MaxDB 7.6, but it's not complete information about database version.

< SAP Note No. 972785 >

You could run the dbm command 'show version' or check the version in the knldiag file, for example.

-> What is the DBMGUI version?

-> Do you have the DBMGUI installed on Windows 64-bit server?

< See the SAP note 889251 >

-> By default the x_server is using the port 7210.

Did you restart the x_server on the database server?

Please check that you have the MAXDB port in services file... \drivers\etc\services:

sql6 7210/tcp # MAXDB Port

< this line has to be added correctly during the database software

installation! Did you change it later manually? It's not recommended!>

Why did you try with Ports as 3306, 3900 and 3901? What services listed for those ports in the 'services' file?

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello Natalia,

<b>-> What is the DBMGUI version?</b>

the DBMGUI Version is 7.6.0.25

<b>-> Do you have the DBMGUI installed on Windows 64-bit server?</b>

Yes

<b>< See the SAP note 889251 ></b>

??? - I dont really understand if I have to install a new (remote like) db or if I have to give zhe install user the permission to log on as batch job

Or is it possible to manage the db remote from a 32-bit system?

some knldiag - Info:

19600 VERSION 'Kernel 7.6.00 Build 035-123-139-084'

<b>19600 VERSION 'W64/AMD64 7.6.00 Build 035-123-139-084'</b>

Starting SERVERDB: 'SMD'

SERVERNODE: 'server.domain.local'

Process ID: 3512

Date: 2007-04-11

Owner: 'SYSTEM'

Product suite: 'Terminal Server'

Machine: 'AMD64 level f revision 604'

Processors: 2 ( logical: 8 )

Fiber: 'YES'

Max virtual memory: 8388607 MB

Total physical memory: 6142 MB

Available physical memory: 5115 MB

Memory allocation not limited

System page cache usage enabled

3306 is default MySQL

3900 and 3901 where in use by the system but not listed in services!

the 7210 is in it - so my info with the default port was wrong !