November 11, 2008 at 4:35 am
Hi All
When i am trying to start my sql server services ( sql server 2005) , it is throwing error : " FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation."
Please advise
November 11, 2008 at 4:52 am
Did you check that the file exists at that location ?
If somebody moved or deleted the file while SQL Server was stopped, you will get this error.
[font="Verdana"]Markus Bohse[/font]
November 11, 2008 at 5:07 am
nikhil.verma (11/11/2008)
Hi AllWhen i am trying to start my sql server services ( sql server 2005) , it is throwing error : " FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation."
Please advise
check the SQL Server startup options in SQL BOL.
November 12, 2008 at 10:23 am
It is exactly what the error says, instance can't access the file, it could be in use by another instance (of sqlserver) or another process (like backup), or it could have readonly attribute.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply