Access denied while trying to attach database file

I just found that when trying to attach a database in SQL Server 2008 Express edition installed on Windows 7 user would encounter following error. ("CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file...")


Try starting the SQL Server Management Studio as Administrator account.


Now attach the required database file.

Comments

Make Money from Surveys

Popular posts from this blog

Schema.Object has an unresolved reference to Schema

The current master key cannot be decrypted

There is insufficient memory available in the buffer pool