Skip to Content
Former Member
Oct 27, 2004 at 06:27 PM

MiniSAP (4.6D): Backup and restore DB for upgrade


I am an ABAPer and I have miniSAP, 4.6D (MBS) from the ABAP objects programming book.

This version of miniSAP uses MS SQLserver 2000 desktop edition (MSDE/MSDE 2000/MSDE 2) as its database. MSDE is a very limited version of SQLserver, max size 2Gb, max 2 processors, 5 users, and <b>no adimistration tools</b>.

I want to test backup and restore before I try to patch this db with SP3a. And I want to do this before I apply SP2 for windows XP.

I have read the MS infomation articles Q241397 and Q325003.;EN-US;Q241397&ID=KB;EN-US;Q241397;EN-US;Q241397&ID=KB;EN-US;Q241397">;EN-US;Q241397&ID=KB;EN-US;Q241397>;EN-US;q325003;EN-US;q325003">;EN-US;q325003>

When I run the sql file as per Q241397 I get the error message 'Login failed for user 'sa'. Reason: Not associated with a trusted SQL server connection.'

So has any one done this before, or does any one know what user and password to use. Or is there a way of doing this from within miniSAP or with the tools supplied with this book?