Attach command failes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Francesco - 14 Feb 2008 12:52 GMT

Hi
I have just received data files ( .mdf and .ldf ) and I need to attach them
to a sql express 2005. My machine is WinXP vers. 2002 SP2.

I downloaded the varius files (.NET 2, sql 2005, sql management studio
express) and installation was ok. No errors. No warnings

I am trying now to attach the data from management studio console (Database
- Attach).
But when adding .mdf file location I receive the following message:
"Failed to retrieve data.. CREATE FILE encounted operating system error 5
while attempting to open/create... Error 5123"

Do you miss anything? Any idea?
Thank you for your suggestions.

Reply to this Message

Zarko Jovanovic - 14 Feb 2008 13:01 GMT

> Hi
> I have just received data files ( .mdf and .ldf ) and I need to attach them
[quoted text clipped - 11 lines]
> Do you miss anything? Any idea?
> Thank you for your suggestions.

Google says this is "access denied":
operating system error 5 !!!

Reply to this Message

PSPDBA - 14 Feb 2008 14:52 GMT

On Feb 14, 8:01 am, Zarko Jovanovic
<mind_lessIsHsAsTsEsSsPsA...@inet.hr> wrote:

> > Hi
> > I have just received data files ( .mdf and .ldf ) and I need to attach them
[quoted text clipped - 16 lines]
>
> - Show quoted text -

To explain, SQL Management Studio is trying to look for a file where
you do not have permissions. This can be caused by (simple) NT file
permissions or (not so simple) something else is holding the .mdf
file. The latter problem is usually some type of anti-virus software
trying to scan the .mdf and .ldf files.

If you've double-checked the directory permissions, you may want to
use Sysinternals Process Explorer (which is a free download from
Microsoft) and search for handles on the .mdf - that will tell you if
something else strange is going on.

Reply to this Message

Jay N - 15 Mar 2008 01:04 GMT

Make sure SQL Management Studio is running as admin. Setting full
permissions on the database file alone wasn't sufficient for me. Sign on as
admin in Win XP. If using Vista, right click on the SQL Studio application
link and select Run as Administrator. Then you will be able to attach a
database from anywhere in the file system.

Reply to this Message