dispatcher status showing stopped for disaster recovery server.

[Former Member]

HI,

today to test the data in our disaster recovery server for which we have log shipping every 30minutes we started the server in sap level during the process we can see that work +disp status is showing stopped.when i checked the log files in work directory it is showing below errors.

C sloledb.cpp [OpenOledbConnection,line 22822]: Error/Message: (err 4060, sev 0), Cannot open database "INP" requested by the login. The login failed.

M * LOCATION SAP-Server atriooonsapdr01_INP_00 on host terhsapdr01 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Mon Oct 06 16:31:42 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9780

M * COUNTER 1

kindly suggest what to check and how to resolve.

[Former Member]

Hi Anil.

you should be sure if user SAPINPDB exists in the database system and it is mapped to the SAPINPDB user of the DB.... this if you use SQL Server, but the rule should be something like this in other DB systems!!!

Regards

Pedro