nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Clip_508.jpg

タグ付けされた投稿をもっと見る

Accepted answers

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,

Hi guys,

I got the solution in the link below

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

best

Jamal

All comments

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,

Hi guys,

I got the solution in the link below

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

best

Jamal

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?

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,

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...

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.