I had SQL Server 2008 R2. I uninstalled it and installed SQL Server 2012 - now I can’t attach the database or the backup database because I have an error:
Directory search for file failed with operating system error 5 (access is denied.)
What should I do?: (
Check the path to the directory where the backup and restore are taking place. (some folder may be deleted). In addition, the solution will be that you can make a backup using scripts , and there you can avoid this error by specifying the path to backup or restore the database.
See http://social.msdn.microsoft.com/Forums/en-US/sqlkjmanageability/thread/1d044ccd-9c16-4a60-819d-cf7f9125384c
SQL Server 2012 works with your user account, so if you do not have read access and privileges, you will receive this error to grant administrator privileges to your account or the appropriate rights necessary to complete your task.