Fail to attach mdf file in the sql server,

[Anonymous User]

Original User: Jamal432@gmail.com

Fail to attach mdf file in the sql server,

My mdf file is stored in the root of my hard drive (F:\).


[ATTACH=CONFIG]22581[/ATTACH]

I tried to to attach it to the sql server but I got the message below:

[ATTACH=CONFIG]22582[/ATTACH], [ATTACH=CONFIG]22586[/ATTACH]


Then I copied this file to my D drive and it is successfully attached!

[ATTACH=CONFIG]22583[/ATTACH], [ATTACH=CONFIG]22584[/ATTACH]


What might be the issue then?

Why this mdf file fails to attach while being stored in the F:\ drive?


Thank you

Best

Jamal

[MarcoBoeringa]

Jamal,

Is your F: drive a removable disk? Sometimes these things only work for fixed internal disks. And sometimes you aren't allowed to put a file in root either... I have seen many of these similar issues with multiple different programs. E.g. I recently discovered I wasn't able to use an external disk attached to a front USB port of my desktop as the backup drive for a Windows 7 system backup. When I attached it to a back USB port (directly connected to the mainboard), it worked like a charm...

[Anonymous User]

Original User: asrujit

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

[JamalNUMAN]

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Thank you guys for the contribution,

1. First, I thought that this problem is because it is stored in an external hard drive or on the root. In other cases, this file is neither stored in an external nor in the root, nevertheless it didn�??t work and the error persists to exit!

2. I tried to start the �??SQL Server Management Studio�?� but the the error persists to exit!

[ATTACH=CONFIG]22613[/ATTACH], [ATTACH=CONFIG]22614[/ATTACH], [ATTACH=CONFIG]22615[/ATTACH][ATTACH=CONFIG]22615[/ATTACH]

What other alternatives should I try?

[JamalNUMAN · Accepted solution]

Jamal,

Its a permissions based issue.

Right click on SQL Server Management Studio and Run As Administrator. Try the attach. It should resolve the issue for you.

Regards,

Hi guys,

I got the solution in the link below

http://social.msdn.microsoft.com/Forums/en-US/databasedesign/thread/274d3860-137e-4cd5-9635-5558edc6...

best

Jamal