Login failed for 'sgdragnet' when moving database

[DaveR]

I moved Dragnet to a new server as follows:

- Backup the database on the old server
- Restore the database on the new server
- Run Dragnet installation
- Choose to keep existing database

The install succeeded, but Dragnet fails with the following error:

Cannot open database "sgdragnet" requested by the login. The login failed. Login failed for user 'sgdragnetuser'.

I checked before running the installation, and the "sgdragnet" login was not there. Thus, it was created by the Dragnet installer. Yet, this error persists.

I successfully moved Vault using the exact same procedure as above, with no problem.

Any help would be appreciated.

[DaveR]

Disregard ... I found the solution:

sp_change_users_login 'Auto_Fix', 'sgdragnetuser'