Move Dragnet Database To Another Server

[cs]

I would like to move a Dragnet database from one server to another.

Is there a way to cleanly move the Dragnet database to another server?

Do you recommend SQL detach/attach or SQL backup/restore, or another method?

Thanks

[jclausius]

To move the database either method will work.

However, once you've moved the database, you will have to do some configuration to re-hook up Dragnet to communicate with the database.

If you are using SQL Authentication, you will need to:
1) Create a new SQL Login ( matching the name found in Dragnet's web.config ), and the same password - by default this is your admin password
2) Within the Dragnet database ( USE sgdragnet ), you will need to re-sync the sql login accounts using

Code: Select all

sp_change_users_login 'Auto_Fix', 'sgdragnetuser'

If you are using Windows Authentication, you will need to make sure the ASP.Net process' account can authenticate across the network. In most cases, this requires a Domain based account configured for a Custom .Net application environment - See Running Vault Server under an Impersonated Windows Account for more information.

If you change Dragnet's ASP.Net process account, perhaps the easiest thing to do is configure the account, and then re-install the Dragnet Web Application using the Custom ASP.Net process model during installation. The installer will set all the correct permissions for proper Dragnet operation.

HTH