DB Migration in DMZ (using local accounts)

Hi All,

due to new HW I had to migrate a WSS v2 content-DB to a new machine running WSS v3.

According to the MS guide I started PRESCAN in the v2 environment, made a backup (using SQL 2000), transfered the backup file to the new machine, restored the DB (using SQL 2005) and tried to attach the DB with "stsadm -o addcontentdb..." command on the new machine.

Before installing WSS v3 on the maschine I created different accounts for installing and SQL Server services.

While running stsadm without giving a special account I get the error message that I couldn't add a non-empty DB. Okay. So I started the stsadm with giving the SQL Server service account and password. Now I get the eror message which tells me that connenting to the DB is not possible due to bad credentials. You can believe that I checked name and password more that one time.

Because the machine are in a DMZ I was working with local accounts instead of domain accounts. Is it possible that this fact causes my problems (DB migration using domain accounts and MOSS2007 I did successfully).

Hope I expalined my issue transperently and you can point me to an error I made.

Thanks in advance,
Jens