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...
>> 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
>
>.
>|||No problem - was that the problem?
Mike
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:3a9f01c522fb$e8e40340$a501280a@.phx.gbl...
> 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...
>> 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
>>
>>.