NW 7.3 MaxDB service stays starting

[Former Member]

Hello,

After restarting my PC, the NW refused to start. As I figured out it was because the Max DB database was not running. I tried to start it manually in Windows Services, but the service showed "starting" forever and never get to "started" state.

Then I figured out that the following command line can start the database (or bring database online):

C:\sapdb\M25\db\pgm>dbmcli.exe -d M25 -u control,control db_online

This command will also start the corresponding windows service.

How can I get the database started as a service and not through the command line?

These are the errors from DB error log (when I was starting it via the windows service)

2011-09-10 11:32:43      10344 INF          1 DBMSrvCo A DBM Server client connection was established at 2011-09-10 11:32:43 (client process has process ID 2264 on computer xxxx.xxxx.xxxx.ORG).
2011-09-10 11:32:43      10344 INF        421 DBMSrv   Command 'user_response ...' was executed since 2011-09-10 11:32:43.
2011-09-10 11:32:43      10344 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'user_response' has ended and failed with return code -24950.
                         10344 ERR     -24950 DBMSrv   ERR_USRFAIL: User authorization failed
2011-09-10 11:32:43      10344 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 2264 on computer xxxx.xxxx.xxxx.ORG).

[Former Member]

Hi,

Perhaps this link could be of help:

http://maxdb.sap.com/doc/7_6/41/7973831a361036e10000000a114cbd/content.htm

Especially the authorization related steps.

Regards,

Srikishan

[Former Member]

I checked out the db_reg command - this is for registration the DB. My DB is registered, because I can bring it online with the command line. I cannot bring it online by starting the corresponding windows service or switching this service to automatic mode.

What authorization steps do you mean?

P.S. NW 7.3 is based on Max DB 7.8 and the correct link in my case would be [http://maxdb.sap.com/doc/7_8/44/fc2189ed0641dee10000000a1553f6/frameset.htm]

[Former Member]

Hi Ivan,

During the startup by the Auto windows service, looks like the user authentication fails.

Could you let us know which user is configured for starting the corresponding windows service? Most probably this user does not have authorization to startup the database instance.

Regards,

Srikishan

[Former Member]

Hi Srikishan,

The user used to start the service is Local System Account. This user was configured by the SAP NW Installer. And the service has been started successfully at least once - during and after the NW 7.3 installation. However after I restarted my laptop the service never get started again.

How can I diagnose that the problem is in the service user account? I tried to start the service as Administrator, but there was the same problem.

As I mentioned before if I execute the command line to bring DB online the service is implicitly started by that command.

One more thing, NW 7.3 is running on Win7 64 bit.

Thanks

Ivan

[Former Member]

Hi Ivan,

As its Win 7 - is the UAC enabled? Disabling it could help.

Also when the service is hung in 'Starting' phase, does the windows "Event Viewer" Log give any further errors messages?

Regards,

Srikishan

[Former Member]

I disable UAC with no success.

Also I checked the event log but there were only information messages from MAX DB.

Still I was able to start the DB with command line, so I just created a shortcut for the command.

[Former Member]

Hi Ivan,

Workaround seems to be the only solution

May I suggest a Windows startup script for starting the database:

http://www.tutorial5.com/content/view/157/47/

Regards,

Srikishan