29 October 2013

Database is Read-Only

Problem: After attaching a database to MS SQL Server, the database is displayed as 'Read-Only'.

Description: I created a folder on volume E:\, and put the database I downloaded from SysAid in the folder. After I attached the database to MS SQL Server, the database was displayed as 'Read-Only'.

Solution: Grant 'Everyone' 'Full Control' access to the folder, then attach it.

No comments:

Post a Comment