I just figured out that for the "user_system" dmbsrv command to succeed the user you specify needs the right "logon as batch process" (logon type 4). This applies to Windows XP Pro at least, should be the same on win2k.
On XP Pro you can assign these rights by executing "gpedit.msc". Marco ----- Original Message ----- From: "Yves Trudeau" <[EMAIL PROTECTED]> To: "SAP DB General List" <[EMAIL PROTECTED]>; "Watz" <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 11:05 PM Subject: RE: Creating a database from a backup > Hi, > I had never been successful with DBMGUI. I am using version 7.3.0.15 > (latest?) and I get authentication failure (logon to system failed) at step > 1 when I am creating a database on the localhost. On Win 2k, I created a > user "sapdb" with password "sapdb", grant the user the right to log on as a > service and then I tried DBMGUI with no success. > > What is your recipe? > > Yves > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Watz > Sent: 11 mars, 2002 16:30 > To: Yves Trudeau; SAP DB General List > Subject: Re: Creating a database from a backup > > > Hi, > > I don't know about dbmcli, but the DBMGUI database creation wizard asks you, > once you've entered all parameters, if you want to recreate the database > from a previous backup or create an empty one. I believe you don't even have > to enter the same dev/log devspace sizes as long as theres enough space in > the data devspace for the backup you want to restore. > > I've already used that option with a 7.2 SAPDB and it worked just fine. > > > Regards, > > Marco > > ----- Original Message ----- > From: "Yves Trudeau" <[EMAIL PROTECTED]> > To: "SAP DB General List" <[EMAIL PROTECTED]> > Sent: Monday, March 11, 2002 10:02 PM > Subject: Creating a database from a backup > > > > Hi, > > I am preparing myself for the worst, a server crash. So, I try to install > > Sapdb on another computer and then loads a recent backup. To be more > > specific, I try to import a backup database backup from a Linux server to > a > > Windows 2k machine (my laptop). Both systems are using sapdb 7.3.0.21. > > > > I created the database with the same parameters for the datafiles, the > > logfiles and the backup mediums (a simple hack of create_demo_db). Then I > > copied the backup of the Linux machine on the laptop and I tried to > recover > > the backup with dbmcli. > > > > I got the following lines: > > > > C:\Program Files\SAPDB\depend\misc>dbmcli -d TEST -u dbm,dbm > > dbmcli on TEST>db_cold > > OK > > > > --- > > dbmcli on TEST>util_connect dbm,dbm > > OK > > > > --- > > dbmcli on TEST>recover_start data DATA > > ERR > > -24988,ERR_SQL: sql error > > -903,Message not available,blockcount mismatch > > > > --- > > dbmcli on TEST> > > > > > > There is surely something I am doing wrong since I believe such a > procedure > > is a requirement for a database. > > > > Any hints are welcomed! > > > > Yves Trudeau > > > > > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
