To follow on from the Ninja, the SQL Server database engine service account must have permissions to read/write in the new folder. Your account permissions do not matter. When you do this in SSMS, you are asking the SQL Server service account to actually take a lock on the MDF file and open it for read/write.