Last week I changed the location of all my database files to an external harddisk. You can easily do this by detaching databases.

However, after having moved and attached the files again, SQL server wouldn’t load the files…

After some searching I found that you need to add a group to the security tab of the db files.

On my computer this group is called SQLServer2005MSSQLUser$TLV-EDU-LIC$SQL2005. You can easily go and check the security on the original folder to find out the correct name.

After I added this group and gave it full control, my db’s were up and running again.