Remember that D:\ is from the perspective of the server. If you have downloaded the AdventureWorks mdf file to your own D:\ drive and are trying to attach it to a shared instance that is not hosted on your local machine, i.e. that does not have access to the file using that same path to your local D:\ drive, then you can see problems like this too.