RE: Atteched DB's only "read only"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Matt,

An OS Error of 5 typically means that you don't have permissions to modify
a particular file. I suspect that the account SQL Server Service is running
under does not have permissions to modify the .ldf and .mdf files. Firstly,
please verify the account the SQL Server service is using. To do this you
can click on Start > Microsoft SQL Server 2005 > Configuration Tools > SQL
Server configuration manager. Note the "log on as" column value for the SQL
Server instance you are connected to (MSSQLSERVER is the default).
Secondly, right click on both the .mdf and .ldf files and select
properties. Then from within the "security" tab verify that that the
account for the SQL Server service has write permissions to these files. I
would appreciate the knowing the outcome of this.

Thanks,
Jaaved Mohammed [MSFT]

.

Relevant Pages

  • Re: viewing asp pages from other machine
    ... Modify the permissions using front page if it is a Front Page website. ... don't ever modify the IUSR_account in any way. ... > but it asks for a username and password for him to open ...
    (microsoft.public.inetserver.iis)
  • Re: User rights.
    ... >> all permissions and rights granted to any and all groups ... >> of which the account is a member, ... >> modify in others. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: permissions
    ... What is the setting of the Share permissions? ... at NTFS level allow the account used to connect ... from Computer B to have modify on the containing folder ...
    (microsoft.public.windowsxp.security_admin)
  • Re: IIS write permissions and perl
    ... >>to create directories and files as well as modify existing files. ... >>Should permissions be set in NTFS? ... I just assumed that perl is running under the sane account as IIS, ...
    (microsoft.public.inetserver.iis)
  • Re: SQL 2000 - unable to set SQL Agent proxy acc.
    ... the permissions issues hits when changing ... >> Check the permissions for the SQL Server service account. ...
    (microsoft.public.sqlserver.server)