How to move databse to another comp?

Prashant_1 · Post by **Prashant_1** » Sun Dec 04, 2005 4:16 am

I am using Dragnet for personal use on localhost with MSDE.

I want to move my dragnet database to a different computer.

This is what I have done so far-
Used the backup command on the previous computer to create a .dat file containing the sgdragnet database.
Then I installed dragnet on my new comp using the
Machine Login and Windows Authentication options.
I then used the restore command to restore the backed up database.

Now when I try to open dragnet by typing 'localhost/Dragnet' in my browser, it says-
Cannot open database requested in login 'sgdragnet'. Login fails. Login failed for user 'MYCOMP\ASPNET'.

I guess I am supposed to some more configuration.

Could anyone please guide me as to what exactly I am supposed to do next as I am not too familiar with windows security settings.

Post by **jclausius** » Sun Dec 04, 2005 8:29 am

You almost had it.

Try it in this order:

1) Backup the sgdragnet database
2) Restore it on the new computer.
3) Install Dragnet. The Dragnet installation will find the database, answer the prompts that you want to use the existing database.

This is similar to the following KB article http://support.sourcegear.com/viewtopic.php?t=228