Attach Database Issue

Hello,
I have just attached a database to a new server that I
successfully detached unfortunatly it said it was 'read
only'
Tried changing it, however there was a device activation
error on the data file.
Has anyone seen this before ?
JJulie,
I had this once and tracked it down to NTFS permissions on the attached file
only allowing read access to the account under which SQL Server is running -
Assuming that it is not so simple as the file being read only.
So I would check what account SQL server is running under, then check the
file permissions to that account for the data and log files.
Mike John
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:2f6101c520dd$804390a0$a501280a@.phx.gbl...
> Hello,
> I have just attached a database to a new server that I
> successfully detached unfortunatly it said it was 'read
> only'
> Tried changing it, however there was a device activation
> error on the data file.
> Has anyone seen this before ?
> J|||Thanks Mike

>--Original Message--
>Julie,
>I had this once and tracked it down to NTFS permissions
on the attached file
>only allowing read access to the account under which SQL
Server is running -
>Assuming that it is not so simple as the file being read
only.
>So I would check what account SQL server is running
under, then check the
>file permissions to that account for the data and log
files.
>Mike John
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2f6101c520dd$804390a0$a501280a@.phx.gbl...
>
>.
>|||No problem - was that the problem?
Mike
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:3a9f01c522fb$e8e40340$a501280a@.phx.gbl...[vbcol=seagreen]
> Thanks Mike
>
> on the attached file
> Server is running -
> only.
> under, then check the
> files.
> message