This error was reported when I used sql2005 to attach a database today...
Itle: Microsoft SQL Server Management studio Express
------------------------------
An error occurred while appending the database. For more information, click the hyperlink in the message column.
------------------------------
Buttons:
OK
------------------------------
Title: Microsoft SQL Server Management studio Express
------------------------------
An error occurred while attaching the database to the server "myhfut/sqlexpress. (Microsoft. sqlserver. Express. SMO)
For help, click: http://go.microsoft.com/fwlink? Prodname = Microsoft + SQL + server & prodver = 9.00.2047.00 & evtsrc = Microsoft. sqlserver. Management. SMO. exceptiontemplates. failedoperationexceptiontext & evtid = additional database + server & linkid = 20476
------------------------------
Additional information:
An exception occurred when executing a Transact-SQL statement or batch processing. (Microsoft. sqlserver. Express. connectioninfo)
------------------------------
The physical file "C/AA. MDF" cannot be opened ". Operating System Error 5: "5 (Access denied .) ". (Microsoft SQL Server, error: 5120)
For help, click: http://go.microsoft.com/fwlink? Prodname = Microsoft + SQL + server & prodver = 09.00.2047 & evtsrc = MSSQLServer & evtid = 5120 & linkid = 20476
------------------------------
Buttons:
OK
------------------------------
Solution:
Re-connect to the database without adding SA users. Select windows integration verification mode. OK