Hi

I'm trying to move the data folder where the db's are kept for SQL
Server 2005 from the C drive to the local D drive.

I've followed this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

Once detaching the database (Adventureworks say) the file won't move
(access denied). I guess it's locked. Stopping SQL Server doesn't make
any difference.

Also want to make sure new databases are created here by default. Also
the permissions for the SQL data folder is a bit weird, one of the
users is called:

SQLServer2005MSSQLUser$MYSERVER$MSSQLSERVER
(MYSERVER\SQLServer2005MSSQLUser$MYSERVER$MSSQLSERVER)

Bit of a long name and I can't assign that to my new data folder on the
new drive.

Does anybody have experiences on moving the databases over here. If
it's easier I'll remove/reinstall SQL server (it's a new install
without crititical data), however I couldn't see an option for where
the data goes by default).

Does anybody have experiences on moving the databases over with SQL
Server 2005?

Many thanks

Alex