Some time when you try to attach database files (.mdf, . ldf) to sql server , you might get the error
"Unable to open physical file, operating system error"
The reason behind this is that the account from which you are accessing the file , does not have rights for this specific folder or file.
Solution for this is that , you have to give the rights. In my case i have given the rights to the local administrator
After giving the rights , try to attach the file again.
I have attached the database successfully.
"Unable to open physical file, operating system error"
The reason behind this is that the account from which you are accessing the file , does not have rights for this specific folder or file.
Solution for this is that , you have to give the rights. In my case i have given the rights to the local administrator
After giving the rights , try to attach the file again.
I have attached the database successfully.
it helps me thanks
ReplyDeletethank you zafar.
ReplyDeletei was facing same but using urs post i resolved that issue
jazakallah.
Haseeb
ashaseeb@hotmail.com
thanks, correct solution
ReplyDeletesaved me a lot of time. thanks
ReplyDeleteIn Windows 7, Open SSMS with "Login As Administrator".
ReplyDeleteYou may not be able to see permissions tab.
Pravin P
Rt, u dnt change the permissions, u change the user (to whom u give the permission) to Administrator... worked!
ReplyDeleteThanks...
If you have the admin rights to your system. you can actually run SSMS as an admin and this will solve the attachment problem.
ReplyDeleteYup..thank you for your elightment...it's working..
ReplyDeleteIts worked.Good..
ReplyDeleteTrick did the job. Thanks !
ReplyDeleteExcelent
ReplyDeleteNice post very helpful
ReplyDeletedbakings
"Run as administrator"... that's the key. Thank you.
ReplyDeleteThank you so much. We were able to solve the issue
ReplyDeleteSuperb. Issue was resolved. Thank u very much
ReplyDeletepocas veces entro a los blogs pero esta ves me sirvio de mucho gracias men ...
ReplyDeleteUseful
ReplyDeleteExcelllent Dude Superb.....
ReplyDeletethanks..it help me
ReplyDeleteThanx it worked for me. very useful post
ReplyDelete