Im trying to attach AdventureWorksDW2008.mdf Database in SQL Server Management Studio. This file resides in C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA. After selecting the file I get error:
An exception error occurred while executing a Transact-SQL statement or batch.
CREATE FILE(encountered operating system error 5(failed to retrieve text for this reason : 15105) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\AdventureWorksDW2008.mdf' (Microsoft SQL Server, Error: 5123)
Any idea how I can solve this issue is greatly appreciated.