How to detach a sql server 2008 database that is not in database list? I installed sql server 2008 on windows 7 then i create a Database! after 2 days, i reinstall the windows and install the sql server! now i am trying to attach my database file, but i encounter to bellow error. i think that the files are like a attached file and i can't attach them. what is difference of an attached file and a not attached file? how can i to attach this file? Please Help Me.

Error Text:


  TITLE: Microsoft SQL Server Management Studio
  
  Attach database failed for Server 'AMIR-PC'. (Microsoft.SqlServer.Smo)
  
  For help, click:
  http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&amp;EvtID=Attach+database+Server&amp;LinkId=20476
  
  ADDITIONAL INFORMATION:
  
  An exception occurred while executing a Transact-SQL statement or
  batch. (Microsoft.SqlServer.ConnectionInfo)
  
  Unable to open the physical file "F:\Company.mdf". Operating system
  error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)
  
  For help, click:
  http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.50.1600&amp;EvtSrc=MSSQLServer&amp;EvtID=5120&amp;LinkId=20476
I'm pretty sure the problem is that due to the uninstall/reinstall of SQL Server, the database engine no longer has permissions on the database files.

If you move the .mdf and .ldf files to the data folder that you specified on install, it should work for you. If you want to keep the files where they are, make sure the permissions are configured to allow appropriate access to the database engine service account group.