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

64 Views

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. http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q241397&ID=KB;EN-US;Q241397http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q241397&ID=KB;EN-US;Q241397">http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q241397&ID=KB;EN-US;Q241397>

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003">http://support.microsoft.com/default.aspx?scid=kb;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?