Thursday, January 3, 2008

SQL Error: RestoreContainer::ValidateTargetForCreation

Scenario: I created a backup of a database on the server (Server2003) running SQL 2000. When I tried to restore the database on an XP machine running SQL 2005, I got the following error: The operating system return the error '5(Access is denied)' while attempting 'RestoreContainer::ValidateTargetForCreation' on ''

Resolution:
1. On the XP machine (or whatever machine you are trying to restore to), open SQL configuration manager.
2. Right Click SQL Server Express (or SQL Server (SQLEXPRESS) if running full SQL)
3. Choose Properties
4. On the Logon Tab, make sure the "Built in Account" radio button is checked and then choose "Local System" from the dropdown

This allowed me to restore the backup. This is not as secure, obviously, so I will probably want to change it back after my restore has been completed.

No comments: