Home Forums SQL Server 2005 Administering Operating system error 5(Access is denied.) to master.mdf'' RE: Operating system error 5(Access is denied.) to master.mdf''''

  • Where does it say anything about PERMISSIONS??? It says ACCESS IS DENIED. Totally different.

    Causes:

    1. the SAN is not available.

    This can happen on a reboot where the server comes up and the SAN is not attached yet. You need to put the SAN as a dependancy for MSSQLServer service.

    2. The .mdf file is READ-ONLY.

    Right click on the file, select Properties. Is READ-ONLY checked?

    3. The .mdf is in use.

    Do you have Antivirus on the server? Does it run upon restart? If it is scanning the .mdf or .ldf files, then they are in use and cannot be attached. Set the Antivirus to ignore extensions .mdf, .ndf, and .ldf.

    -SQLBill