Moving Database - General Support

BugNET Forums

Forum Support General Support Moving Database

9/13/2007 5:12 PM

	datzent83
5 posts

Moving Database

I am using SQL 2005 and I need to move my database from MACHINE 1 to MACHINE 2. When I do backup of the database in MACHINE 1 and then restore the database to MACHINE 2 with the replacing the existing database option checked, it does not give me any errors, but when I try to log in to the website it gives me "Your login attempt was not successful. Please try again." error message.

Is there a specific way to transferring the database between two SQL servers?

9/13/2007 8:10 PM

	admin
658 posts
bugnetproject.com

Re: Moving Database

datzent83 wrote

I am using SQL 2005 and I need to move my database from MACHINE 1 to MACHINE 2. When I do backup of the database in MACHINE 1 and then restore the database to MACHINE 2 with the replacing the existing database option checked, it does not give me any errors, but when I try to log in to the website it gives me "Your login attempt was not successful. Please try again." error message.

Is there a specific way to transferring the database between two SQL servers?

The only other thing you will need to do is copy the machine key from your old web.config to the new one on your other server. This key is used for encrypting and decrypting the passwords in the database so if they are different you cannot unencrypt them.

Davin Dubeau
BugNET - Core Developer

Page 1 of 1

Forum

Support

General Support

Moving Database

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.