03-04-2012 10:09 AM
Scenario: transfer of a database from another PC/
1. Backed up database
2. Installed Act/SQL on new PC
3. Recreated database
4. Tried to restore but the username and password would not be accepted. I have never set passwords.
Use Restore as to a new database name. The username and password (left blank) were then accepted.
Will there be a fix for this?
03-04-2012 10:16 AM
When you move a database backup to another computer you must use restore as. I don't see any bug.
03-04-2012 12:12 PM
Because the database must be attached to the SQL server and restore can only restore a previously attached database that is still resident on the SQL server. Restore As allows attaching a database as a new database.