Login failed for 'sgdragnet' when moving database

If you are having a problem using Dragnet, post a message here.

Moderator: SourceGear


Posts: 6
Joined: Tue Jun 27, 2006 5:43 pm
PostPosted: Tue Jun 27, 2006 5:45 pm
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.

Posts: 6
Joined: Tue Jun 27, 2006 5:43 pm
PostPosted: Tue Jun 27, 2006 6:50 pm
Disregard ... I found the solution:

sp_change_users_login 'Auto_Fix', 'sgdragnetuser'

Return to Support (Dragnet)

Who is online

Users browsing this forum: No registered users and 2 guests

cron