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