Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Error 5120

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.

I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".

I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.

The machine runs Windows Vista Business. SQL has SP 2 loaded.

Use the below script to find the sql service account

Code Snippet

declare @sqlser varchar(20)

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',@key='SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

@value_name='objectname', @value=@sqlser OUTPUT

PRINT 'Account Starting SQL Server Service:' +convert(varchar(30),@sqlser)

After getting the service account try the below steps to provide privilege

• Right click on the folder C:\ArrowSQL\Arr@Data and click on properties
• Click on security tab
• Click on Add button and add sql service account
• Provide modify privilege and click ok
• Verify both mdf and ldf have modify privilege
• Attach the db!
  
  
  BEST METHOD.
  
  
  
  
  You can also try the below alternate method to find service account

  
  

  • Goto RUN
  • Type services.msc & press enter
  • In service control manager find the below service w.r.t to your edition.

  For SQL 2000

  MSSQLSERVER -- for default instance

  MSSQL$instancename -- for named instance

  
  

  For SQL 2005 & SQL 2008

  SQL Server (MSSQLSERVER) -- for default instance

  SQL Server (instancename) -- for named instance

  • Check the "Log On as" for the SQL service and provide modify privilege to that ID in the folder.

For More Details, Click Here