Moving site to New Web Server and Database Server

melbert09 · Post by **melbert09** » Fri Apr 28, 2006 7:46 am

Hello,
I want to move current installation of Dragnet to another server. I the main issue that Im having is with the DB, when I try to restore it, the website errors out about the sgdragnet account. I have tried to just move over the data to the new db but that errors out as well. Can anyone help me here????

Thanks
Mel

lbauer · Post by **lbauer** » Fri Apr 28, 2006 7:59 am

If you move a Dragnet database from one SQL Server to another, the sgdragnetuser login must be dropped and recreated. The easiest way to do this is to let the installer take care of it.

The steps would be: backup and restore (or detach and re-attach) your sgdragnet database to the new SQL Server machine. Then run the Dragnet installer. It will detect the database and ask if you want to keep it. Choose "yes." The installer will then configure the appropriate login and user for the database.