Get Adobe Flash player

Monthly Archives: October 2010

Physical File Cannot be Opened – Attaching a Database

When attaching a database, the user gets a message stating the physical file could not be opened. This problem could be caused by the fact that an account without proper permissions cannot access a file. The *.mdf and *.ldf which is require to attach a database to a database instance. The message points to that clearly… “Access is Denied”Attach database failed for Server.

In order to fix this problem, you will have to increase your permissions to the MDF and the LDF files before attempting to attach them to the database. Locate the files and give your account full rights to the files. This requires you to navigate to the file location, right-click and select Properties to access the Security tab. Find your account or group and edit the permissions. You may currently only have Read access, so since your going to work with an online database you will have to make modifications, so give yourself Full Control.

Check the user permission

User Permission

Continue reading

Defender USA