I spent the better part of today messing with Hyper-V and cloning to my heart's content. I am now officially running 2K8 / IIS 7 on all my dev servers. While this is not a big deal, one thing I wanted to do was also get and play with SQL 2K8. This was certainly an eye opening experience. Since I am not one to RTFM, I just went for it. First, after reading the differences between all the new versions of SQL, I decided that I wanted to try the Web version since it was all I seemed to need. I got this running on one of my clones and immediately tried to migrate over some of the databases I had on my 2005 dev machine. I first tried to use the Copy Database wizard and this failed; I was getting permissions issues. I then detached the database and physically moved the files over to the 2K8 SQL Server. When I tried to attach this time, I got an error saying that the file was read only. I checked the file and indeed it was *not* read-only.
So what is the issue? It turns out that I had logged in with Windows Auth to the server and as such, my user account did not have modify rights on the log file. Once I changed the CACLs on the file and retried the operation everything attached correctly and I was immediately up and running in my dev environment.